Enforcing T-SQL quality with SSDT Analysis Extensions
What? Simply put, it is possible to include checks in the SSDT (Sql Server Data Tools) build process - you come...
2014-12-30
217 reads
Blog Posts
Enforcing T-SQL quality with SSDT Analysis Extensions
What? Simply put, it is possible to include checks in the SSDT (Sql Server Data Tools) build process - you come...
2014-12-30
210 reads
Enforcing T-SQL quality with SSDT Analysis Extensions
What? Simply put, it is possible to include checks in the SSDT (Sql Server Data Tools) build process - you come up with a set of rules or start...
2014-12-30
10 reads
Speaking Stats
I was updating my speaking schedule and CV, trying to get an idea of what might be planned for 2015....
2014-12-30
1,061 reads
T-SQL – How to Find Number of Words in a Given String
TSQL: To find number of words in a given string
Download the codehttps://gallery.technet.microsoft.com/T-SQL-How-to-Find-Number-533b6b39
DECLARE @DemoTable Table
(Col varchar(500));
INSERT INTO @DemoTable (Col)VALUES ('JOHN...
2014-12-30 (first published: 2014-12-26)
8,357 reads
T-SQL COALESCE Example
T-SQL COALESCE
SQL Server T-SQL coalesce simplifies the use of a case statement to find the first non-null value of your...
2014-12-30 (first published: 2014-12-26)
9,004 reads
“Pretty Plans vs. Performance” or “Grant Gets Pwned”
If you get an execution plan that looks like this:
I wouldn’t blame you for immediately thinking about query tuning. Especially...
2014-12-29 (first published: 2014-12-19)
6,158 reads
Brand Level Zero
It’s that time of year when people look back on the past year(s) and think about what they have and...
2014-12-29
810 reads
Do you want to build an Audit?
So I’ve written my second article for SQL Shack. This time instead of an overview of auditing options in sql...
2014-12-29
1,209 reads
SQL Server 2014 Best Practice: Set built-in Sysadmin(sa) account as an default owner of all databases on SQL Server instance
As we know, when we create database on SQL Server instance, SQL Server engine sets the login that created the database as the default database owner. This gives the...
2014-12-28
7 reads
Blogs
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...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
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