Tag Archives: sql server

Examining SQL Server 2016

SQL Sever 2016 is getting close to release. The updates are coming fast and furious, causing issues in some cases as many people look to test the new features in different environments. Personally, I’m struggling a bit to determine which … Continue reading

Posted in Editorial | Tagged , , | Comments Off on Examining SQL Server 2016

Protecting the SA Account

The sa account is a well, known, built in account for SQL Server. Years ago, in previous versions, I’d see people often use the “sa” account for development, usually with a blank password. Even those speakers and experts often showed … Continue reading

Posted in Blog | Tagged , , | Comments Off on Protecting the SA Account

Protecting sa

Built in accounts are both a help and and a hindrance. Years ago I was working on a SQL Server 4.2 system, where I was an administrator. The database was very unstable, and we were trying to determine if it … Continue reading

Posted in Editorial | Tagged , | Comments Off on Protecting sa

Default Data Masking

Dynamic Data Masking is a neat new feature in SQL Server 2016. I didn’t think much of it when it was introduced in Azure SQL Database, but since then I realize there is some value here. Even if it’s just … Continue reading

Posted in Blog | Tagged , , | Comments Off on Default Data Masking