Performance Tuning Using Free Tools, Part 2
You can do essential performance tuning on your SQL Server databases using a FREE toolkit!
2022-01-14
2,589 reads
database administration
SQLFacts - A Free Toolkit for SQL Server Database Engineers
SQLFacts is a FREE suite of 26 (and counting) tools for SQL Server database development, database administration, and performance tuning. The toolkit is all T-SQL code and it includes the functionality of hundreds of short scripts.
2021-11-19
6,570 reads
Building blocks of Extended Events data collection
Extended Events have been part of SQL Server since 2008. In this article, Ed Pollack explains the building blocks of Extended Events data collection.
2021-10-04
Improving performance with instant file initialization
Instant file initialization can speed up database creation, file growth, and restores. Greg Larsen explains how to configure it and how it works.
2021-08-18
Much Ado about nothing: missing data
Joe Celko explains how missing data is handled from the printing press to databases.
2021-07-26
SQL Server and hyperconvergence
To be efficient and save money, many organizations are looking at hyperconverged infrastructures for SQL Server. In this article, Robert Sheldon explains what to consider for SQL Server and hyperconvergence.
2021-07-09
SQL Server performance tuning: Nine best practices
SQL Server performance tuning can seem overwhelming when you don’t know where to start. In this article Robert Sheldon explains 9 best practices for performance tuning.
2021-06-16
How to Find Unused Databases in SQL Server
In this article we look at how to identify if SQL Server databases are not being used and a process to take these unused databases offline.
2021-06-14
Running Dynamic Code Quality Checks on Flyway Databases: Table Smells
How to extend the range of SQL code analysis, during database development, to include dynamic analysis of the database metadata. This will allow regular checks for problems with the design of your tables and indexes ("table smells") that can affect database performance and data integrity.
2021-05-10
Building a SQL Server data dictionary
In this article, Edward Pollack explains the benefits of a SQL Server data dictionary and how to build one.
2021-04-29
Blogs
Learn some critical SQL Security with the MidnightDBAs (Thursday, Jan 20)
By Jen McCown
Friends, the MidnightDBAs have a plan for 2022. A capital-P Plan. And it involves...
CosmosDB and Consistency
By Steve Jones
I was doing a little work with CosmosDB recently, and there were a few...
Daily Coping 17 Jan 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Linked Server UPDATE & DELETE fails . But INSERT & SELECTs work fine
Hello, I have a Windows 2019 machine. I have SQL Server 2016 and the...
Extended Events - how can I query the location of File Target of an XE Session?
If I know the XE Session name, is there a query to find out...
tricky query with patterns of consecutive rows
Hi! I'm having struggle with selecting rows, that match "dynamic" rules as described: if...
Ask SSC