My Visit to WPC 2014
Last week I attended WPC. This is an annual event organized by Microsoft for its partners around the world. WPC...
2014-07-24
461 reads
Blog Posts
Quick Tips–SQL Prompt Aliases for Every Table
I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love...
2014-07-24 (first published: 2014-07-17)
9,802 reads
SQL PASS Performance Palooza 2014 Wrap-Up
Today I presented a fun session for the SQL PASSPerformance Virtual Chapter’s “Summer Performance Palooza 2014” entitled “Infrastructure Tuning for...
2014-07-24
491 reads
T-SQL Window Functions – Part 4: Analytic Functions
This is a reprint with some revisions of a series I originally published on LessThanDot. You can find the links...
2014-07-24 (first published: 2014-07-17)
11,149 reads
5 Tips for Finding SQL Server System Data
Regardless of the type of development (application or reporting) that you are performing on SQL Server. There are 5 items...
2014-07-23 (first published: 2014-07-17)
9,736 reads
Building the SQLSaturday Orlando Marketing Plan-Part 25
Just the chart today. We’re considerably ahead of previous year registrations for the same number of weeks out. I’m looking...
2014-07-23
477 reads
Challenge Accepted
There seemed to be some question whether my comfort level with my own masculinity would prevent me from wearing these:
Oh...
2014-07-23
706 reads
Cumulative Update – 11 for SQL Server 2012 Service Pack 1 Is Now Available !
The 11th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 11 contains all the hotfixes...
2014-07-23
6 reads
Cumulative Update – 11 for SQL Server 2012 Service Pack 1 Is Now Available !
The 11th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft...
2014-07-23
708 reads
My Visit to Redmond
Last week, I had the pleasure of attending the EBC in Redmond. If you don’t know what EBC is, that’s...
2014-07-23
547 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