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,254 reads
Scripts
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,544 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,066 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-11-12 (first published: 2010-10-19)
1,522 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,205 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,599 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,495 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,884 reads
Flexable Rate Recursion
A Recursion function that was used to apply a Rate percentage to a base amount for the reqested number of times.
2010-10-28 (first published: 2010-10-13)
575 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,257 reads
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
Finding Motivation
Comments posted to this topic are about the item Finding Motivation
The Last Binary Value of the Year
Comments posted to this topic are about the item The Last Binary Value of...
Question of the Day
The Last Binary Value of the Year
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers