2008-12-17 (first published: 2008-11-10)
2,683 reads
Scripts
2008-12-17
110 reads
Backup and Truncate Transaction Logs
Save the transaction log and truncate the file to prevent Tlogs FULL Error
2008-12-16 (first published: 2008-11-17)
2,701 reads
Get Data, Log, Backup, and Binn Directory (SQL Server 2005)
Use this to find Data, Log, Backup, and Binn Directory for SQL Server 2005
2008-12-15 (first published: 2008-11-18)
1,660 reads
Change Ownership of a Maintenance Plan
Change owner of a maintenance plan so the SQL Agent jobs have the correct owner for running.
2008-12-12
3,189 reads
2008-12-12 (first published: 2008-11-19)
855 reads
2008-12-08 (first published: 2008-11-07)
459 reads
Finding all data types in user tables
A quick way to get a snapshot of what data types are being used in all user tables.
2008-12-04 (first published: 2008-10-02)
1,102 reads
2008-12-03 (first published: 2008-10-29)
1,120 reads
MSSQL Job Monitoring Simplified using Simple Query
This query states the execution status of the job i.e. Executing, idle etc. you also modify and search the jobs by changing the search condition.
2008-12-02
1,028 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
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...
How to change the FDLaunch Error log file location
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
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...
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