The Great Migration
We migrated to a new set of servers tonight. Actually am for the Red Gate folks and a late, 11pm-2am...
2007-03-17
1,461 reads
Blog Posts
Windows Mobile Security
I'm working on a new article for SQL Server Central talking about physical security and SQL Server and I was...
2007-03-17
1,359 reads
SQL Server 2005 SP2 and Maintenance Plans - Still not fixed yet
SQL Server MVP Aaron Bertrand has posted that there is still a bug with maintenance plans for SQL Server 2005...
2007-03-15
1,449 reads
New Version of ApexSQL Doc (2005.11.0203)
ApexSQL announced that a new version of ApexSQL doc is available.
News Announcement
The latest version is 2005.11.0203 and there are...
2007-03-14
1,520 reads
Windows 2003 SP2 is Out
Here is a list of what was fixed:
http://support.microsoft.com/default.aspx/kb/914962
Downloads are available off of the SP2 home page:
http://www.microsoft.com/technet/windowsserver/sp2.mspx
Technorati Tags:Microsoft | Windows 2003
2007-03-14
1,465 reads
Conditional formatting in Reporting Services
Yesterday's post reminded me of another interesting technique I have used to change the color of the values on a...
2007-03-11
1,326 reads
Using IIF in Reporting Services
I found an interesting use for the IIF function in a Reporting Services report this week. I needed to provide...
2007-03-10
1,715 reads
SQL Server Learning Opportunities!
There are two big SQL Server learning opportunities I want to remind you about. First, DevTeach/SQLTeach will be held in...
2007-03-09
1,799 reads
Midlands PASS Job Board
In order to assist those members of the Midlands PASS Chapter looking for new positions, I have put up a...
2007-02-26
1,347 reads
Hacked
Boy that was fun. Getting a bunch of emails that we had been hacked and tracking down someone updating all...
2007-02-22
1,515 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Daily aggregation of Azure Blob Storage by tier (created/tier-change/deleted)
Hello all, I’m looking for advice on how to derive a daily snapshot table...
SQL 2017 to SQL 2025. Good to Go ?
We need to replace our Windows server running SQL 2017. Any reason not to...
Question of the Day
Using OPENJSON
I have some data in a table that looks like this:
BeerID BeerName brewer beerdescription 1 Becks Interbrew Beck's is a German-style pilsner beer 2 Fat Tire New Belgium Toasty malt, gentle sweetness, flash of fresh hop bitterness. 3 Mac n Jacks Mac & Jack's Brewery This beer erupts with a floral, hoppy taste 4 Alaskan Amber Alaskan Brewing Alaskan Brewing Amber Ale is an "alt" style beer 8 Kirin Kirin Brewing Kirin Ichiban is a Lager-type beerIf I run this, what is returned?
select t1.[key]
from openjson((select t.* FROM Beer AS t for json path)) t1 See possible answers