Statistics with T-SQL and R – the Pearson’s Correlation Coefficient
In this post I will attempt to explore calculation of a very basic statistic based on linear relationship between two...
2016-09-08 (first published: 2016-09-05)
3,207 reads
Why Would I Want to Use JSON in SQL Server?
SQL Server 2016 offers built-in support for JSON, in a similar way to the support offered for XML since SQL...
2016-09-04
653 reads
SPACE
USE CASE: When we are working on TSQL or some text based scripting we may need some extra space in between...
2016-09-04
197 reads
STUFF
Use case when we are working on TSQL or Query ,some time we came such a situation when we need...
2016-09-04
191 reads
DAX Date Dimension and Fun with Date Math
I was working on a SSAS Tabular 2016 solution for a project for which I had no data (an empty...
2016-09-03
658 reads
How to Resume Suspended Database Mirroring in SQL Server ?
Overview
Database mirroring is a feature in SQL Server which is creating and maintaining the redundant copies of the database. The purpose behind database mirroring is continuous data availability and...
2016-09-03
104 reads
How to Resume Suspended Database Mirroring in SQL Server ?
Overview
Database mirroring is a feature in SQL Server which is creating and maintaining the redundant copies of the database. The...
2016-09-09 (first published: 2016-09-03)
11,183 reads
TGI SQL Friday - Weekly Roundup 2nd September 2016
Weekly Summary
Last week I was holiday in Cyprus. The weather was plus 30 degrees celsius all week. The pool was...
2016-09-02
526 reads
SQLMonitor Adds Graphical Query Plans!
The SQLMonitor team at Redgate has been releasing updates at a much more rapid rate…what’s this mean to you? More fixes and more features. In this latest release, they...
2016-09-02
14 reads
SQLMonitor Adds Graphical Query Plans!
The SQLMonitor team at Redgate has been releasing updates at a much more rapid rate…what’s this mean to you? More...
2016-09-02
482 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Hyperscale Replicas III
Comments posted to this topic are about the item Hyperscale Replicas III
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers