Controlling how SQL Prompt Formats your Code: The Knobs and Dials
Phil Factor explores and discusses the current state of the art in SQL Formatting, as done automatically by SQL Prompt.
2019-12-20
Articles
Overview of Azure SQL Database Networking
Learn about the range of connectivity options available for Azure SQL Database deployments.
2019-12-20
Finding Non Current Cumulative Updates
A short article to help you quickly find a CU that isn't the latest one.
2019-12-19
1,418 reads
Memory-Optimized TempDB Metadata in SQL Server 2019
In this article we look at a new feature in SQL Server 2019 that can help improve TempDB performance.
2019-12-19
Redgate acknowledged as a Representative Vendor in Gartner’s 2019 Market Guide for Data Masking
Data Masking is key to providing realistic test data for DevOps teams while ensuring compliance with GDPR, CCPA, HIPAA and other regulations. Gartner recently published their 2019 Market Guide for Data Masking covering their analysis, recommendations, and Representative Vendors – including Redgate. Get the Complimentary Report.
2019-12-19
A Beginner’s Guide to SQL String Functions
Get an introduction to many of the many ways you can manipulate and interact with strings using SQL. Read on for more!
2019-12-18
Take the 2020 State of Database DevOps Survey – win a new iPad
Redgate’s 2020 State of Database DevOps Survey is open now. Share your views on Database DevOps today for a chance to win a new 65GB iPad Air. Plus, for every entry, Redgate will donate $1 to UNICEF. Take the survey now.
2019-12-18 (first published: 2019-11-12)
Monitor Current Analysis Services Activity
Although not every business has SSAS (SQL Server Analysis Services) installed nor use it extensively, the ones who do also care about their database responsiveness. If it is slow, what else is running that may be causing the slowness? Are there any locks? What commands are being run, who is running them, from where? How […]
2019-12-17
9,992 reads
Test data provisioning for development – free whitepaper
Compare the most common approaches to provisioning test data to database development teams and see how they stack up.
Learn why traditional approaches like restore from backup are no longer suitable, and how successful organizations are implementing a combined data masking and data virtualization approach.
2019-12-17
Update only Year, Month or Day in a SQL Server Date
In this tip we look at how to change specific parts of a date such as the Year, Month or Day for data stored in a SQL Server table.
2019-12-17
Blogs
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...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Forums
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Having a Little Fun at SQL Server Central
Comments posted to this topic are about the item Having a Little Fun at...
Designing SQL Server Pipelines That Are Ready for AI Before You Actually Need AI
Comments posted to this topic are about the item Designing SQL Server Pipelines That...
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