Variables in Dynamic SQL
I had someone ask me about this the other day. Specifically getting variable data out of a dynamic SQL statement....
2017-11-16
1,500 reads
SQL Smackdown!!! Cursors VS Loops
Ladies and Gentlemen, welcome to the main event of the evening. The SQL Undercover Smackdown Heavy Weight Championship of the...
2017-11-16
2,529 reads
Write Your first Pester Test Today
I was in Glasgow this Friday enjoying the fantastic hospitality of the Glasgow SQL User Group@SQLGlasgow and presenting sessions with Andre...
2017-11-16
454 reads
You have your database in source control now what?
This post is for a specific type of person if you are:
New to source controlAre getting started on your path...
2017-11-16
364 reads
You have your database in source control now what?
This post is for a specific type of person if you are:
New to source control Are getting started on your path to the continuous delivery nirvana Have been...
2017-11-16
11 reads
You have your database in source control now what?
This post is for a specific type of person if you are:
New to source control Are getting started on...
2017-11-16
42 reads
You have your database in source control now what?
This post is for a specific type of person if you are:
New to source control Are getting started on...
2017-11-16
40 reads
How To Enlarge Your Columns With No Downtime
Let’s face it: column enlargement is a very sensitive topic. I get thousands of emails every month on this particular...
2017-11-15
968 reads
Microsoft Connect(); announcements
Microsoft Connect(); is a developer event from Nov 15-17, where plenty of announcements are made. Here is a summary of the data...
2017-11-15
88 reads
Microsoft Connect(); announcements
Microsoft Connect(); is a developer event from Nov 15-17, where plenty of announcements are made. Here is a summary of the data...
2017-11-15
544 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
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers