Measuring Career Growth
A guest editorial from Tim Mitchell today looks at keeping track of what we have done in our careers, and the value that it gives us.
Getting Starting with Database Engine Tuning Advisor in SQL Server – Part 1
There are different techniques to optimize the performance of SQL Server queries but wouldn’t it be great if we had some recommendations before we started planning or optimizing queries so that we didn’t have to start from the scratch every time? This is where you can use the Database Engine Tuning Advisor utility to get recommendations based on your workload.
Stairway to Database Source Control Level 3: Working With Others (Centralized Repository)
One of the main purposes of placing a database under source control, alongside the application code, is to allow team collaboration during development projects. The Version Control System (VCS) stores and manages all of the project files, maintaining an audit trail of what changed, and who made the change. Each team member can work on a file, or set of files, and submit their changes to the VCS to make them available to other team members. They can also inspect the VCS to discover recent changes made by other team members.
Questions About SQL Server Transaction Log You Were Too Shy To Ask
Tony Davis answers 10 surprisingly tricky questions about SQL Server Transaction Log.
Data Warehouse to OData to Excel and R
How do you make data available to analysts who want to blend data with R or Power Query tools? Why with OData services.
Reviewing Logical Hard Drive details using T-SQL and OLE Automation Procedures
One of the most important SQL Server DBA tasks is checking logical hard drive details such as the total capacity, free disk space, and used space by the SQL Server data and log files. In this tip we look at a method to view this information in a faster and simpler way.
Silicon Valley - DLM Training Workshop – Database Continuous Integration
Learn how to do SQL Server continuous integration at the first in a new series of Database Lifecycle Management Training Workshops, in Silicon Valley on March 27. To celebrate the launch, places for this workshop are free.
Are My Problems Caused By Replication?
We frequently need to discover the source of issues with our databases. This article provides information on how to detect replication on a database as a possible source of issues.
Pier to Pier Replication on Frozen Lake Erie
In a guest post, Rodney Landrum ponders the gaps in his DBA experience at the edge of Lake Erie.
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers