SQL Server Profiler has always been a great tool for tracing activity “under the hood” on a SQL Server and assessing its performance. One feature that helps us quickly set up a trace on our current ...

In an earlier blog I talked about the difference in mentality between the typical developer and the typical DBA. One of the characteristics of the DBA is the distrust of the Microsoft Wizards. “Give ...

I have users complaining about slow performance in one of our internal applications. The application is, essentially, a front end to a SQL database. We've built a new server for it because the old one ...

SQL Injection is a fairly new method of hacking your database. Learn how it’s done—and how to protect yourself. MOST NETWORK ADMINISTRATORS charged with keeping the network infrastructure secure tend ...