2010-11-18 (first published: 2009-07-20)
2,979 reads
Scripts
Get SQLServer Name and Uptime SPROC
Stored procedure to provide clean output of system name and uptime since last restart
2010-11-16 (first published: 2010-11-08)
1,278 reads
SQL Server Service Check Utility
Script will display current status of SQL server services and even show if not installed. Works on SQL 2005,2008 2008R2. Both 32 and 64 bit servers.
2010-11-15 (first published: 2010-11-09)
3,633 reads
Automate Range Right Partition Management with Powershell (Part II)
In the last script, we covered removing the trailing partition in a Range Right, date valued partition. This script adds a new (empty) partition to the partition scheme.
2010-11-12 (first published: 2009-12-17)
1,099 reads
Automate Range Right Partition Management with PowerShell
This script automatically splits a partitioned table, merges the partition function and then drops the associated file group for the partition.
2010-11-11 (first published: 2009-12-17)
2,251 reads
Extracting Logins From SQL Server
This script will help you transfer logins between one instance of SQL and another.
2010-11-08 (first published: 2010-01-07)
4,653 reads
How long has passed since SQL Server service started?
Days, hours and minutes since SQL Server service was started
2010-11-05 (first published: 2010-01-15)
2,520 reads
Index Seeks, Scans, and Lookups
This script may help identify tables impacted by frequently-occurring scans.
2010-11-02 (first published: 2010-02-04)
3,919 reads
Change String to Title Case(Initcap)
This is simple script to change string to title case. It will take string in any case and convert it to initcap.
2010-10-26 (first published: 2010-10-19)
1,559 reads
Data Dictionary using sys.objects - SQL 2008
Create a data dictionary with two stored procedures using sys objects to view via SSRS (or other reporting tool) report
2010-10-21 (first published: 2010-10-16)
2,286 reads
Blogs
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
Your AI is busy. But do you know what it's worth? Most companies can...
Forums
Alamat BCA KCU BINTARO Telp:0821°8200°233
Telp/Wa 628218200233 Bintaro Jaya Blok A-5 No.12 & 15, Sektor 7, Pd. Jaya, Kec....
Alamat BCA KCP Labuan Telp:0821°8200°203
Telp/Wa 628218200203 Jl. Raya Labuan - Pandeglang No.01, Labuan, Kec. Labuan, Kabupaten Pandeglang, Banten...
Alamat BCA KCP Cilegon II Telp:0821°7555°651
Telp/Wa 628217555651 Ruko Cilegon City Square, Jl. Pondok Cilegon Indah No.1 Blok A No....
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers