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
499 reads
Blog Posts
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,931 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,157 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,365 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,614 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,291 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,032 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,123 reads
What I Wish I Had Known Sooner…as a DBA
Yesterday I took a minute and to review some posts by some Data Professionals and in doing so I came...
2014-08-28
1,104 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers