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.
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.
Tony Davis answers 10 surprisingly tricky questions about SQL Server Transaction Log.
How do you make data available to analysts who want to blend data with R or Power Query tools? Why with OData services.
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.
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.
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.
In a guest post, Rodney Landrum ponders the gaps in his DBA experience at the edge of Lake Erie.
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
I’m doing a small series on indexing basics for SQL Server, and on May...
By Quay thu XSMN hôm nay - quay thu MN - KETQUA.TV
Gedung, Wisma Barito Pacific, Jl. Letjen S. Parman No.Kav. 62-63, Slipi, Kec. Palmerah, Kota...
Komplek, Ruko Niaga Grisenda, Jl. Pantai Indah Kapuk Jl. Kapuk Raya No.19-20 Blok GE,...
BCA KCP Kramat Jati Telp/WA0851•8812•0691 Jl. Raya Bogor No.19, RT.1/RW.4, Wil, Kec. Kramat jati,...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers