Data and database management in everchanging technology landscape
This article discusses how the cloud and other technologies help companies to manage their data appropriately in the modern world.
2022-03-23
1,473 reads
database administration
Oracle ASM: Migrating from UDEV devices to the ASM Filter Driver
This article looks at the way in which you can convert unmanaged devices to the ASM filter drive in an Oracle system.
2022-03-04
4,539 reads
SQL Server Monitoring Using Free Tools
You can do essential monitoring of SQL Server instances and databases with a FREE toolkit!
2022-01-28
7,109 reads
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
5,547 reads
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
10,026 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
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers