The Database Admin's Security Burden Security is everyone's job, but in a time when data is king, SQL Server admins play a more critical role than ever in their organizations' security postures.

I'm new at this whole DBA thing, so maybe this is totally standard practice.But we have a software vendor that wants remote access to our SQL server at an admin level to setup and install software ...

Maintaining and updating the businesses database is crucial to running a successful company. To prevent and diagnose availability, health, and performance issues it is essential to review and manage ...

Here is a list of common wait types and techniques that every DBA (or wannabe DBA) should know. While there are many more wait types than listed here, understanding these will give you a leg up when ...

Wouldn't it be nice to have a database admin, which can be plugged to any web application? Just give your SQL connection string and it dynamically manages all table operations in just five pages.

During the last few articles, we have covered the basics of working with SQL server using the Server Management Objects (SMO) and PowerShell. We have covered things such as viewing the state of ...