2012-11-21 (first published: 2012-10-02)
1,588 reads
Scripts
2012-11-16 (first published: 2012-10-02)
1,205 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,235 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,086 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,946 reads
2012-10-30 (first published: 2012-10-12)
2,327 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,887 reads
2012-10-26 (first published: 2012-10-02)
955 reads
2012-10-25 (first published: 2012-10-12)
1,954 reads
2012-10-23 (first published: 2012-09-12)
2,979 reads
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
cons for a dev machine in a different version of sql from our prod server
hi, im not a dba. For a couple of years our dev sql server...
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers