2015-12-29 (first published: 2015-12-09)
2,005 reads
Scripts
Add empty first step for every job
This script adds empty first step for every job for easier job history viewing.
2015-12-28 (first published: 2015-12-10)
1,900 reads
2015-12-25 (first published: 2015-12-17)
1,741 reads
String Search
Search for a string value within columns of data types CHAR, NCHAR, NTEXT, NVARCHAR, TEXT, VARCHAR, XML.
2015-12-24 (first published: 2012-03-19)
6,813 reads
Object Search
Procedure to search any database (or a combination of databases, including all) for a specific string found in column names, object names, and / or object definitions.
2015-12-23 (first published: 2009-04-29)
5,059 reads
2015-12-22 (first published: 2012-11-26)
3,428 reads
Know read and write ratio before you tune database performance
A script to get the user table query ratio and update radio,etc
2015-12-21 (first published: 2015-12-11)
1,811 reads
2015-12-18 (first published: 2015-12-09)
4,666 reads
SQL server Service, Account, Trace Flag info
This script outputs sql server service, start type, status, Service Account, installation location, start up time, uptime of sql server related services along with startup trace flags.
2015-12-17 (first published: 2015-12-09)
1,159 reads
Script to configure Log File Size for Large DBs
Use this script to set recommended Log files size growth for larger DBs. For more, please refer article: http://sqlmag.com/blog/choosing-default-sizes-your-data-and-log-files
2015-12-15 (first published: 2015-12-07)
1,253 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
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...
Forums
10 Reasons the 2CT Engagement Ring Is the Most Popular Proposal Choice Right Now
Walk into any jewelry consultation these days and you’ll hear a familiar request: “Something...
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions
Comments posted to this topic are about the item Stairway to DAX and Power...
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers