A Script A Day - Day 6 - Drop and Create Database Snapshots
Today's Script will drop all database snapshots and create a database snapshot for all online read writeable user databases. I...
2012-02-06
3,897 reads
Blog Posts
Baton Rouge SQL Server User Group
I will be speaking at the February Baton Rouge SQL Server User Group meeting on Wednesday the 8th. The session...
2012-02-06
679 reads
Building or Buying a Desktop Based Development and Test Database Server
Back in April of 2011, I wrote a post that compared the merits of using an ancient, but actual rack...
2012-02-06
1,421 reads
Introduction to XML DML (Part 3) - Using the modify() method: delete
This is the last part of a 3 part blog which will attempt to show some different ways of how...
2012-02-06 (first published: 2012-02-02)
10,307 reads
Kindle Fire Update
We’ve had two of them since right after the launch and overall I’m pleased. They get used quite a bit...
2012-02-06
578 reads
Meme Monday - Working with Deadlines.....
Hi, all! It's been a while, since I posted a blog entry, and is directly related to today's Meme Monday...
2012-02-06
1,908 reads
Meme Monday: Deadlines
Tom LaRock (blog|twitter) has assigned an interesting topic for Meme Monday this month, working with deadlines.
Some people hate deadlines. Some...
2012-02-06
1,217 reads
SQL Rally 2012 Vote For Me!
Hello Dear Reader! Last year I tossed my hat in the ring on the world of Presenting. This was a...
2012-02-06
769 reads
Why Every DBA is a Clown
It’s late, really late and you’ve got a mountain of work to get through to meet the deadline. To add...
2012-02-06
993 reads
A Script A Day - Day 5 - Database Owner Permissions
Today's script will list all principals with membership in the db_owner fixed database role.
/* ----------------------------------------------------------------- Database Owner Permissions ----------------------------------------------------------------- For more SQL resources, check...
2012-02-05
1,134 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers