Partitioning Data in SQL Server without using Partitioned Tables
In this we look at how we to quickly split up data from a SQL Server table into relatively equal size buckets.
2019-09-17
Additional Articles
SQL Server 2019 Graph Database and SHORTEST_PATH
With SQL Server 2019 on the way, it’s time to begin learning about all the new features. In this article, Dennes Torres demonstrates how to use the new SHORTEST_PATH function that is part of the Graph Database feature.
2019-09-17
Working with React Components
The React library allows teams to work faster and with more consistency. In this article, Camilo Reyes explains how to get started using React components in a C# application
2019-09-16
Monitoring TempDB Contention using Extended Events and SQL Monitor
Sometimes, a database will slow down exponentially when it is working hard, with many concurrent users. Well, to be more accurate, all the databases on the instance will slow down.
2019-09-13
Research Paper Week: Plan Stitch: Harnessing the Best of Many Plans
In his latest blog posts Brent shares his favourite research papers, explaining why he found them interesting and why you might too. STarting off with the Microsoft Research paper Plan Stitch: Harnessing the Best of Many Plans by Bailu Ding, Sudipto Das, Wentao Wu, Surajit Chaudhuri, and Vivek Narasayya (2018)
2019-09-13
Goodbye to the Microsoft Professional Program
Kathi Kellenberger addresses the retirement of the Microsoft Professional Program in the latest SImple Talk Editorial. Stop by and let her know your thoughts.
2019-09-12
Neglecting to Use, or Misusing, the RETURN Keyword (BP016)
Phil Factor demonstrates the correct use of the RETURN keyword in stored procedures or batches, to pass back a non-zero RETURN code to the calling process, informing it of the error. He also explains some of its misuses.
2019-09-12
How to Stop a SSIS Package Execution from Code
In this tip we look at a way to stop the execution of a SSIS data flow task that is running by executing an outside process to stop the data flow immediately.
2019-09-11
Self-service and Delegation with SQL Clone 4 Teams
SQL Clone 4 introduces a new access control feature called Teams, allowing granular control over the SQL Server instances, images and clones to which each group of users has access. Here James Murtagh explains how Teams makes it easier to manage the safe distribution of database copies throughout the organization, to the various teams that need them for development, testing, training or analysis.
2019-09-11
Deployment of SQL Server 2019 Always On Availability Groups on Azure AKS
Step through a demonstration illustrating a sample deployment of SQL Server 2019 Always On Availability Group cluster on Azure AKS. You'll discover how to leverage the Microsoft Azure-hosted managed Kubernetes service referred to as AKS.
2019-09-10
Blogs
In Memory of Andrew Clarke, AKA Phil Factor
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
Leading Through the Noise: Harnessing Data in the Age of Digital Overload
By Chris Yates
The New Leadership Frontier In today’s digital landscape, leaders are no longer just visionaries....
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Forums
taking the rcsi dive
Hi, we put together an extract that runs every 15 minutes against what i...
Parameter Sensitive Plan Optimization in SQL Server 2022
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Minimum Change Tracking Retention
Comments posted to this topic are about the item Minimum Change Tracking Retention
Question of the Day
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