What Is a Cost-Based Optimizer?
When you execute a query, the database server has to figure a lot of things out. For even the simplest queries, there are usually several possible ways to get the job done.
2021-10-18
Articles
Model and Log Trend Reversals for Time Series Data in SQL Server
This tip demonstrates models for detecting the start of periods of rising or falling financial securities prices based on exponential moving averages. The demonstration is simplified because it relies on a log to keep track of time series values as well as exponential moving averages with different period lengths.
2021-10-15
Monitoring Large Estates at BMW
BMW have been monitoring their SQL Server estate for more than 7 years, but with evolving technology and circumstances, monitoring also needs to change and grow. Join Tony Maddonna in conversation with Redgate's James King, to discover how BMW are handling the challenges.
2021-10-15
Database technology trends
Big data can be risky, which is why you need great estate management. Join Matt Schmelzer, Data Systems and Automation - IT, and Jonathan Holck, IT Associate, from Artisan Partners in discussion with Microsoft MVP Grant Fritchey to learn how they implemented a successful infrastructure and what tools they need to support their growing estate.
2021-10-13
SSRS IIF, Switch and Choose Functions for Dynamic and Appealing Reports
Learn how to use IIF, Switch and Choose logical functions in SSRS reports to make your reports more dynamic and more appealing to report users.
2021-10-13
Using Azure Data Studio and the SQL Migration Extension to Perform Offline Migrations
Learn how you can perform an offline migration of a SQL Server to Azure Managed Instances or IaaS VMs.
2021-10-11
2,500 reads
Building an ETL with PowerShell
There are many ways to load data into a SQL Server database. In this article, Greg Moore demonstrates how to get PowerShell to do more of the work.
2021-10-11
State of Database Monitoring Report 2
We’re sharing the results of our State of Database Monitoring survey in four insights reports this year – and the second one is out now. In The value of a monitoring tool for the entire organization you’ll learn why more businesses than ever are using a monitoring tool and how doing so can help the entire business to reduce costs, enhance security and collaborate more efficiently. DBAs - download a copy and send it to your boss, today!
2021-10-11
2021-10-08
2,287 reads
Databricks Delta Change Data Feed
In this article we cover how to implement a batch Databricks Change Data Feed process through an end-to-end exercise.
2021-10-08
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers