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.
Avoiding Development Taxes
Anytime we adopt a new technology, framework, platform, language, etc., we will pay a tax in development output.
More SQL Server Features that Time Forgot
SQL Server produces some great features, but it would be impossible to get them spot-on target every time. We are now quietly advised to use caution about using some of them, such as AutoShrink or the Index Advisor. Others, like the database diagramming tool, almost seem to have been quietly abandoned. Robert Sheldon investigates.
Importing Historical Stock Prices from Yahoo Finance into SQL Server
Rick Dobson demonstrate a clean end-to-end solution for importing historical stock ticker prices from Yahoo Finance into a SQL Server table using Python.
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers