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.
What should you do about memory dumps?
A SQL Server monitoring tool is warning you that you’re getting memory dumps, and you’re wondering what that means.
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Forums
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Finely Tuned Models
Comments posted to this topic are about the item Finely Tuned Models
Question of the Day
RegEx Functions III
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers