Understanding Database Fundamentals (98-364)
Kind of proud about this accomplishment. I get asked all the time at user groups and SQL Saturday events, “How can I get started with SQL Server”. There is...
2019-10-30
29 reads
Tim Radney
MVP for Another Year
I am honored and humbled to be awarded the Microsoft Most Valuable Professional award for the Data Platform category. This is my 6th award, and I am just as...
2019-07-30
5 reads
SQL Saturday Louisville
Are you coming to town for SQL Saturday 883 in Louisville KY, if you are going to be around the area on August 2nd, I’ll be presenting an all...
2019-06-04
42 reads
SQL Saturday Baton Rouge
Hello Baton Rouge! David Pless and I will be teaching an all day workshop on Performance Tuning and Optimization for Modern Workloads (SQL Server 2017, Azure SQL Database, and...
2019-06-03
31 reads
Query Store for Azure PostgreSQL
Query Store is not just for Microsoft SQL Server and Azure SQL Database anymore. Microsoft announced back in Oct 2018...
2019-03-12
34 reads
I’m a Friend of Redgate for Another Year!
I am very proud and happy to be a Friend of Redgate for a ninth year! I had to ask Redgate when...
2019-01-26
199 reads
New vCore Compute Levels for Azure SQL Database and Elastic Pools
Additional vCore-based elastic pools and single databases have been expanded for the general purpose, business critical, and hyperscale service tiers....
2019-01-10
49 reads
Azure SQL Database Managed Instance Business Critical Tier Now Available
The business critical tier for Azure SQL Database Managed Instance is now available. Customers needing a higher level of high...
2018-12-04
21 reads
Azure SQL Database Managed Instance
As of October 2018, Azure SQL Database Managed Instance is now generally available in the general purpose tier. Business Critical...
2018-10-03
34 reads
Azure Training in London
I am very excited about my upcoming IEAzure class being held in London, September 10th and 11th at the Marriott in Kensington (London).
This...
2018-08-08
347 reads
Blogs
Actual Difference Between EXISTS(SELECT 1 …), EXISTS(SELECT * …), and EXISTS(SELECT column …)
Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than...
ANSI_WARNINGS = OFF can break update statements with some SQL features
By Will Assaf
Working on a SQL 2017 database where an external, non-Microsoft application has direct access...
Bring Your Own Key to Azure SQL Database Managed Instance TDE
Last year Azure SQL Database Managed Instance saw the introduction of bring your own...
Forums
How to update status with conflict data where chemical temp table have same chem
How to update status with conflict data where chemical temp table have same chemical...
Blob to ADF to Stored proecure
I'm reading file from BLOB through ADF and I would like to pass the...
RTO 15 minutes with differential backups
Hi. I'm working through the official exam reference book for 70-764 by Isakov and...
Ask SSC