Version Restores
I saw a question today on restoring a SQL Server 7 backup to SQL Server 2005, and I wasn't sure...
2008-12-19
663 reads
Blog Posts
A Week of Books - Part 5
Last and not least this week, The Snowball: Warren Buffett and the Business of Life. This is an authorized biography...
2008-12-18
703 reads
Evaluate Jack Corbetts Blog
My friend Jack has been blogging for almost a year now and is looking for feedback. If you're a blogger...
2008-12-18
595 reads
SQL Quiz: Two Mistakes
I was tagged by Gail Shaw to post two big mistakes made during my professional career. The only challenge here...
2008-12-18
829 reads
The December Car Update
I missed the November Car update, but I was too busy with the PASS Summit to get one done.
However last...
2008-12-18
661 reads
A Week of Books - Part 3
I'm still finishing up two books that I'll mention today. Most non-technical books I read straight through, anything technical/learning based...
2008-12-17
539 reads
A Week of Books - Part 4
Magazines today instead of books, but hopefully you'll count that as close enough to my theme of the week. I...
2008-12-17
538 reads
Dos and Don'ts for Projecting a Professional Image on the Internet
In a previous blog post, I suggested that less than professional content, that you or others post on the Internet...
2008-12-17
1,161 reads
Is Your Internet Activity Hurting Your DBA Career?
I have been active on the Internet for 15 years, and during that time I have left a long trail...
2008-12-17
1,065 reads
Jumpstart TV SQL Server security videos on-line
Back in October I had the opportunity to work with Andy Warren and do a series of SQL Server security...
2008-12-17
1,400 reads
Blogs
When the Internet Stumbles: Lessons from Cloudflare & Azure Front Door Outages
By John
Recently, the world was reminded of just how fragile the internet can be. Two...
Prepping for Certification, Part 4 of 4
By Brian Kelley
In Parts 1-3, I covered how I prepare for a certification exam. In this...
Flyway Tips: Automation Assistance in Flyway Desktop
By Steve Jones
I was chatting with the product managers at Flyway and one asked me whether...
Forums
CAST datetimeoffset(7) as a datetime in UK format
I have a view where I am casting a datetimeoffset(7) field to smalldatetime or...
what are the downsides of TDE not running vs running?
hi for the 2 years i've been here I believe we've had "encryption" turned...
Help! MEMORY_ALLOCATION_EXT wait stalls
Hi I have an overnight process that moves allot of claims records Been working...
Question of the Day
Putting the Player with the Number
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers