Are You an Exceptional DBA?
The Exceptional DBA award is back again in 2009. Steve Jones comments a little on his experience last year.
2009-06-12
1,034 reads
Articles
Gathering in the Corner - SQLSaturday #14
I'm done with SQLSaturday #14, actually stuck in Pensacola for an extra night, but that's another story. It was a great event, and I have to say I was very surprised at the number and variety of speakers that came to contribute to the event
2009-06-12
1,022 reads
Geo-Replication Performance Gains with Microsoft SQL Server 2008 Running on Windows Server 2008
This paper provides IT pros with an in-depth look at the tests conducted by the MSCOM Ops team, insight into the results, and technical analysis of the enhancements to Windows Server 2008 and SQL Server 2008 that enable wide area network (WAN)–based geo-replication.
2009-06-12
2,093 reads
Notes on SQLSaturday #14 in Pensacola
I'm just back from the event and it turned out very well, just over 170 attendees attending their choice of 30 sessions. Pensacola is a lot smaller than some cities so the 170 is an amazing turnout, and unusually there was only about a 10% no show...
2009-06-12
909 reads
SQL Saturday 14 - Pensacola
I’ve just arrived home from a quick trip to Pensacola to speak at SQL Saturday 14 in Pensacola, FL. I’m quite happy with the event; the planning and organization was handled very well, and I believe the event was a big success in the eyes of the...
2009-06-12
1,124 reads
SQL Saturday Pensacola pics
The SQL Saturday Pensacola pics are up! Visit the SQL Saturday Facebook group at
2009-06-12
1,244 reads
Using authenticators with SQL Server encryption
Authenticators are additional data that gets encrypted along with the data to be stored in an encrypted manner. When it comes to decrypt the data, if the right authenticator isn't specified, SQL Server doesn't return the data in the decrypted form. Rather, a NULL value is returned, just as if the wrong key was used.
2009-06-12
2,384 reads
Back to the Future
Steve Jones asks this Friday if there is anything you wish you might have done differently.
2009-06-11
817 reads
Back to the Future
Steve Jones asks this Friday if there is anything you wish you might have done differently.
2009-06-11
832 reads
Back to the Future
Steve Jones asks this Friday if there is anything you wish you might have done differently.
2009-06-11
732 reads
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
cons for a dev machine in a different version of sql from our prod server
hi, im not a dba. For a couple of years our dev sql server...
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers