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...

Dates and Times in SQL Server: more functions you should never use

Previously we looked at four built-in functions to get the current date and time in SQL Server and Azure SQL...

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...

How to pass data between procedures using temp tables.

In this post I will show how in some cases we can split a long procedure to a small and...

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...

PoshSSDTBuildDeploy Updated - Now With Pester Tests

Hello!
Some weeks ago I got the tests working on the CI build for PoshSSDTBuildDeploy. The tests were a bit of a mish mash, however they sort of did the...

Pushing SQL Server images to the Azure Container Registry

The Azure Container Registry is an online repository for storing Docker images (think the Docker Hub).
What’s cool about this is...

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...

The public role

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

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...