SQLSaturday 31 Chicago: Recap
Last weekend I had the distinguished pleasure of attending Chicago’s very first SQLSaturday event. Before I begin my recap I’d...
2010-04-22
658 reads
Blog Posts
The Knowledge... (quote)
The quote about Knowledge, sure it is Albanian quote:
Learn the Knowledge but you'll never get rewarded by the God(All-llah) until...
2010-04-22
1,366 reads
What is a Good Way to Quickly Disable SQL Agent Job Schedules?
Introduction
I recently blogged about a Stored Procedure to Sequentially Run SQL Agent Jobs and have been meaning to blog about...
2010-04-22
456 reads
2010 Scripting Games
Since I've decided it's time for me to learn Powershell, naturally the best way to learn it is to dive...
2010-04-21
763 reads
A DMV a Day – Day 21
The DMV for Day 21 is sys.dm_os_ring_buffers, which is helpfully NOT described by BOL as:
The following SQL Server Operating System–related...
2010-04-21
2,584 reads
Attending Microsoft Most Valuable Professional Open Day from Montreal
Currently, MVPs from across the country are attending an all day event.
We are discussing Azure, Windows Live, Office 2010, Windows...
2010-04-21
673 reads
Big SQL Server Announcement This Morning at 7:30AM PDT
Microsoft’s Ted Kummert and Tom Casey are holding a public conference call this morning at 7:30AM Pacific time, where:
Microsoft...
2010-04-21
730 reads
Free E-Book on SQL Server 2008 R2
Free E-Book on SQL Server 2008 R2
Ross Mistry and Stacia Misner have done a wonderful job on this free e-book
http://blogs.msdn.com/microsoft_press/archive/2010/04/14/free-ebook-introducing-microsoft-sql-server-2008-r2.aspx
You...
2010-04-21
3,688 reads
Log Shipping Delays are Good
In the past, when I’ve set up log shipping, it was primarily as a DR device, designed to get copies...
2010-04-21
3,197 reads
Microsoft Teleconference – Ted Kummert (Senior VP) and Tom Casey (General Manager of BI)
Microsoft held a big teleconference today, which I unfortunately got called away from a minutes into it. The call was...
2010-04-21
594 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers