Partitioning Basics – Part 1 – Creating Partitions
Partitioned tables can be a quick and efficient way to (amongst other things) archive data. In the next couple of...
2014-06-09 (first published: 2014-06-04)
5,071 reads
Blog Posts
Prepping For The NomCom
Sunday I spent an hour going over various notes and thinking about what I’ve seen in the past couple PASS...
2014-06-09
353 reads
SQL Saturday 294 Philadelphia Lessons Learned
Being in Philadelphia this past weekend was fantastic! I got to meet a lot of old friends, spend time with...
2014-06-09
610 reads
SQL Server 2014 – How to Add node to failover cluster ?
Steps for SQL Server 2014 Cluster Installation – Add Node to Failover Cluster:-
1) Lunch SQL Server Installation Center
2) Enter Product Key
3)...
2014-06-09
2,424 reads
Unplanned Availability Group Failover
Whenever a disaster occurs it will be a stressful scenario regardless of how small or big the disaster is. This gets multiplied...
2014-06-09
755 reads
Bug in SQL Server 2014 SQLPS For Registered Servers/Groups
I recently had an opportunity to write an article for mssqltips.com on managing registered servers under “local server groups”, and...
2014-06-07
3,184 reads
Building The SQLSaturday Orlando Marketing Plan-Part 17
Didn’t get as much done this week as I’d hoped, but a little luck balanced that out! I do at...
2014-06-07
362 reads
5300 PASS Voters for 2014 Election
I was catching up on reading the minutes of PASS Board meetings and found the following except in paragraph 2...
2014-06-06
369 reads
D-Day, Family, Vets, and Life
Today is the 70th anniversary of D-Day, a day worth remembering and celebrating to be sure. I like that we...
2014-06-06
382 reads
Examining PAGEIOLATCH waits
In a previous article we looked at CXPACKET waits, a wait type that is can be on the top of...
2014-06-06
11,430 reads
Blogs
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
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...
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