Change operating modes for SQL Server Database Mirroring
SQL Server Database Mirroring offers two methods for exchanging data: synchronously and asynchronously. Sometimes there may be a need to switch between modes for an existing mirror and in this tip we will look at how this can be done.
Dynamic Grouping in SSRS Reports
This article shows how you can create a dynamic report in SQL Server Reporting Services (SSRS), walking you through the steps needed to create a dynamically-grouped report.
How To Keep Up with SQL Server
It can be a challenge to keep up with the rapidly evolving SQL Server platform. Andy Warren has a few ideas today.
Call for Speakers - SQL Saturday Pittsburgh
SQL Saturday #440 is coming to Pittsburgh on October 3, 2015. Now is the time to submit if you'd like to speak at the event.
SQL 2014 Clustered Columnstore Index Rebuild and Maintenance Considerations
Building (or rebuilding) a Columnstore index can be a resource intensive operation. In this article, Denzil Ribeiro describes the index rebuild process and index maintenance for clustered Columnstore indexes in SQL 2014.
Detecting Differences in Files on Servers
Detecting file differences on two different web servers using T-SQL.
Download tSQLt Today and Start Unit Testing
The latest version of tSQLt is now available with some SQL Prompt snippets to help you get started.
The Security Payoff
An invitation to hack United's IT systems has resulted in vulnerabilities being found and hackers rewarded for disclosing the issues.
SQL Server Archive and Data Retention Considerations
Tim Smith looks at what to take into consideration before building a design to archive old data in SQL Server databases.
Blogs
Creating a Pulsing Conducting Baton - Part 1
By Bert Wagner
Train Wreck The last time I watched a high school band nearly fall apart mid-performance...
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Forums
We Are Eating Our Own Seed Corn
Comments posted to this topic are about the item We Are Eating Our Own...
Before Using AI with Business Data, Read This
Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...
Designing SQL Server ETL Pipelines That Don't Break at Scale
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
Question of the Day
Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers