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 […]
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.
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.
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers