2008-12-02 (first published: 2008-10-30)
1,427 reads
Scripts
Get SQL Server 2005: Details about running or defined traces
This provides information about traces that are defined on SQL Server 2005.
2008-12-01 (first published: 2008-10-25)
1,285 reads
SQL 2005 Get Roles, Schemas & Object Permissions
Pulls all DB/Server fixed roles, default schemas & object permissions for all logins
2008-11-28 (first published: 2008-10-25)
2,395 reads
How to Drop Unused Empty Redundant columns
Often during the development lifecycle columns are added to tables that become redundant or remain unused.
this script removes unused (empty) columns
2008-11-27 (first published: 2008-10-22)
1,181 reads
Get the all the SQL Server related services information
Get the all the SQL Server related services information,
2008-11-26 (first published: 2008-10-13)
1,264 reads
2008-11-25 (first published: 2008-10-20)
1,324 reads
AUTOGENERATE INSERT UPDATE SELECT STATEMENTS
use metadata to generate basic create procedure statements for insert update and select
2008-11-22 (first published: 2008-10-10)
3,832 reads
AUTOGENERATE Stored procedures example
This is related to my other autogenerate code. this is just an example of how to use it.
2008-11-21
750 reads
2008-11-20 (first published: 2008-10-06)
973 reads
random randomise randomize data query
this is a MUCH simpler method of random randomize randomise rand data from a table
2008-11-19
290 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers