I’m really excited for Redgate’s new SQL Change Automation plugin for SQL Server Management Studio (SSMS). SQL Change Automation lets DBAs and developers use a migrations-first approach to create...
2019-08-26
15 reads
One of the things I needed to do recently was get Jenkins running as a demo for a customer. We have some pre-built VMs to do this, but I...
2019-08-26 (first published: 2019-08-14)
488 reads
Watch this week’s Execution Plan Operators episode on YouTube. SQL Server Execution Plan Operators When examining a query’s execution plan, certain operators tend to crop up over and over...
2019-08-26 (first published: 2019-08-13)
1,576 reads
How to read execution plan to improve poorly...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-08-25
179 reads
This is the fourth article of the Machine Learning topic. I have introduced you to the Machine Learning, described the process and the tools. My first idea was that...
2019-08-24 (first published: 2019-08-11)
50 reads
To be honest you probably think that migrating to the cloud sounds great, and it can be, but… it’s not without risks and many people do not sufficiently understand...
2019-08-23
28 reads
Do you execute DBCC CHECKDB on your Azure SQL Database? From past experience I know some people do, I would suggest not to bother. Why? Well I have mentioned...
2019-08-23
27 reads
Today we have launched Data Céilí Dublin 2020, Ireland’s free, community led, Microsoft Data Platform event. (It’s pronounced kay-lee btw ?? ) Brought to you by the team behind...
2019-08-23
19 reads
I did a couple of recent podcasts that I wanted to mention: The first one was with Kirby Repko from the YouTube channel SQLTalk: Modern Data Warehouse Design with...
2019-08-23 (first published: 2019-08-08)
481 reads
Still learning more about Kubernetes. I’ve been working through the 50 days of Kubernetes (K8s). Let’s keep exploring The API is the security boundary Everything happens with the Kubernetes...
2019-08-23 (first published: 2019-08-12)
376 reads
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
A while back I wrote a quick post on setting up key mappings in...
By Steve Jones
In 100 years a lot of what we take to be true now will...
Comments posted to this topic are about the item Lots of FKs
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Comments posted to this topic are about the item Can You Let Go of...
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers