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,684 reads
Scripts
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,210 reads
2008-12-12 (first published: 2008-11-19)
886 reads
Report failed SSRS subscriptions
Generates a dataset for determining when subscriptions fail to send e-mail or post reports to file shares.
2008-12-10 (first published: 2008-11-19)
1,329 reads
2008-12-08 (first published: 2008-11-07)
492 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,144 reads
2008-12-03 (first published: 2008-10-29)
1,132 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,072 reads
2008-12-02 (first published: 2008-10-30)
1,442 reads
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,307 reads
Blogs
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
Your AI is busy. But do you know what it's worth? Most companies can...
Forums
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions
Comments posted to this topic are about the item Stairway to DAX and Power...
AI Is Improving Security
Comments posted to this topic are about the item AI Is Improving Security
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers