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

25 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

721 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

223 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

Requesting Comments on the SQLOrlando Operations Manual

Ignoring Comments in SQL Compare

PASS SQLSaturday’s I will be speaking at

Forums

Installing SQL server with DBAtools

Rules in PostgreSQL

Ordering with NULL

Question of the Day

Ordering with NULL

SQL and SQL Only

Blogs

Forums

Ask SSC

Question of the Day