Sql Hints #1 - Don’t update Primary Key values
Recently I had the chance to take a look at a problematic query in an application. I caught the query...
2015-11-11
110 reads
Blog Posts
SQL Server 2016 CTP 3 Setup – UI Improvements
There are some improvements in the setup UI for SQL Server 2016 CTP3, and its great to see Microsoft making...
2015-11-11
816 reads
Support for SSMS 2016 now available
Good news!
Red-Gate published new version of its SIPF framework with support of SSMS 2016!
Now you can simply download and install...
2015-11-11
563 reads
Updating Extended Properties
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as#SQLNewBloggers.
I...
2015-11-11
639 reads
Veterans Day – Thank You for Your Service
If you currently serve or have served in our military, thank you for your service. Please never doubt that your...
2015-11-11
428 reads
Webinar: Unit Testing with SQL Server and tSQLt
I ran into Sebastian Meine at the PASS Summit a few weeks ago and we were talking testing. Sebastian is...
2015-11-11
676 reads
Why you should not update Primary Key values
Recently I had the chance to take a look at a problematic query in an application. I caught the query...
2015-11-11
3,423 reads
Why you should not update Primary Key values
Recently I had the chance to take a look at a problematic query in an application. I caught the query in profiler and it’s the following: [crayon-5e81b52edda2c602772598/] The query...
2015-11-11
10 reads
Why you should not update Primary Key values
Recently I had the chance to take a look at a problematic query in an application. I caught the query in profiler and it’s the following: [crayon-5e9656615f713397718274/] The query...
2015-11-11
11 reads
More Thoughts on the PASS BAC
Here’s an excerpt from an email from PASS I received on November 4 and also available at this link (bolding added by...
2015-11-10
485 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
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...
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