Outlining My Session: Index Tuning in an Agile World
I’m giving a session on index tuning at the upcoming Redgate Streamed free online conference. The conference will be held April 1-3 2020, register here and join us! I...
2020-03-20
33 reads
Blog Posts
Window Shopping the Query Store with XEvents
This article has just shared multiple tools to help you become more acquainted with the Query Store! This acquaintance is coming via an extremely powerful tool called Extended Events....
2020-03-20 (first published: 2020-03-12)
190 reads
Announcing Redgate Streamed, April 1-3 2020
We’re thrilled to announce Redgate Streamed: a 3 day online virtual community conference, to be held April 1-3, 2020. Register at Redgate.com/RedgateStreamed In this 9 minute livestream, I give...
2020-03-19
15 reads
Missing #SQLFamily? Check This Out.
I am an introvert. Lots of people don’t believe it, but it’s true. However, I really do love getting to see my #SQLFamily all over the world in my...
2020-03-19
19 reads
Power BI Security
A common topic I have been discussing recently with customers is the security around Power BI. Basically, how to prevent users seeing data they shouldn’t. So I’ll discuss the...
2020-03-19 (first published: 2020-03-10)
624 reads
Query Store for Workload Replays
UPDATE: 3/16/2020The first script below was updated from setting QDS to “Read_Write” instead of “Read_Only”. Martin thank you for pointing this out in your comment below. This month’s T-SQL...
2020-03-19 (first published: 2020-03-11)
367 reads
SQL Server on Linux? Start on Azure
I’ve talked for months now about the ability to run SQL Server on the Linux platform. For those of you interested in exploring the benefits of this platform, you’re...
2020-03-19
124 reads
The Learner’s Guide to SQL Server Performance Triage
I’m introducing a series of “learner’s guides” — overviews of a given topic, chock full of links and references. For this first post, the information is based on what...
2020-03-19
66 reads
There needs to be a win
A while back a company I worked for had two teams. One was a development team and the other was ... Continue reading
2020-03-19
110 reads
On the continuity of business
With entire countries shutting their borders, and people being forced to stay home and isolate themselves for as long as possible while health departments ramp up to handle this...
2020-03-18
6 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
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...
Forums
Cross-DB Ownership Chaining problem
We want to setup a gateway db to host stored procedures which use tables...
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...
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