Overview of Azure SQL Database Networking
Learn about the range of connectivity options available for Azure SQL Database deployments.
Finding Non Current Cumulative Updates
A short article to help you quickly find a CU that isn't the latest one.
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.
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.
Stairway to Columnstore Indexes Level 1: A First Look At Columnstore Indexes
This level introduces of you to the fundamentals of columnstore indexes, introdused in SQL Server 2012 to manage the indexing of very large tables.
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!
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.
Better Protection from Hardware
Today Steve looks at a research project from Microsoft that provides some better protection from firmware security issues.
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 […]
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers