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

2018-05-23

823 reads

Virtual Log Files: 200 or 1000?

by Randolph West

Born SQL with Randolph West

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

2018-05-23

482 reads

The public role

by Kenneth Fisher

SQLStudies

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

2018-05-23

473 reads

dbachecks – Save the results to a database for historical reporting

by Rob Sewell

SQL DBA With A Beard

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

2018-05-31 (first published: 2018-05-23)

3,066 reads

Deploying Azure Container Instances

by Andrew Pruski

The DBA Who Came In From The Cold

In a previous post I went through how to Push an image to the Azure Container Registry
Now let’s look at...

2018-06-04 (first published: 2018-05-23)

2,075 reads

How to pass data between procedures using temp tables.

by faiggarayev

SQL Design Patterns

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

2018-05-23

1,793 reads

PoshSSDTBuildDeploy Updated - Now With Pester Tests

by Richie Lee

Richie Lee's SQL Stuff

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

2018-05-23

32 reads