Database Mail in Microsoft SQL Server is a powerful, but under-utilized ally for any Database Administrator. It's been around for years but often goes un-noticed to this day. I find myself relying upon Database Mail (let's just call it DBM th...

In this article I continue the series by describing the logical query processing aspects of the third and fourth major query clauses—GROUP BY and HAVING, respectively.

The basic understanding of SQL Server security involves knowing the differences between logins, users, schemas and roles. It also means you can tell the difference between SQL Server security and Trusted Authentication. Join Tim as he navigates...

I've never heard anyone say they want to be a Database Administrator when they grow up. We just end up here and many of us love it enough to stick with it for the bulk of our career. Coming into SQL Server administration usually doesn't come wi...

Primer on Log Shipping Log shipping: it's a process for maintaining a copy of an existing database on a different server by applying any new transaction log backup taken on the original database. The setup for log shipping is quite simple: ...