Always Encrypted is a highly-touted new feature of SQL Server 2016 that promises to make encryption simple to use and transparent to applications while still protecting the data both at rest and [...]
As DBAs, we are asked all sorts of impossible questions. SQL Server can help you find information about common problems with its default trace and system_health Extended Events session, but you [...]
We’ve all seen the recent news stories about companies whose data has been stolen by hackers. What was once a rare event has become all too common, and companies large and small are at risk. [...]
Source control is a way of life for developers – it’s a way of sharing code, of protecting our work, and of saving our bacon when things go wrong. So why aren’t you using it with your database?
How many lines of code does it take to generate a running total? How would you find a value in the next row of data – without using a cursor or loop? How can you efficiently store rows of data [...]
Normalizing a database – splitting apart tables into simpler, more focused tables – can yield concrete benefits, including manageability, scalability, and space savings. The concept is a central [...]