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,479 reads
Blog Posts
SSISDB for SQL Server Integration Services
Microsoft introduced some major changes in SQL Server Integration Services with SQL Server 2012.
Brand new “SSISDB” database launched as SSIS...
2017-11-16 (first published: 2017-11-06)
24,081 reads
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,490 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
443 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
348 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
37 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
39 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
3 reads
Creating a Linked Server to an Azure SQL Database
Why would you create a Linked Server to an Azure SQL Database?
If you work in a hybrid environment with some...
2017-11-15
1,346 reads
Do Not Pass GO!
What is the GO statement and why is it so important to use? When do I have to use it?...
2017-11-15
1,069 reads
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Forums
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
What's the Date?
Comments posted to this topic are about the item What's the Date?
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers