In many enterprises, where there are a number of separate systems engaged in processing data, there arises the daunting task of checking and reconciling data as it flows between systems. Discrepancies in data must be detected, tracked and corrected as quickly as possible: there is no room for error in doing this. A Reconciliation Hub can provide the answer, as Rahul Gupta explains.
In this article, you will learn how to troubleshoot backup failures in SQL Server 2016 when you run using commvault backup tool
DevOps is supposed to help us build better software, faster. Steve Jones looks at one of the other benefits: security.
Ben Snaidero explains that if you are updating your SQL Server table statistics nightly, but still seeing occasional poor performance with some of the queries being executed against my database, statistics could be the issue.
This article demonstrates using Angular2 and the CData API Server to build dynamic Web pages using SQL Server data.
Have you ever had a need to place some simple row level security on a SQL Server table? Well now you can do that in SQL Server 2016 by...
When you force a query plan via the Query Store, you will need to track what happens: Sometimes the request to force a plan will fail, and you will want to know when and why. There are several ways of getting feedback, ranging from the built-in reports to using extended events. Enrico explains the details.
Today Steve Jones looks at how we can better build software by considering the cloud.
Microsoft's Customer Experience Improvement Program for SQL Server: once easy to avoid, now hard to ignore, but Rodney Landrum sees an upside.
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Comments posted to this topic are about the item Squared Values
Comments posted to this topic are about the item I Don't Want To Do...
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers