Missing Stats DMV?
Useful statistics are critical for great performance in SQL Server. So much so, that by default, SQL Server creates statistics for columns it deems worthy without any help or interjection from anyone.1 However, SQL Server…
Storing Backups Locally? You have no Backups!
Me, being nice! You’ve got business critical data stored in your SQL Server, don’t you? And you’re taking backups of those databases, right? But where are you storing those backups? If you’re storing backups locally,…
Heaps are Lurking in your Database…
And you know that’s a bad thing™. At least, most of the time. Some people swear by ’em, and for certain requirements a heap is the best thing since sliced bread. For most scenarios you…
Efficiently Update Data from OLTP to OLAP
OLTP to OLAP: Acronym Time! Online Transaction Processing, or OLTP, serves data to clients for line-of-business applications, enabling core business functionality. Online Analytical Processing, or OLAP, consists of analyzing OLTP data with the intent of…
Enable Kerberos Authentication without rebooting SQL Server
What is this Kerberos thing, anyway?! Kerberos Authentication1 allows SQL Server to impersonate Active Directory users to other services via double-hop-authentication. This is commonly used to provide access to data through a web-site via Windows…
Agent Properties
SQL Server Agent has many operational properties that can be critical for troubleshooting various issues. Many of these properties are surfaced via GUI properties pages, and as such can be hard to compare across many…
