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
11 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)
484 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,567 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
173 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)
47 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
25 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
25 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
16 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)
477 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)
371 reads
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
By Chris Yates
The New Leadership Frontier In today’s digital landscape, leaders are no longer just visionaries....
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Hi, we put together an extract that runs every 15 minutes against what i...
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Comments posted to this topic are about the item 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