Update Your Audit Queries for SQL Server
I was working with an auditor today who is working through a system with an external audit agency. The external...
2013-06-13
2,140 reads
Blog Posts
Virtual SQL Playground Adventure: Introduction
Welcome to the Virtual SQL Playground Adventure! Why Adventure? What’s an Adventure?
An adventure is an exciting or unusual experience; it may...
2013-06-13
1,489 reads
Why should we upgrade off of SQL Server 2000?
A good many companies still have servers chugging along on SQL Server 2000 (or even, as some of us noted...
2013-06-13
907 reads
Agile Database Administration
I first heard the word “agile <something>” about 10 years ago, I do not have profound experience to what “agile...
2013-06-12
364 reads
Agile Database Administration
I first heard the word “agile <something>” about 10 years ago, I do not have profound experience to what “agile...
2013-06-12
1,319 reads
Building a SharePoint 2013 BI Demo Environment Part 10 – Creating a BI site
In the final part of this series, we will create a BI subsite in our site collection. You can use...
2013-06-12
3,082 reads
Building an Effective Data Warehouse Architecture Presentation
I will be presenting the session “Building an Effective Data Warehouse Architecture” this Thursday, June 13th at 11:00am EST for Pragmatic Works. Below is...
2013-06-12
936 reads
Centralized SSIS solution to monitor failed SQL Server Agent Jobs across the enterprise
SQL Server Agent Jobs are crucial to any SQL Server environment as they are created and scheduled to perform critical business...
2013-06-12
891 reads
Looking to SQL Server 2014 High Availability In Standard Edition
During the keynote for TechEd North America 2013, Microsoft announced the planned release of SQL Server 2014. As part of...
2013-06-12 (first published: 2013-06-10)
3,633 reads
Monitoring Blocked Processes with Event Notifications
SQL Server is able to service requests from a large number of concurrent users. When SQL Server is servicing requests...
2013-06-12
1,219 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers