LinkedIn for Blackberry
I’ve been waiting on this for a while, and missed the announcement that it was available, happened to see that...
2010-04-15
543 reads
Blog Posts
PowerShell 2.0 on Windows XP SP3 - Can It Be Upgraded?
In my last blog post I indicated that I would be adding learning PowerShell to my list of goals. I...
2010-04-15
5,034 reads
Schedule Published for SQLSaturday #38 in Jacksonville
SQLSaturday #38 is coming up on May 8th, 2010, back at the same location as in previous years at the...
2010-04-15
490 reads
SQL Saturday #38 Jacksonville Update
With less than a month away, May 8, before the big event in Jacksonville I wanted to give you a little inside...
2010-04-15
575 reads
SQL Server 2008 R2 – Release Date
This is a very short post
I’m probably very late to this party but…SQL Server 2008 R2 is scheduled for release...
2010-04-15
513 reads
SQL Server 2008 R2 Release Date: May 21 2010
R2 is ready to roll!
As expected, Brent “Master” Ozar (Blog | Twitter) already scooped the story, but it never hurts to...
2010-04-15
472 reads
Third Party Backup Tools – Redgate SQL Backup
To continue my little blog series on SQL Server backups, any series would not be complete without a look at...
2010-04-15
2,903 reads
A DMV a Day – Day 14
The DMV for Day 14 is sys.dm_os_wait_stats, which is described by BOL as:
Returns information about all the waits encountered by...
2010-04-14
783 reads
A Quick Queue Process
As SQLServerCentral grew, we evolved through a few email sending solutions to meet the demand. We started with a manual...
2010-04-14
783 reads
How Do I Kill All Sessions from a Windows Group?
Introduction
The stored procedure I am posting today will kill all sessions for users that are members of a given domain...
2010-04-14
511 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