SQL Saturday Birmingham 2014
I'm looking forward to geauxing with a handful of Sparkhound colleagues and friends to speak at SQL Saturday Birmingham on...
2014-08-19
543 reads
Blog Posts
And Just Like That….Three Years
Time is a constant. Anything and everything requires time it seems, and with that said I received a reminder today...
2014-08-18
292 reads
Building a Virtual Machine within Azure (IaSS) – Improvements !
Those Dev’s/UX designers out there at Microsoft seems to be pretty busy as they releasing back to back updates to windows...
2014-08-18 (first published: 2014-08-12)
7,408 reads
How To Split Non-Empty Partitions When A Clustered Columnstore Index Exists on The Table
Another pithily titled blog post, but this one revisits the feature of SQL Server 2014 that piqued my interest the most: Clustered Columnstore Indexes. I’ve been working with Clustered...
2014-08-18
335 reads
Last Weeks Top “Reading” Links #97
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-08-18
504 reads
Performance Counters: Why It Depends
When you’re working through some vague performance issues (e.g., “SQL Server seems slow today”), one of the common things to...
2014-08-18
1,248 reads
SQLSaturday Orlando Marketing Plan-Part 36
Just checked in on my LinkedIn campaign. This is the one that uses job titles. Not a ton of impressions,...
2014-08-18
502 reads
SQLSaturday Precon Cost Structure
Many of you may already know that I am a PASS regional mentor for the South Central region of the...
2014-08-18
484 reads
SQLTea - New SQL tutorial app in Google play store
SQLTea - Our new SQL Tutorial App on Google Play StoreWe are happy to announce our new SQL tutorial app SQLTea...
2014-08-18
1,376 reads
Database Creation using SQL Sever Management Studio (SSMS)
In the previous article (Database Creation using Create Database command), I explained the database creation using the Create database command....
2014-08-17
946 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