Recruitment Agents are not bad people...despite what you might read
Welcome to WIN at IT contracting: A FREE guide showing YOU How to get the most out of Recruitment Agent...
2018-03-22
366 reads
Blog Posts
SQL Vulnerability Assessment for Azure SQL Database
Back in September 2017 Microsoft announced a new security feature for Azure SQL Database called the SQL Vulnerability Assessment (VA)....
2018-03-22
997 reads
Dates and Times in SQL Server: DATETIME2
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data...
2018-03-21
341 reads
Extended Events File Initialization Failure
It should come as no surprise that I write a lot of articles about Extended Events (XE). This happens to...
2018-03-21 (first published: 2018-03-09)
5,828 reads
Moving a table using BCP and native format
You need to move a table from one instance to another with the following requirements:
The instances are on separate domains....
2018-03-21
368 reads
PowerShell script repository - SQL Server
A simple get-help output
PowerShell is a .Net based command line tool designed for automation.
It is recommended to script repetitive task...
2018-03-21
303 reads
Redgate SQL Test utility isn’t showing up in SSMS
I had recently installed the SQL Toolbelt from Redgate at a client site on a laptop they’d supplied me.
(Fantastic product...
2018-03-21
375 reads
SQL Performance – Using Query Hint OPTION (FAST N)
It is fun working with SQL/Application developer where you exchange a lot of technical thoughts to find the root of...
2018-03-21
7,311 reads
SQL Server Data Management Life Cycle
This is the second article in the “Backup and Restore (or Recovery) in SQL Server” stairway series (see the full...
2018-03-21
313 reads
Troubleshooting SQL Server Error 15517
Last week I had the following error message repeating over and over again in the SQL Server log of one of...
2018-03-21 (first published: 2013-04-22)
59,896 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
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:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
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