Parameterization Part 3: Parameter Sniffing
This is the third post in the “Parameterization” series. In the previous post I mentioned parameter sniffing. This is a...
2014-09-01
1,396 reads
Blog Posts
September 2014 – SQL Server Monthly Maintenance Checklist
image source
It’s time for a monthly reminder to review you SQL Server environment. As with anything, just because it appears...
2014-09-01
506 reads
Automated Source Control: A Librarian For Your Database Objects, Part 2
I assume that by now you’ve tried the script from Part 1, and have seen how easy it is to...
2014-08-29 (first published: 2014-08-25)
6,936 reads
Friday Followup For August 29, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-08-29
1,162 reads
Reblog: August 22 to August 28
Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...
2014-08-29
1,366 reads
Continuous Integration/Delivery without Testing!
Anything we can do to automate our builds and deployment should be considered. After all, the point isn’t just to...
2014-08-28 (first published: 2014-08-25)
7,615 reads
Dear IT Guy, Why do you hesitate to attend my meetings?
I was attending Microsoft’s on-boarding training last week and one of the managers there mentioned that a lot of IT...
2014-08-28
868 reads
I Didn’t Hyperventilate!
I gave what is officially my second presentation this week. I presented at the Triad SQL BI (Twitter | PASS) user...
2014-08-28
1,296 reads
My SQLBits Session Recordings
Last month, I had the pleasure of presenting two of my favorite sessions at the SQLBits conference in Telford, UK.
A few days...
2014-08-28
1,039 reads
Parameterization Part 2: Seven Ways to Execute Your Query
This is the second post in my series on parameterization. In the first post I wrote about plan caching and...
2014-08-28 (first published: 2014-08-25)
9,129 reads
Blogs
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Claude Desktop
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Forums
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Comments posted to this topic are about the item Unraveling the Mysteries of the...
QUOTENAME Behavior
Comments posted to this topic are about the item QUOTENAME Behavior
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Question of the Day
QUOTENAME Behavior
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers