Log data is becoming an increasingly important indicator of companies’ application, IT and overall business health. It is the go-to data when things go wrong. More than ever before, companies are ...

Based on my SQL Server consulting practice, here are the top 10 ways an IT pro who works with SQL Server can take control of his environment. 10. Take Inventory It's critical to have an up-to-date ...

OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...

SQL is a convenient way to manage and query your data, but badly written queries can tie up your database. Here are seven common SQL traps and how to avoid them. Database developers have it tough.

This week we will discuss how to troubleshoot different assembly errors that we get while troubleshooting installs for SQL Server. I’ll focus this article more on SQL Server and Windows systems.

Maintaining a SQL Server environment is a potentially complex endeavor. Here are 10 tips for ways you can minimize complexity and reduce stress. Based on my SQL Server consulting practice, here are ...