Check out these scripts to create SQL Server jobs and Alerts when a login is created or dropped, a database user is added or dropped and when logins are added or removed from server roles or users are added or removed from database roles.
The next meeting of the Luxemborg SQL Server User Group has some great sessions planned.
Back in my early days as a database administrator, almost 16 years ago, I happened upon a web site called SQL Server Central. Because I found so many useful articles and forum posts, the site was open in my browser at work every single day. It was a great source of information, and eventually, I […]
Greg Larsen shows you a quick trick to programmatically script a way to identify when SQL Server was last started.
We could use more intelligence in our backup systems, since we don't need to keep all those files.
Make sure your SQL Server database release scripts to make life easier.
By looking at a query execution plan, you can determine which steps are used to resolve the query. But what if you just want to find out what the query plans are for only the queries that are currently running?
Backups. Are you confident you can restore? Do you have a process that ensures you can recover your systems? Learn how one system works in the cloud.
Along with Graph Databases, Microsoft has introduced the new MATCH function for querying them. Robert Sheldon explains how to use the new function.
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
Hi experts, I have a 3+ TB database on a 2019 sql server which...
Comments posted to this topic are about the item The North Star for the...
Comments posted to this topic are about the item Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers