Self-Service vs. Managed BI
Is self service BI a good idea? Some people think so, others don't. Steve Jones talks about one of the issues and why it might actually not be a problem.
Configuring Alerts for Policy-Based Management
How can I receive notifications when the policies I have implemented have been violated so I don't have to manually look at each server?
Becoming Highly Productive
Today we have a guest editorial from Andy Warren. You can get more productive, but are you being productive at the tasks that you should be working on? See what Andy Warren has to say.
SQL CLR Data Types and Performance
Using SqlTypes can have a significant impact on the performance of your SQL CLR implementations. Is it for the better? Read this article to find out.
Gathering Perfmon Data with Powershell
Inspired to streamline the process of gathering and storing data from Performance Monitor Counters, SQL Server MVP Laerte Junior guides us through the functions of his remarkably useful module.
Incompetent or Malicious
When someone else doesn't do a good job to prove a point, are they incompetent or malicious? Steve Jones comments.
Turn on CHECKSUM after an upgrade
When reloading or attaching a SQL 2000 database to SQL 2005 or 2008, the database objects are upgraded automatically. Some database options don't change, though. PAGE_VERIFY is one of them.
Binary Trees in SQL
A number of hierarchies and networks are most conveniently modelled as binary trees. So what is the best way of representing them in SQL? Joe Celko discards the Nested Set solution in favour of surprisingly efficient solution based on the Binary Heap
Backup Isn't Enough
When is backup not enough? Steve Jones talks about a few things that can cause you issues and a backup can't help you recover from.
Setting All Tempdb Data Files to the Same Size
How to set all tempdb datafiles to same size to meet best practice.
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Foreach Loop still executes after process and delete all the folders
I have two challenges XML source control not displaying the XML file parent node...
Which 'Where' statement conditional upon a variable
Thanks in advance for any clues on this. I am trying to write a...
Backup to Immutable Storage
Comments posted to this topic are about the item Backup to Immutable Storage
Question of the Day
Backup to Immutable Storage
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers