Retrieve SQL Instance Connect Info
This script quickly returns Server Name, Cluster Node, Default Drive Letter for MSDB database, IP address and port
2013-04-11 (first published: 2013-03-24)
1,480 reads
Scripts
2013-04-05 (first published: 2009-03-27)
4,613 reads
2013-04-03 (first published: 2013-03-08)
1,720 reads
2013-04-02 (first published: 2008-09-11)
15,405 reads
2013-04-01 (first published: 2013-03-08)
1,818 reads
2013-03-29 (first published: 2013-03-08)
1,452 reads
Backup history details EMAIL (past 24 hours) in HTML format
Get backup status email daily to your inbox in HTML format.
2013-03-27 (first published: 2013-03-14)
2,410 reads
2013-03-26 (first published: 2013-03-15)
805 reads
Monitor current transactions and get all required information
Check which transactions are running, query text, percent complete , query_plan, wait_type, and how long they have been running etc. - with one command.
2013-03-25 (first published: 2013-03-15)
2,316 reads
Powershell - Document your environment
This script is an improvement from my original script entitled "Powershell - Query SQL Servers Operating system details".
2013-03-22 (first published: 2013-02-27)
2,414 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers