I always look forward to new T-SQL features and optimizer enhancements with every new version of SQL Server. Starting in 2017, Microsoft came up with a set of features called Intelligent Query Processing (IQP). These features work to improve performance without changing any code. If you’d like to learn more about these features, take a […]
Today Steve looks at an article the migrates a relational model to CosmosDB.
If some of your database constraints have system-generated names, they can cause 'false positives' when comparing schemas and generating build scripts using SQL Compare or SQL Change Automation. Phil Factor explains the difficulties, and the Compare option you need to enable to avoid them.
Throughout this series, Roberts Sheldon has discussed a range of storage-related topics, some of which he mentions only briefly. One of those is cloud storage, which now plays a vital role in today’s data management strategies. Organizations of all types and sizes now employ cloud storage to varying degrees, either to supplement their on-premises systems or to handle the bulk of their data. Because cloud storage has become so pervasive, this article focuses exclusively on that topic, describing what it is, how it works, and its benefits and challenges.
The purpose of this document is to help design Unix shell scripts (or any programming scripts) with restart capability from point of failure and also to avoid a common mistake done by developers/admins while filtering records.
David Atkinson describes how developers who were previously writing and managing SQL source code in SSMS can make a smooth transition to Azure Data Studio.
Intel is building hybrid processors, combining the power of the regular CPUs most of us use with Atom power saving technology.
Joe Celko tackles the most difficult of all the types of data handled by SQL, temporal data, and explains how to avoid the commonest traps for the unwary programmer
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
I recently needed to ensure that a Power BI imported dataset would be refreshed...
Hi all, I need to migrate a SQL 2012 database that has a few...
Comments posted to this topic are about the item Controlling Intelligent Query Processing Features
I have this function, but I wanted to pass a table so as to...
Ask SSC