The Case for Optimize for Ad Hoc Workloads
I recently was involved in a discussion about whether or not to enable the ‘Optimize for Ad Hoc Workloads’ server...
2015-05-19
817 reads
Blog Posts
Volunteer Strategy for SQLSaturday Orlando
I’ve been busy with other stuff lately and haven’t been able to put much time into this yet, but capturing...
2015-05-19
361 reads
Database In Recovery Update
Many moons ago, I published a post that contained a script to aid in easing the anxiety that comes when a database is “In Recovery”. When I pulled that...
2015-05-18
5 reads
Database In Recovery Update
Many moons ago, I published a post that contained a script to aid in easing the anxiety that comes when...
2015-05-18
483 reads
Debug Managed Code and Stored Procedures Seamlessly
Visual Studio is a great tool for developers, and it offers so many great features, such as IntelliSense, unit testing...
2015-05-18 (first published: 2015-05-06)
6,223 reads
Fresh New Horror: PK on a Float Data Type
Here's a new thing to be scared about in the night, as if you weren't already terrified of floats after...
2015-05-18 (first published: 2015-05-11)
670 reads
How to Move MSDB & Model SQL Server system Databases ?
Steps of Moving MSDB & Model SQL Server system Database to new locaation:-
1) Check current location of MSDB & Model Databases by...
2015-05-18
3,271 reads
I’m Speaking at OPASS on May 28, 2015
I’ll be presenting Avoiding, Detecting, and Repairing Database Corruption and probably talking a little bit about career development during the...
2015-05-18
322 reads
Monday Morning SQL Break – May 18, 2015
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2015-05-18
517 reads
Precon this week! The Enterprise Scripting Workshop #SQLSaturdayBR
You are cordially invited to a fantastic precon event before SQL Saturday Baton Rouge! The Enterprise Scripting Workshop is on Friday,...
2015-05-18
559 reads
Blogs
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
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...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers