Error Log Management
Thought I’d write a quick post about managing error logs within SQL Server. Good error log management is essential for...
2014-05-09
2,404 reads
Blog Posts
Friday Followup For May 9, 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-05-09
427 reads
Monthly Reflections – April 2014
April was quite a busy month and so apart from the last reflections post and TSQL Tuesday entry Why So Serious...
2014-05-09
679 reads
Off to Jacksonville for SQLSaturday #298
I’m looking forward to returning to Jacksonville after missing a year (or two?) to speak at SQLSaturday #298. I’m driving...
2014-05-09
338 reads
Power Query to HDFS – Remote Name Could Not Be Resolved
I wanted to share a quick resolution I had to a problem with connecting Power Query to data stored in...
2014-05-09 (first published: 2014-05-02)
2,081 reads
Presentation Slides for Building an Effective Data Warehouse Architecture
Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” at the PASS Business Analytics conference. The abstract is below. I...
2014-05-09
937 reads
Quick Snapshot
The idea for this script came at times when I was having a project that needed to use snapshots of databases...
2014-05-09
108 reads
Reblog: May 2 to May 8
Photo credit – Mike Lynch
A good cure to a creepy doll is a good old post that is still useful. In...
2014-05-09
924 reads
Script for database snapshot
The idea for this script came at a time when I was having a project that needed to use snapshots...
2014-05-09
100 reads
SQL Saturday #308 – Houston TX Presentation
Tabular Data Visualized by Power View
I am presenting this Saturday 5/10/2014 at 4PM at the Houston TX SQL Saturday Event. ...
2014-05-09
708 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