SQL and SQL Only

SQL Server 2017 and Azure SQL Database are being touted as the self learning, artificial intelligent database. One of the main reasons for the same is due to release...

2017-11-13

20 reads

Adaptive Query Processing and Automatic Tuning - Introduction - 1

by Nagaraj Venkatesan

SQL and SQL Only

SQL Server 2017 and Azure SQL Database are being touted as the self learning, artificial intelligent database. One of the...

2017-11-12

544 reads

SQL Azure Databases - Active Secondary - Failover Groups - Part 4

by Nagaraj Venkatesan

SQL and SQL Only

150th Blog Post . So, the post involves video demo :)Previous posts on this series was about using "Geo Replication" to configure active secondary. However, it comes with few...

2017-10-27

9 reads

SQL Azure Databases - Active Secondary - Failover Groups - Part 4

by Nagaraj Venkatesan

SQL and SQL Only

150th Blog Post . So, the post involves video demo 🙂

Previous posts on this series was about using "Geo Replication" to...

2017-10-27

387 reads

Dynamic Threshold for Statistic Update - SQL Server 2016

by Nagaraj Venkatesan

SQL and SQL Only

By default, on a SQL Server Database, statistics are updated automatically when one hits a threshold of changes. If the Auto Update Statistics setting is turned on by default,...

2017-09-06

577 reads

Dynamic Threshold for Statistic Update - SQL Server 2016

by Nagaraj Venkatesan

SQL and SQL Only

By default, on a SQL Server Database, statistics are updated automatically when one hits a threshold of changes. If the...

2017-09-19 (first published: 2017-09-06)

2,069 reads

DBCC CloneDatabase for SQL Server 2012

by Nagaraj Venkatesan

SQL and SQL Only

Dear All,In case you are wondering, title of the post is not a typo 🙂 DBCC CloneDatabase is going to be available for SQL Server 2012 :)For folks who...

2017-09-03

174 reads

DBCC CloneDatabase for SQL Server 2012

by Nagaraj Venkatesan

SQL and SQL Only

Dear All,

In case you are wondering, title of the post is not a typo 🙂 DBCC CloneDatabase is going to be...

2017-09-03

707 reads

Data Channel Interview - 08 - Leila Etaati on Machine Learning using Microsoft BI

by Nagaraj Venkatesan

SQL and SQL Only

Dear All, Very happy to share the 8th interview of #DataChannel. Dr. Leila Etaati MVP, MCT from New Zealand discusses Machine Learning using Microsoft Business Intelligence tools in...

2017-08-28

6 reads

Data Channel Interview - 08 - Leila Etaati on Machine Learning using Microsoft BI

by Nagaraj Venkatesan

SQL and SQL Only

Dear All,

Very happy to share the 8th interview of #DataChannel. Dr. Leila Etaati MVP, MCT from New Zealand discusses...

2017-09-11 (first published: 2017-08-28)

1,633 reads

SQL and SQL Only

Adaptive Query Processing and Automatic Tuning - Introduction - 1

Adaptive Query Processing and Automatic Tuning - Introduction - 1

SQL Azure Databases - Active Secondary - Failover Groups - Part 4

SQL Azure Databases - Active Secondary - Failover Groups - Part 4

Dynamic Threshold for Statistic Update - SQL Server 2016

Dynamic Threshold for Statistic Update - SQL Server 2016

DBCC CloneDatabase for SQL Server 2012

DBCC CloneDatabase for SQL Server 2012

Data Channel Interview - 08 - Leila Etaati on Machine Learning using Microsoft BI

Data Channel Interview - 08 - Leila Etaati on Machine Learning using Microsoft BI

Blogs

ASF 032: Jennifer Stirrup interview

SQL Server Express Size Limit

Daily Coping 2 Jul 2020

Forums

Adding NOT NULL to column with existing rows causes page bloat

Stretch database

Partitioning Heaps

Question of the Day

Partitioning Heaps

SQL and SQL Only

Blogs

Forums

Ask SSC

Question of the Day