Query Predicates

Sometimes people speak “SQL” and expect you know all the terminology. In recent a conversation about query plans I was...

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

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