Data Mining Part 25: Microsoft Visio Add-Ins
In the chapter 18-22 we explained how to work with Microsoft Excel to Access to the Data Mining information. This time, we will explain how to work with Microsoft Visio.
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.
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers