POSTPONED to 02/11 - Speaking at the Omaha SQL Server User Group *Tomorrow* Night!
UPDATE - due to weather conditions today (snow this AM and sub-zero cold tonight) we are postponed to next Wednesday 02/11...
2015-02-03
918 reads
Blog Posts
The most recent backup problem
When I first began this blog, back at the beginning of my DBA career, it was purely a place for...
2015-02-03
649 reads
TSQL Tuesday #63 – How do you manage security?
Come on down! You’re the next contestant on T-SQL Tuesday! I’m your host Kenneth Fisher and this month I’d thought...
2015-02-03
928 reads
Blame it on Connect
Some weeks ago I blogged about the discouraging signals coming from Connect and my post started a discussion that didn’t...
2015-02-02
550 reads
How to Rebuild MSDB database?
I suggest to have regular full backup of your system database along with user database. But if you do not have system database & your MSDB got corrupted then...
2015-02-02
3 reads
How to Rebuild MSDB database?
I suggest to have regular full backup of your system database along with user database. But if you do not...
2015-02-02
10,561 reads
Mentor blog
I have been following a few blogs for a number of years now, and one of the most enjoying blog...
2015-02-02
287 reads
Parsing SQL Saturday Data – Getting the Titles
I wrote about downloading the SQL Saturday data with Powershell, and that has worked well. However, I also need to...
2015-02-02
930 reads
PowerPoint Slides Available for Download
I promised that I would post the slide decks for my presentations, and now I have finally followed through on...
2015-02-02
685 reads
SQL #58–Where are my own templates in SQL Server Management Studio 2012
The secrete SQLFile.sql
We are all so used to clicking on the New Query icon (or the keyboard shortcut Ctrl+N). We know it...
2015-02-02 (first published: 2015-01-27)
13,433 reads
Blogs
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
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