Everything Old Is New Again: 5 IT Headaches That Never Go Away
Here is a list of the continuing problems that exist in every IT shop around the world. And they aren’t all new, either.
server
The Server Draft
If you were given the chance to build the ultimate server, what would you draft first?
HOW TO: Find When SQL Server Wait Stats Were Last Cleared
For years I have found myself often needing these three pieces of information with regards to SQL Server: When was the last time the server was restarted? When was the last time the SQL instance was restarted? When was the last time the SQL Server wait stats were cleared? If the server itself is restarted, then the answer … Read more
Changing Default Database File Locations in SQL Server 2014
When you create a database in SQL Server and do not specify a file location for your data and log files SQL Server will rely on the default database file locations as defined in the server properties.
Top 3 Performance Killers For Linked Server Queries
One thing I have noticed in all my years as a data professional: few users understand (or care) how far away they are from their data. Quite often they expect instant results from their queries. They don’t understand the upper bounds of resources like network bandwidth, the speed of light, and that the data is … Read more
SQL Server Query Performance Tuning: A 12 Step Program
Performance tuning is hard. Everyone knows that. Has anyone ever tried to figure out why? Sure, there’s that big old “it depends” that gets tossed about. Look, at the end of the day you only have so many possible resource bottlenecks: disk, memory, CPU, and network. I don’t care if you are running Linux, Unix, … Read more
