SQL Server Reporting Services has been the go to reporting solution for SQL Server for almost a decade now. In many organizations, the ease of development, web front end and security make SSRS the tool of choice.
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.
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.
The origins of PASS have shaped its culture for years. Are you doing the same in your organization?
A fun exercise, using CTEs to implement John Conway's Game of Life cellular automata simulation
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.
Tired of building tons of similar SSIS packages for importing files into your data warehouse? Learn how to autogenerate them using Biml.
Extended Events is a much more complex system and profiler, and the use of templates can reduce the complexity
In this article, we will show how to create an ASDW in PowerShell using the Cloud Shell.
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Comments posted to this topic are about the item Spring Connections and Learning at...
Comments posted to this topic are about the item Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers