Finding Date Ranges for Calculating Statistics
Finding Date Ranges for Calculating StatisticsI received the following question from a fellow DBA:
I need your input to derive the...
2010-03-14
1,703 reads
Blog Posts
Setting Up a Server Side Trace
Recently I wrote a short post on the default trace in SQL Server. You can read that here. In this...
2010-03-14
14,749 reads
Twas the Night Before the MCM ...
T'was the Night Before the MCM ...
SQL Server MCM starts tomorrow. My wife thinks it's cute that I'm excited. The...
2010-03-14
970 reads
Document, Document, Document
A while back I blogged about using Checklists , but there's another task you want to incorporate into your workflow - documentation....
2010-03-13
1,203 reads
Another Presentation Down
This evening I had the opportunity to once again give a presentation at our local SQL Uses Group (SSSOLV). I...
2010-03-12
623 reads
Business needs vs dirty reads
I have worked in many industries, but most of my time has been in the publishing industry. For those not...
2010-03-12
289 reads
Don’t Be a Shock Jock
One of the dangers of being an “Internet Journalist” or even just a blogger, is that you might compromise who...
2010-03-12
1,012 reads
Great Turnout for The Montreal XV's First Practice - Rugby XV de Montréal Première pratique
The Montreal XV Rugby Club (rejuvinating the Rugby Football Club name from the 1920s) first practice was the other night at Collège Marie...
2010-03-12
797 reads
My Experience with a Virtual Assistant using TimeSvr
Predicting the future with bold certainty is not for the faint of heart. It’s a hard job. A few get...
2010-03-12
966 reads
No Green Compromises
I saw this blog about an Accenture survey of potential car buyers. It mentions that people likely won’t buy a...
2010-03-12
923 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