[read this post on Mr. Fox SQL blog] The “modern data platform” architecture is becoming more and more popular as organisations shift towards identifying, collecting and centralising their data...
2019-07-16
7 reads
I’m excited that the Redgate Foundry is working on some cool projects. The Future of DevOps is one and part of that work is with Spawn. I’ve played with...
2019-07-16 (first published: 2019-07-01)
445 reads
Watch this week's video on YouTube
In order to stay current in a technology you have to immerse yourself in community content.
Documentation is good for knowing the specification of a...
2019-07-16
3 reads
Watch this week's video on YouTube
In order to stay current in a technology you have to immerse yourself in community content.
Documentation is good for knowing the specification of a...
2019-07-16
1 reads
Synchronization
Moving data between two cloud providers can be painful, and require more provider scripting if doing api calls. For this, you can benefit from a tool that abstracts the...
2019-07-16
8 reads
SQL Server engine does an excellent job to optimize query performance and it has different methods to achieve this goal, one of these methods is the data caching.Data caching...
2019-07-16 (first published: 2019-07-05)
1,102 reads
Recently, I needed to be able to determine the total size for all the most recent full backups for certain servers. Luckily for me these particular servers were using...
2019-07-15 (first published: 2019-06-28)
462 reads
Restore SQL Database Without Backup -Step By Step Guide
Microsoft SQL server is one of the best and the widely used relational database management system. The primary function of this...
2019-07-15 (first published: 2019-07-02)
1,791 reads
Pragmatic Works is hosting a 2-day Power Platform online conference. If you are unable to get out to onsite conference but need some help with Microsoft Flow, PowerApps, or...
2019-07-15
29 reads
When you are in charge of databases with tons of objects, making a small change over an object can be difficult to replicate if you have a lot of...
2019-07-15
3 reads
By gbargsley
Recently, I was in a technical interview where the topic of running PowerShell at...
By alevyinroc
I don’t recall where this came up (probably in SQLSlack), but I had a...
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
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