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
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
Dealing with huge heap tables
Recently, our dev teams approach me for advice on improving their huge heap table...
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers