A Sudoku solution can be resolved using a single select statement. The first article shows this method and next how this can be optimised to resolve complex puzzles in seconds.

Virtual Data

by Steve Jones

SQLServerCentral.com

Editorial

The ability to abstract away production databases is becoming a hot technology.

How to Move a TDE Encryption Key to Another SQL Server Instance

by Additional Articles

SQLServerCentral

Transparent Data Encryption (TDE)

If you have a database backup of a Transparent Data Encryption (TDE) enabled database, the database backup will contain encrypted data. Because the database backup contains encrypted data you can’t just restore it to any instance. You can only restore the database backup to an instance that contains the same certificate used to originally encrypt the database.

Building Culture

by Grant Fritchey

SQLServerCentral.com

Editorial

The origins of PASS have shaped its culture for years. Are you doing the same in your organization?

Implementing John Conway's Game of Life in Microsoft SQL Server

by Paul Chang

SQLServerCentral.com

A fun exercise, using CTEs to implement John Conway's Game of Life cellular automata simulation

Questions about Data Governance that You Were Too Shy to Ask

by Additional Articles

SimpleTalk

data governance

A company’s data is one of its most valuable and important resources. Managing and protecting that data are big responsibilities, and a data governance processes must be put into place to avoid misuse and to meet regulations. In this article, William Brewer answers questions you may have about data governance but were too shy to ask.