(Ed Elliott) This is part of a series on how to take the Adventureworks database and bring it in line with modern standards. How do we put a legacy SQL Server database into source control? What issues do we face and how hard is it? Then how do we build a continuous integration pipeline and possibly

(Chris Webb) One of the most useful new additions to DAX in Excel 2016 and the Power BI Designer is the DateDiff() function. It does exactly what you would expect: calculate the amount of time in between two dates, and express that value as either seconds, minutes, hours, days, weeks, months, quarte

(Jonathan Allen) Row-level security is great for all or nothing decisions, but there are times when users need access to a subset of the data. For example, the last four digits of a credit card or social security number. This can be done at the application level, but that leaves room for error. You

(Robert Sheldon) If you need to receive and process a large volume of packets of data, such as telemetry, or event-log items, it may be worth considering Azure Event hubs. They aren’t like traditional messaging but represent more of a stripped down one-way event processing system for large volumes o

(Scott Murray) What exactly is a SQL Server Reporting Services Range Chart and how do I implement a range chart?

(Kenneth Fisher) I got my first real world experience with a TDE (transparent data encryption) database recently. For those who don’t know TDE encrypts all of the data at rest. So the database files are encrypted and the backup is encrypted.

(Paul White) A simple definition of the median is:

(Pinal Dave) I have been monitoring some of the error messages that SQL Server has been throwing in the recent versions and they are self-explanatory. If we understand the English, then half the problem is solved.

(Kenneth Fisher) I got my first real world experience with a TDE (transparent data encryption) database recently. For those who don’t know TDE encrypts all of the data at rest. So the database files are encrypted and the backup is encrypted.

(Jonathan Allen) A common criticism for SQL Server’s security model is that it only understands tables and columns. If you want to apply security rules on a row-by-row basis, you have to simulate it using stored procedures or table value functions, and then find a way to make sure there is no way to