Introducing What_To_Compress V2
Hello Dear Reader! I'm about 32,000 feet in the air leaving St. Louis after a great Performance Tuning Workshop for...
2014-05-29 (first published: 2014-05-22)
2,396 reads
Blog Posts
Notes From The May 2014 MagicPASS Meeting
Quick notes:
About a dozen people attended, attributed to the combination of having the meeting on a different than usual night...
2014-05-29
1,168 reads
Quick Tips–SSMS Select a vertical block
I saw this years ago in a presentation from Aaron Bertrand. At the time I thought it was super cool...
2014-05-29
1,656 reads
The database principal owns a schema in the database, and cannot be dropped
Problem
You are trying to drop a database user, but are getting the following error message:
The database principal owns a schema...
2014-05-29
2,534 reads
The End of the Mentoring Experiment
Back in April 2011 Steve Jones and I launched The Mentoring Experiment. We had some ideas and some goals, but...
2014-05-29
1,282 reads
We’re Giving Away SQLSaturday Orlando Vans!
We’re in full marketing mode here in Orlando, looking for ways to grow attendance for our next SQLSaturday coming up...
2014-05-29
1,424 reads
Auditing and Event SubClasses
A recent discussion got me to thinking about Auditing. To be honest, it got started with a complaint about some documentation that seemed overly light about the various fields...
2014-05-28
5 reads
Avoiding a split brain in database mirroring
You’re utilizing the database mirroring high-availability feature, configured to be in the High Safety mode with automatic failover, which means...
2014-05-28 (first published: 2014-05-22)
6,155 reads
Building The SQLSaturday Orlando Marketing Plan-Part 14
Quick notes today:
Event team likes first flyer (retro) better than the second one (doesn’t have enough why, doesn’t use space...
2014-05-28
438 reads
Complexity. How it is calculated.
What are the magic pink numbers you can see in Code Outline window?The answer is very simple - these are Code Complexity...
2014-05-28 (first published: 2014-05-23)
689 reads
Blogs
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...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
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