2010-03-29 (first published: 2010-03-24)
1,837 reads
Scripts
Finding rows count in a table without Select...
Here is a one more very quick way to find row count for a table.
2010-03-26 (first published: 2010-03-23)
5,382 reads
Credit Card Number Validation Escalar Function
Evaluate credit card numbers based on ISO 2894 algorithm.
2010-03-24 (first published: 2010-03-17)
1,918 reads
Script to get Phonetic Pronunciation of a given password
This script displays Phonetic Pronunciation of a given password
2010-03-22 (first published: 2010-03-12)
1,387 reads
2010-03-17 (first published: 2010-03-04)
1,529 reads
EXECute SQL Commands over entire sets of parameters!
A super-powered EXEC on steroids, the Power Tool every DBA wants for Christmas.
2010-03-16 (first published: 2010-03-04)
2,924 reads
Unused Objects in the Server
This Script is used to List out the objects lying in the box which were un used from the day of the sql server recycled.
2010-03-09 (first published: 2010-02-18)
1,921 reads
ServerProperty query with case function
Returns all properties from ServerProperty, also has a case function for EditionID and EngineEdition.
2010-03-08 (first published: 2010-02-18)
1,364 reads
Fix users for SQL 7 thru 2008
This script will either reoprt or 'fix' lost or orphaned users after restore for all versions of SQL.
2010-02-24 (first published: 2010-02-04)
2,251 reads
See the compile time
Useful if you think a SQL statement, Function, or SPROC is taking too long to compile.
2010-02-23 (first published: 2010-02-04)
970 reads
Blogs
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers