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.
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
BCA KCP Senen. Tlpn:085373Pusat Grosir Senen Jaya Blok A8-9, Lantai 2, RW.3, Senen, Kec....
BCA KCU DAAN MOGOT Telpon/WA:08218168291.Jl. Daan Mogot No.95, Wijaya Kusuma, Kec. Grogol petamburan, Kota...
BCA KCU THAMRIN. Tlp:085373737845.Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec. Menteng,...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers