We Are Microsoft (GiveCamp Dallas)
Last weekend (January 15-17) found me at the third annual GiveCamp Dallas event, known locally as We Are Microsoft. This...
2010-01-23
741 reads
Indexes Out the Window
I ran into a peculiarly puzzling situation with a query I have been tuning of late. The query runs some...
2010-01-23
1,090 reads
DBA Checklist Updated
I have recently updated and revised my DBA Best Practices Checklist, which is hosted on www.Simple-Talk.com. The goal of the...
2010-01-22
814 reads
SSIS Checkpoints with Tasks Running in Parallel
Several months ago I blogged about why Checkpoints are a great feature in SSIS to use. It seems with every...
2010-01-22
3,484 reads
Microsoft – Follow best practices!
Best practice is to use parametrized queries to enable plan reuse. Will someone please tell Microsoft this.
Presently dm_exec_cached_plans on...
2010-01-22
1,023 reads
Final Reminder – SQLSaturday #32 in Tampa on Jan 23, 1010
I’ve had to cancel my plans to attend, which also included plans for a late lunch at the Green Iguana...
2010-01-22
539 reads
Book Review: K2: Life and Death on the World’s Most Dangerous Mountain
I read Life and Death on the World’s Most Dangerous Mountain by Ed Viesturs ($18 @ Amazon) over the holiday break....
2010-01-22
739 reads
SQL Server 2008 R2 to be Available in May
This past Tuesday, Microsoft officially announced that SQL Server 2008 R2 will be available in May 2010. See the announcement...
2010-01-21
674 reads
Getting here from there
Another month, another blog chain, this time started by Paul Randal. I got tagged by both Grant and Steve, on...
2010-01-21
402 reads
Speaking at European PASS
I just heard that two of my presentations have been accepted for the European PASS Conference 2010 in Neuss, Germany,...
2010-01-21
690 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