Toolbox - How Long Has My Server Been Up?

https://imgflip.com/i/2axp6yNo..not that Up (although it is awesome!)

--

As a remote service provider a common request is to follow up after a server...

Tips for Securing SQL Server Database from All Sort of Risks

Securing SQL Server Database is a challenging task as there are number of external and internal risks or parameters affecting the Server and its databases. In this section, we...

Tips for Securing SQL Server Database from All Sort of Risks

Securing SQL Server Database is a challenging task as there are number of external and internal risks or parameters affecting...

SSAS Tabular – Fact Table Key Columns Datatype Impact

Intro
I’m working on a solution where warehouse uses string codes as the keys for dimensions. Therefore the fact table is...

Thoughts on Query Performance with TDE enabled

Microsoft state that enabling TDE (Transparent Data Encryption) usually has a performance  overhead of 2-4%. That doesn’t sound like very...

Day 23 Replication

Replication means making copy of the objects and moving transaction from primary server to secondary/standby/Slave server. There are two type...

Jobs in PoSh to Create a Load

I saw this from Argenis Fernandez, and thought it was wonderful.
1..128 | % { start-job -name ‘job name’ -scriptblock { & sqlcmd -S instanceName -U...

Virtual Log Files: 200 or 1000?

Last week I had the privilege of reviewing possibly the best SQL Server production environment I’ve seen in Canada. During...

The public role

A common misunderstanding is that the CONNECT permission lets you do more than just connect to a database. It doesn’t....

dbachecks – Save the results to a database for historical reporting

I gave a presentation at SQL Day in Poland last week on dbachecks and one of the questions I got...