2012-11-21 (first published: 2012-10-02)
1,577 reads
Scripts
2012-11-16 (first published: 2012-10-02)
1,202 reads
Script to construct a restore/recovery script
Constructs a restore script for all databases on the server from backup history.
2012-11-12 (first published: 2012-09-26)
1,233 reads
Search for String in all columns
Find all columns containing a string value across all tables and schemas.
2012-11-07 (first published: 2012-10-12)
2,075 reads
Shrinking all log files on SQL Server 2008R2
It shrinks all log files for the databases created by users.
2012-11-02 (first published: 2012-09-27)
3,927 reads
2012-10-30 (first published: 2012-10-12)
2,323 reads
Lists tables, Stored Procedures and other Objects
This stored procedure helps you list all tables, stored procedures, functions, view and triggers in a database.
2012-10-29 (first published: 2012-10-03)
1,884 reads
2012-10-26 (first published: 2012-10-02)
946 reads
2012-10-25 (first published: 2012-10-12)
1,945 reads
2012-10-23 (first published: 2012-09-12)
2,967 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
degree of parallelism
Team, I'm trying to figure out what will be the best recommendation to configure...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers