What's "Actually" going on with that Seek?

Rob Farley digs deeper into seeks and actual rows read, demonstrating a case where you want a non-sargable expression in the WHERE clause.

Analyzing Data in Real Time

What is real time data analysis? Steve Jones has a few thoughts.

Where's the Unit Testing?

Today Steve Jones wonders why we don't unit test more, especially for databases.

The IT Manager's perspective: People as an Asset

Information Technology is fast-changing, but the people who work in IT need to have a good chance of a long-term career. That means keeping up to date, not only in their current speciality, but in the wider sphere of the technology they work with. IT managers must make sure that keeping up to date with technology is part of the day to day activity of their people. How should they make sure it happens?

How do you know when it is time to leave a job?

Today we have a guest editorial from Ben Kubicek as Steve is traveling out of town. I discovered I had stayed at a job about two years too long. Why was that?

PowerShell Desired State Configuration: Automating and Monitoring Pull mode

The Pull mode of Desired State Configuration (DSC) is more complicated to implement because you need to meticulously manage the MOF files and their naming conventions so as to ensure that you deploy your DSC configurations correctly. In this first article of a two-part series, Nicolas Prigent describes how you can best automate this, and then in a second part on monitoring DSC he describes techniques to help you to use the pull mode as a regular part of your admin work.

Byte Me: Supervirus

Target Recovery Interval and Indirect Checkpoint

Indirect checkpoint is the recommended configuration, especially on systems with large memory footprints and default for databases created in SQL Server 2016.

SQL Server differences of char, nchar, varchar and nvarchar data types

Sherlee Dizon looks at the basic differences between char, nchar, varchar, and nvarchar, as well as what to be aware of when using each data type.

Using SQL Compare with Dynamic Data Masking

Dynamic Data Masking is an exciting new feature in SQL Server 2016, allowing DBAs to centrally set a mask that is returned for a table column instead of the actual data, limiting what information is returned to certain users in a consistent and reliable way. What’s more, Redgate SQL Compare safely and reliably handles your DDM changes. Data Platform MVP Steve Jones explains more.