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,933 reads
Scripts
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,922 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,374 reads
Changing Foreign key names to standard naming convention across the DB
Rename the Foreign keys to standard notation - FK_childTable_ParentTable
2010-02-24 (first published: 2010-02-09)
1,177 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)
972 reads
Serial ID Auto Generation
Scripts used to create the functionality to auto-generate your very own customized serial IDs.
2010-02-22 (first published: 2010-02-04)
1,850 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-19 (first published: 2010-02-04)
2,254 reads
2010-02-15 (first published: 2010-01-18)
23,679 reads
Database Users And Associated Database Roles
This script basically retreives all database users thier database roles for a database.
2010-02-10 (first published: 2010-01-20)
3,493 reads
2010-02-08 (first published: 2010-01-13)
4,161 reads
Blogs
Day of Data Baton Rouge Slides and Code
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
The Book of Redgate: Products
By Steve Jones
We are product focused at Redgate Software. Here is another of our values that...
Forums
ALAMAT BCA KCU SEMARANG Telp:083178278662
WA CS:083178278662 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
ALAMAT BCA KCU BALIKPAPAN Telp:083178278662
WA CS:083178278662 Jl. Jenderal Sudirman No.139, Klandasan Ilir, Kec. Balikpapan Kota, Kota Balikpapan, Kalimantan...
The SQL Server 2016 Plan
Comments posted to this topic are about the item The SQL Server 2016 Plan
Question of the Day
BIT_COUNT() III
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers