No More SQL Server Installs
Today, Steve wonders when we’ll stop installing SQL Server on a host machine.
Editorials
What’s Worse than Announcing a Data Breach?
Steve has a few thoughts on what is worse than telling your boss about a data breach.
Query Tuning Assistant: A Tool for Upgrades
If you have been working with SQL Server long enough, you have probably been involved with a SQL Server 2000 to 2005 upgrade. It was painful for many shops due to the deprecation of some features like DTS and the removal of old-fashioned comma joins with the plus operator. It was worth the pain as […]
Bad Management
Bad managers are everywhere, but we can improve and help them with some ideas from other companies. That’s if we, as an organization, value our staff.
How Virtualized?
This week’s poll asks about virtualization in your environment. Let us know if you are moving your SQL Server to virtual machines.
Serious Hacking
The biggest government hack ever occurred recently. At least until the next one happens.
Dealing with Failure
A minor disaster in Colorado reminds Steve about the need to prepare, and think about the failure points in our preparations.
The V1 Team’s Doomed Redesign
A new version of an existing application doesn’t always provide an upgrade.
Blogs
Drop Database Objects Practically Risk-Free!
FIRST OF A TWO PART SERIES Some months ago, a fellow DBA came to...
Lengthen a Primary Key–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Setup SQL Server Alert to get automatically notified of database blockings
By SQLPals
Suppose you want to or need to know anytime your SQL Server is experiencing...
Forums
Protecting Data Between Services
Comments posted to this topic are about the item Protecting Data Between Services
SQL browser and port number
We have several new servers running SQL 2014. Some servers are single instance servers...
ssms crashes when editing .sql script
I’ve recently been having an issue with ssms freezing and crashing while editing a...
Ask SSC