How Virtualized?
This week's poll asks about virtualization in your environment. Let us know if you are moving your SQL Server to virtual machines.
Transfer Data to the Cloud Using Azure Data Factory
In this tip we look at how to configure Azure Data Factory to move data from an on-premises SQL Server database to an Azure SQL Database.
Serious Hacking
The biggest government hack ever occurred recently. At least until the next one happens.
Improve the Performance of Your Azure SQL Database (and Save Money!) with Automatic Tuning
Organizations may have many concerns about performance when migrating databases to Azure. Fortunately, Microsoft provides some great tools to help improve performance and save money. In this article, Monica Rathbun explains how to take advantage of these features.
Shrinking SQL Server Backup Files and Speeding Up Backups
With backup compression you can speed up our backups, while making your backups smaller.
Dealing with Failure
A minor disaster in Colorado reminds Steve about the need to prepare, and think about the failure points in our preparations.
The V1 Team’s Doomed Redesign
A new version of an existing application doesn't always provide an upgrade.
What are Inline Indexes?
New releases of SQL Server arrive at a quick pace, and it's difficult to keep up with the many features introduced in each version. In this article, Phil Factor reviews a feature you may have missed, inline indexes. He covers the syntax and the many ways they can be used and then performs some performance tests to see if they can make a difference with table variables.
Create Power BI Connection to Azure SQL Database
Learn how to use Power BI to retrieve data from an Azure SQL Database.
Blogs
Data Skew in Data Engineering: What It Is and How to Fix It
You kick off a distributed job expecting it to finish in minutes — but...
SQL Server instance metadata inventory with PowerShell and SMO
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Forums
Fuzzy String Matching in SQL Server 2025
Comments posted to this topic are about the item Fuzzy String Matching in SQL...
Representing Money
Comments posted to this topic are about the item Representing Money
Celebrating 30 years of PostgreSQL, A Thank you message
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
Question of the Day
Representing Money
Which types of currency does the money data type represent?
See possible answers