Solve Sudoku with T-SQL - Part 1
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.
How to Move a TDE Encryption Key to Another SQL Server Instance
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
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
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
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.
Autogenerating SSIS file import packages using Biml
Tired of building tons of similar SSIS packages for importing files into your data warehouse? Learn how to autogenerate them using Biml.
Template Configuration
Extended Events is a much more complex system and profiler, and the use of templates can reduce the complexity
Azure DWH part 26: Creating your ASDW in Cloud Shell using PowerShell
In this article, we will show how to create an ASDW in PowerShell using the Cloud Shell.
Muddle Through
Perseverance and continued effort, even when you lack knowledge or skill is extremely valuable for a technology professional.
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers