How to Tell Your Windows Azure SQL Database Moved
The very concept of the Windows Azure SQL Database (WASD) is predicated on the up-time created by having three active copies...
2013-05-13 (first published: 2013-05-07)
1,587 reads
The Scary DBA
Windows Azure SQL Database Backups
You can get backups of your WASD databases. But, if you want them to be transactionally consistent, you need to...
2013-04-04
926 reads
Execution Plans in Azure SQL Database
Microsoft has stated pretty clearly that they’re putting code on Azure first, ahead of the desktop. Which makes one wonder...
2013-03-27 (first published: 2013-03-25)
3,641 reads
Laws You Break at Your Peril
Laws of Thermodynamics
TANSTAAFL
Gods of the Copybook Headings
All magic comes with a price
Winter Is Coming
My adult years started with a pretty...
2013-03-20
864 reads
Star Trek and the Death of IT
GAAAAAAAHHHHH!!!!
I feel slightly better, but only slightly.
I started watching Star Trek: The Next Generation on Netflix just to unwind my...
2013-03-18
1,144 reads
Time to Chat
The greatest part of my job is that I get to travel all over the world to present different technical...
2013-03-11
1,173 reads
Pro SQL Server 2012 Practices: Chapter 17
I jumped at the opportunity to write a chapter for this book, Pro SQL Server 2012 Practices, because of all...
2013-03-04
1,702 reads
It Is Your Fault
I earned my nickname. I’m proud of it. I am the Scary DBA. I don’t really like to advertise my...
2013-02-27
1,532 reads
SQL Saturday #187 Richmond And More
In just a couple of weeks I’ll be flying down to Richmond, VA to speak at SQL Saturday #187. I’ll...
2013-02-25
889 reads
SQL Server Naming Standards
Want to start a fight between a bunch of DBAs or database developers? Ask them where the comma should be...
2013-02-18 (first published: 2013-02-13)
3,560 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers