\documentclass[10pt,a4paper]{article}

% Packages
\usepackage{fancyhdr}           % For header and footer
\usepackage{multicol}           % Allows multicols in tables
\usepackage{tabularx}           % Intelligent column widths
\usepackage{tabulary}           % Used in header and footer
\usepackage{hhline}             % Border under tables
\usepackage{graphicx}           % For images
\usepackage{xcolor}             % For hex colours
%\usepackage[utf8x]{inputenc}    % For unicode character support
\usepackage[T1]{fontenc}        % Without this we get weird character replacements
\usepackage{colortbl}           % For coloured tables
\usepackage{setspace}           % For line height
\usepackage{lastpage}           % Needed for total page number
\usepackage{seqsplit}           % Splits long words.
%\usepackage{opensans}          % Can't make this work so far. Shame. Would be lovely.
\usepackage[normalem]{ulem}     % For underlining links
% Most of the following are not required for the majority
% of cheat sheets but are needed for some symbol support.
\usepackage{amsmath}            % Symbols
\usepackage{MnSymbol}           % Symbols
\usepackage{wasysym}            % Symbols
%\usepackage[english,german,french,spanish,italian]{babel}              % Languages

% Document Info
\author{simondk99}
\pdfinfo{
  /Title (serverteknologi-sql-grp4.pdf)
  /Creator (Cheatography)
  /Author (simondk99)
  /Subject (Serverteknologi SQL GRP4 Cheat Sheet)
}

% Lengths and widths
\addtolength{\textwidth}{6cm}
\addtolength{\textheight}{-1cm}
\addtolength{\hoffset}{-3cm}
\addtolength{\voffset}{-2cm}
\setlength{\tabcolsep}{0.2cm} % Space between columns
\setlength{\headsep}{-12pt} % Reduce space between header and content
\setlength{\headheight}{85pt} % If less, LaTeX automatically increases it
\renewcommand{\footrulewidth}{0pt} % Remove footer line
\renewcommand{\headrulewidth}{0pt} % Remove header line
\renewcommand{\seqinsert}{\ifmmode\allowbreak\else\-\fi} % Hyphens in seqsplit
% This two commands together give roughly
% the right line height in the tables
\renewcommand{\arraystretch}{1.3}
\onehalfspacing

% Commands
\newcommand{\SetRowColor}[1]{\noalign{\gdef\RowColorName{#1}}\rowcolor{\RowColorName}} % Shortcut for row colour
\newcommand{\mymulticolumn}[3]{\multicolumn{#1}{>{\columncolor{\RowColorName}}#2}{#3}} % For coloured multi-cols
\newcolumntype{x}[1]{>{\raggedright}p{#1}} % New column types for ragged-right paragraph columns
\newcommand{\tn}{\tabularnewline} % Required as custom column type in use

% Font and Colours
\definecolor{HeadBackground}{HTML}{333333}
\definecolor{FootBackground}{HTML}{666666}
\definecolor{TextColor}{HTML}{333333}
\definecolor{DarkBackground}{HTML}{FF5600}
\definecolor{LightBackground}{HTML}{FFF4EF}
\renewcommand{\familydefault}{\sfdefault}
\color{TextColor}

% Header and Footer
\pagestyle{fancy}
\fancyhead{} % Set header to blank
\fancyfoot{} % Set footer to blank
\fancyhead[L]{
\noindent
\begin{multicols}{3}
\begin{tabulary}{5.8cm}{C}
    \SetRowColor{DarkBackground}
    \vspace{-7pt}
    {\parbox{\dimexpr\textwidth-2\fboxsep\relax}{\noindent
        \hspace*{-6pt}\includegraphics[width=5.8cm]{/web/www.cheatography.com/public/images/cheatography_logo.pdf}}
    }
\end{tabulary}
\columnbreak
\begin{tabulary}{11cm}{L}
    \vspace{-2pt}\large{\bf{\textcolor{DarkBackground}{\textrm{Serverteknologi SQL GRP4 Cheat Sheet}}}} \\
    \normalsize{by \textcolor{DarkBackground}{simondk99} via \textcolor{DarkBackground}{\uline{cheatography.com/67438/cs/16983/}}}
\end{tabulary}
\end{multicols}}

\fancyfoot[L]{ \footnotesize
\noindent
\begin{multicols}{3}
\begin{tabulary}{5.8cm}{LL}
  \SetRowColor{FootBackground}
  \mymulticolumn{2}{p{5.377cm}}{\bf\textcolor{white}{Cheatographer}}  \\
  \vspace{-2pt}simondk99 \\
  \uline{cheatography.com/simondk99} \\
  \end{tabulary}
\vfill
\columnbreak
\begin{tabulary}{5.8cm}{L}
  \SetRowColor{FootBackground}
  \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Cheat Sheet}}  \\
   \vspace{-2pt}Not Yet Published.\\
   Updated 7th September, 2018.\\
   Page {\thepage} of \pageref{LastPage}.
\end{tabulary}
\vfill
\columnbreak
\begin{tabulary}{5.8cm}{L}
  \SetRowColor{FootBackground}
  \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Sponsor}}  \\
  \SetRowColor{white}
  \vspace{-5pt}
  %\includegraphics[width=48px,height=48px]{dave.jpeg}
  Measure your website readability!\\
  www.readability-score.com
\end{tabulary}
\end{multicols}}




\begin{document}
\raggedright
\raggedcolumns

% Set font size to small. Switch to any value
% from this page to resize cheat sheet text:
% www.emerson.emory.edu/services/latex/latex_169.html
\footnotesize % Small font.

\begin{multicols*}{2}

\begin{tabularx}{8.4cm}{p{0.96 cm} x{7.04 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{VMware host specs}}  \tn
% Row 0
\SetRowColor{LightBackground}
CPU: & i5-6300U | 4 kerner | 2,5 GHz \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
RAM: & 16 GB DDR3 \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
SSD: & 256 GB \tn 
% Row Count 3 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{3.52 cm} x{4.48 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{VM1: Windows Server 2016}}  \tn
% Row 0
\SetRowColor{LightBackground}
Description: & AD, DNS, DHCP \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
CPU: & 1 processor | 1 kerne \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
RAM: & 4 GB \tn 
% Row Count 3 (+ 1)
% Row 3
\SetRowColor{white}
SSD: & 60 GB (Dynamisk) \tn 
% Row Count 4 (+ 1)
% Row 4
\SetRowColor{LightBackground}
IP Konfiguration: & Statisk - 192.168.4.10 \tn 
% Row Count 5 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{3.6 cm} x{4.4 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{VM3: Windows Server 2016}}  \tn
% Row 0
\SetRowColor{LightBackground}
Description: & Los Angeles \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
CPU: & 1 processor | 1 kerne \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
RAM: & 2 GB \tn 
% Row Count 3 (+ 1)
% Row 3
\SetRowColor{white}
SSD: & 60 GB (Dynamisk) \tn 
% Row Count 4 (+ 1)
% Row 4
\SetRowColor{LightBackground}
IP Konfiguration: & DHCP \tn 
% Row Count 5 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{3.6 cm} x{4.4 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{VM2: Windows Server 2016}}  \tn
% Row 0
\SetRowColor{LightBackground}
Description: & Newyork \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
CPU: & 1 Processor | 1 Kerne \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
RAM: & 2 GB DDR3 \tn 
% Row Count 3 (+ 1)
% Row 3
\SetRowColor{white}
SSD: & 60 GB (Dynamisk) \tn 
% Row Count 4 (+ 1)
% Row 4
\SetRowColor{LightBackground}
IP Konfiguration: & DHCP \tn 
% Row Count 5 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{3.6 cm} x{4.4 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{VM4: Windows 10 Pro}}  \tn
% Row 0
\SetRowColor{LightBackground}
Description: & Klient PC \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
CPU: & 1 processor | 1 kerne \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
RAM: & 2 GB \tn 
% Row Count 3 (+ 1)
% Row 3
\SetRowColor{white}
SSD: & 60 GB (Dynamisk) \tn 
% Row Count 4 (+ 1)
% Row 4
\SetRowColor{LightBackground}
IP Konfiguration: & DHCP \tn 
% Row Count 5 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{3.6 cm} x{4.4 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{VM5: Windows server 2016}}  \tn
% Row 0
\SetRowColor{LightBackground}
Description: & Host \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
CPU: & 1 Processor | 1 Kerne \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
RAM: & 2 GB DDR3 \tn 
% Row Count 3 (+ 1)
% Row 3
\SetRowColor{white}
SSD: & 60 GB (Dynamisk) \tn 
% Row Count 4 (+ 1)
% Row 4
\SetRowColor{LightBackground}
IP Konfiguration: & Statisk - 192.168.4.2 \tn 
% Row Count 5 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{2.48 cm} x{5.52 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{Active Directory}}  \tn
% Row 0
\SetRowColor{LightBackground}
Domæne Navn: & ZBC4.local \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
Oprettede Brugere: & Ole Hansen, Lis Petersen, Lars Larsen \& Adrian \tn 
% Row Count 4 (+ 2)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{2.32 cm} x{5.68 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{DNS opsætning}}  \tn
% Row 0
\SetRowColor{LightBackground}
Server: & VM1, 192.168.4.10 \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
FLZ: & grp5-local \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
RLZ & Ingen \tn 
% Row Count 3 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{2.72 cm} x{5.28 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{DHCP}}  \tn
% Row 0
\SetRowColor{LightBackground}
Domæne Navn: & zbc4.local \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
Scope Navn: & ZBC4 \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
Scope Range: & 192.168.4.1 - 192.168.4.254 \tn 
% Row Count 4 (+ 2)
% Row 3
\SetRowColor{white}
Subnet Mask: & 255.255.255.0 \tn 
% Row Count 5 (+ 1)
% Row 4
\SetRowColor{LightBackground}
Excluded IP's: & 192.168.4.1 - 192.168.4.31 \tn 
% Row Count 7 (+ 2)
% Row 5
\SetRowColor{white}
Lease: & 8 dage \tn 
% Row Count 8 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Database?}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{1}{x{8.4cm}}{En Database er et sted hvor man kan samle data. En database er delt op i tabeller og skemaer, som gør det nemmere at tilgå, styre og opdatere. En database gør data meget mere overskueligt og organiseret.} \tn 
% Row Count 5 (+ 5)
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Relationsdatabase?}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{1}{x{8.4cm}}{En database hvor ting er organiseret i tabeller (relationer).} \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
\mymulticolumn{1}{x{8.4cm}}{I relationsdatabaser opstår der færre fejl og det er samtidig lettere at vedligeholde data ift. en konvertionel database.} \tn 
% Row Count 5 (+ 3)
% Row 2
\SetRowColor{LightBackground}
\mymulticolumn{1}{x{8.4cm}}{En database består af et antal tabeller (relationer). En tabel har et antal felter (attributter) og kan indeholde et antal rækker/records (tupler). Felter indeholder kun taomiske værdier. Rækker i tabeller kan knyttes sammen udfra felter med samme værdi.} \tn 
% Row Count 11 (+ 6)
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{2.72 cm} x{5.28 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{Hardware Krav til Microsoft SQL}}  \tn
% Row 0
\SetRowColor{LightBackground}
.NET Framework: & SQL Server 2016 og efter kræver .NET Framework 4.6 til Database Engine, Master Data Service eller Replication \tn 
% Row Count 5 (+ 5)
% Row 1
\SetRowColor{white}
HDD/SSD: & Microsoft SQL skal mindst have 6GB fri disk plads \tn 
% Row Count 7 (+ 2)
% Row 2
\SetRowColor{LightBackground}
DVD Drev: & Et DVD Drev er ikke nødvendigt, men det er en god ting hvis man skal installere det fra en DVD \tn 
% Row Count 11 (+ 4)
% Row 3
\SetRowColor{white}
Skærm Opløsning: & Microsoft SQL kræver Super-VGA (800x600) eller højere \tn 
% Row Count 14 (+ 3)
% Row 4
\SetRowColor{LightBackground}
Internet: & Internet er ikke nødvendigt, men det skal bruges for at kunne bruge internet funktionerne \tn 
% Row Count 18 (+ 4)
% Row 5
\SetRowColor{white}
Management studio & Microsoft SQL Mangement Studio installation kræver .NET 4.6.1 \tn 
% Row Count 21 (+ 3)
% Row 6
\SetRowColor{LightBackground}
SQL Server Installere & SQL Server Native Client \& SQL Server Setup support files \tn 
% Row Count 24 (+ 3)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{2.4 cm} x{5.6 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{Microsoft SQL Sikkerhedsattributer}}  \tn
% Row 0
\SetRowColor{LightBackground}
db\_owner & Kan foretage alle ønskede ændringer på databasen \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
\seqsplit{db\_securityadmin} & Kan foretage ønskede ændringer i sikkerhedsgrupper på medlemmer \tn 
% Row Count 5 (+ 3)
% Row 2
\SetRowColor{LightBackground}
\seqsplit{db\_accessadmin} & Kan foretage ønskede ændringer for adgang til databasen \tn 
% Row Count 8 (+ 3)
% Row 3
\SetRowColor{white}
\seqsplit{db\_backupoperator} & Kan foretage ønskede backup af databasen \tn 
% Row Count 10 (+ 2)
% Row 4
\SetRowColor{LightBackground}
db\_ddladmin & Kan foretage DDL commands i databasen \tn 
% Row Count 12 (+ 2)
% Row 5
\SetRowColor{white}
\seqsplit{db\_datawriter} & Kan foretage ændringer i data i databasen \tn 
% Row Count 14 (+ 2)
% Row 6
\SetRowColor{LightBackground}
\seqsplit{db\_datareader} & Kan læse data i databasen \tn 
% Row Count 16 (+ 2)
% Row 7
\SetRowColor{white}
\seqsplit{db\_denydatawriter} & Kan ikke foretage ændringer i data i databasen \tn 
% Row Count 18 (+ 2)
% Row 8
\SetRowColor{LightBackground}
\seqsplit{db\_denydatareader} & Kan ikke læse data i databasen \tn 
% Row Count 20 (+ 2)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{3.28 cm} x{4.72 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{Backup SQL Database}}  \tn
% Row 0
\SetRowColor{LightBackground}
Backup & Backup det en samling af data / databse. MS SQL server-Database sikkerhedskopiering er afgørende for at beskytte data. Der 3 forskellige typer sikkerhedskopiering der er ( Fuld database) (Differential eller incremental)  og (Transaction Log ). \tn 
% Row Count 11 (+ 11)
% Row 1
\SetRowColor{white}
FULL & fks.Backup databse DB2 to disk. ='D\textbackslash{}DB2\_Full.bak' \tn 
% Row Count 14 (+ 3)
% Row 2
\SetRowColor{LightBackground}
Differential & backup af database \textless{}dit database navn\textgreater{} to disk ='\textless{}Backup til lokation +fil navn\textgreater{}' with differential \tn 
% Row Count 19 (+ 5)
% Row 3
\SetRowColor{white}
LOG & log backup. \textless{}dit databsenavn\textgreater{} to disk = 'backup fil lokation + fil navn\textgreater{} \tn 
% Row Count 23 (+ 4)
% Row 4
\SetRowColor{LightBackground}
SQL Server management backup & for at udføre backup med server management skal der connectes til serveren derefter klik på backup. Og derfra ville man kunne se hvilke mulighed man har for backup. Og hvor den skal gemmes \tn 
% Row Count 32 (+ 9)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{3.12 cm} x{4.88 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{Log filer og Monitorering}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{{\bf{Log filer}}} \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
\seqsplit{Transaktionslog} & Alle SQL servere benytter en transaktionslog, som registrerer alle transaktioner \tn 
% Row Count 5 (+ 4)
% Row 2
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{Transaktionsloggen kan bruges til følgende:} \tn 
% Row Count 6 (+ 1)
% Row 3
\SetRowColor{white}
 & {\emph{Individuel transaktions gendannelse}} \tn 
% Row Count 8 (+ 2)
% Row 4
\SetRowColor{LightBackground}
 & {\emph{Gendannelse af alle beskadige transaktioner, når SQL serveren startes}} \tn 
% Row Count 11 (+ 3)
% Row 5
\SetRowColor{white}
 & {\emph{Transaktions replication}} \tn 
% Row Count 13 (+ 2)
% Row 6
\SetRowColor{LightBackground}
 & {\emph{Rollback af backup efter harddisk fejl eller lignende}} \tn 
% Row Count 16 (+ 3)
% Row 7
\SetRowColor{white}
\mymulticolumn{2}{x{8.4cm}}{{\bf{Monitorering}}} \tn 
% Row Count 17 (+ 1)
% Row 8
\SetRowColor{LightBackground}
Logbog / Error log & Error loggen bruges som i et normal Windows miljø, hvor alle begivenheder logges og kan læses \tn 
% Row Count 21 (+ 4)
% Row 9
\SetRowColor{white}
SQL Backup Status Reporter & Giver mulighed for at se på backup historikken, så man kan få et overblik over hvordan backuppen køres. \tn 
% Row Count 26 (+ 5)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}


% That's all folks
\end{multicols*}

\end{document}