Who are connecting to database and disconnect ...
When you want gain exclusive access to database in order to restore database
2015-11-06 (first published: 2015-10-14)
1,925 reads
Uncategorized
Move database files to another Drive
This script either generates or execute statements to SQL data and log files from C:\ to D:\
2015-07-01 (first published: 2015-06-03)
1,961 reads
Get Your Service Broker Messages in Order. Always.
Learn how you can guarantee the ordering of all messages in a Service Broker queue, regardless of conversations.
2015-04-01
3,068 reads
dbWarden - Purge old data
helps you manage dbWarden history.
No warranty given it will do what you expect, so test it !
2014-12-11 (first published: 2014-11-19)
998 reads
Regaining access to SQL server after changing the domain
If you changed your domain and have lost control over the SQL server or have been blocked from logging in , this article talks about it
2014-10-23
15,100 reads
PowerShell script to check last backup date for Databases
PowerShell script to check last full backup, transaction log backup date for SQL Server databases.
2014-09-02 (first published: 2014-08-22)
1,785 reads
Calculate gregorian easter sunday using a table valued function
Calculate gregorian easter sunday using a table valued function.
2014-09-03 (first published: 2014-08-22)
674 reads
Adding Custom Reports to SQL Server Management Studio
In this tip, Koen Verbeeck explores how to apply business intelligence solutions to administrative tasks, specifically creating custom reports and adding them to SQL Server Management Studio.
2014-08-12
10,920 reads
2014-06-26
2,070 reads
SQL Battleship
It's you versus the computer in the classic game of Battleship, completely playable from the SQL Server Management Studio interface!
2019-04-15 (first published: 2014-04-25)
8,195 reads
Blogs
Episode 11 of Simple Talks: Oracle
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
Forums
Blob Storage automated downloads
Dipping my toes into the waters of Azure and of course before I get...
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers