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...
2018-05-23
482 reads
The public role
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
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
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.
In this post I will show how in some cases we can split a long procedure to a small and...
2018-05-23
1,792 reads
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...
2018-05-23
32 reads
Backup Linux/windows SQL Server databases using PowerShell and Windows task scheduler
This article is an in-depth guide on how PowerShell can be used to maintain and manage SQL backup on Linux...
2018-05-31 (first published: 2018-05-22)
2,091 reads
SQL Saturday – Dallas – May 2018
I was able to present at SQL Saturday Dallas this year. Thanks to those of you who were able to...
2018-05-22
207 reads
SQL Saturday Iowa City Precon June 22
I’m extremely proud to announce that I have been selected to present an all-new preconference training session on Friday, June...
2018-05-22
287 reads
Update Oddness for SQL Server
I’ve been meaning to patch some of my development instances. With a little spare time while doing other work, I...
2018-05-22
331 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Absolute and Relative References
Comments posted to this topic are about the item Absolute and Relative References
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Reserved Words I
Comments posted to this topic are about the item Reserved Words I