What to Do When You Get a “Cache is Out of Date” Error Message
Greg Larsen shows how to fix the “cache is out of date” error message when SQL Server Management Studio starts up.
A well-earned break from the database
Databases, like sheep, get get into some surprising scrapes. However, as long as you've planned for all the common mishaps, your conscience should be clear to take a well-earned holiday.
Practice Until You Don't Get It Wrong
We will all make mistakes, but practice can help reduce the errors we cause.
SQL Saturday statistics – Web Scraping with R and SQL Server
Tom wants to check a simple query: How many times has a particular topic been presented and from how many different presenters.
Bones of SQL - The Calendar Table
This article introduces the concept of the Calendar table to SQL newcomers and illustrates use of a few columns they might not have imagined.
Implied Predicate and Partition Elimination
Erik Darling's delighted to see that SQL Server does some creative partition elimination.
The Pressure to Perform
Steve Jones wonders how things might be different is developers were treated more like salespeople with quotas.
Dynamic Data Masking on Azure SQL Database
Azure SQL Database’s Dynamic Data Masking (DDM) feature limits the exposure of sensitive information to non-privileged users. DDM can mask either the full value or partial value in a column. This method can also mask Social Security and Credit Card Numbers without making any changes to the application.
Blogs
In Memory of Andrew Clarke, AKA Phil Factor
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
Leading Through the Noise: Harnessing Data in the Age of Digital Overload
By Chris Yates
The New Leadership Frontier In today’s digital landscape, leaders are no longer just visionaries....
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Forums
Parameter Sensitive Plan Optimization in SQL Server 2022
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Minimum Change Tracking Retention
Comments posted to this topic are about the item Minimum Change Tracking Retention
AI Steals Joy
Comments posted to this topic are about the item AI Steals Joy
Question of the Day
Minimum Change Tracking Retention
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers