A Month, Almost Two Months Offline–Was the Silence Deafening?
The past couple of months has been very busy at home and at work so I have fallen behind a...
2014-06-18
699 reads
Blog Posts
Configuring the In-Memory OLTP File Group for High Performance
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-06-18 (first published: 2014-06-16)
2,978 reads
Microsoft's Lousy Response to a Connect Issue
I’ve been going through the process of upgrading from SQL Server 2012 to SQL Server 2014 and I’ve hit a bug when running snapshots. Any snapshot that was in...
2014-06-18
4 reads
Building The SQLSaturday Orlando Marketing Plan-Part 18
I’m on vacation this week, but enjoying some quiet time during the day to think a little, going back through...
2014-06-17
750 reads
Business Intelligence Roles and Team Composition
On Business Intelligence projects of all sizes, the composition of the team is a crucial element for success. What is...
2014-06-17
468 reads
ITPROceed – Slide Deck and demo materials
ITPROceed 2014 is now a thing of the past, but is has been an awesome – and free! – event. A very...
2014-06-17
434 reads
Kerberos Configuration Manager’s Nasty Bug
The Kerberos Configuration Manager is a really handy tool that can make configuring Kerberos a much easier task, but it’s...
2014-06-17
3,103 reads
Natively Compiled Procedures and Bad Execution Plans
I’ve been exploring how natively compiled procedures are portrayed within execution plans. There have been two previous posts on the...
2014-06-17
1,352 reads
Script, store and transfer data using XML, XQuery and clipboard
When surfing SQL Server forums you might notice a lot of questions like "How do I script my data and...
2014-06-17 (first published: 2014-06-15)
3,609 reads
SSC Editorial: Kitchen Duty
I try to find good stories for editorials at SQLServerCentral and the one this week about Kitchen Duty seems to...
2014-06-17
586 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