What is Automatic Tuning in Azure SQL Database
Microsoft has long given us DBA tools and suggestions to help tune databases, to fix queries with indexes, and many...
2018-08-28
486 reads
Microsoft has long given us DBA tools and suggestions to help tune databases, to fix queries with indexes, and many...
2018-08-28
486 reads
Microsoft gives you two purchasing models for your Azure SQL Databases (SQL DB), a DTU and a vCore based model...
2018-09-05 (first published: 2018-08-22)
2,237 reads
Starting in SQL Server 2012 and in Azure SQL Database, Microsoft introduced the concept of a contained database. A contained...
2018-07-11 (first published: 2018-07-05)
2,912 reads
July 1st is a day all Microsoft Most Valuable Professionals (MVP) wait patiently at their computers hitting F5 over and...
2018-07-02
316 reads
Ever seen the below error? Until this week I hadn’t. So, I figured I’d take a little time and introduce...
2018-06-28 (first published: 2018-06-20)
7,909 reads
I typically don’t write opinion posts, but given recent events I thought it was important to follow up on one of my tweets....
2018-06-29 (first published: 2018-06-14)
2,256 reads
A few weeks ago, I wrote Part 1, 2 and 3 of this series, which was a beginner’s guide to Always Encrypted. In part...
2018-06-25 (first published: 2018-06-13)
2,559 reads
Following up on my last post about the Cardinality Estimator let’s talk about column statistics and how they work and...
2018-05-30
572 reads
Sometimes people speak “SQL” and expect you know all the terminology. In recent a conversation about query plans I was...
2018-05-24
624 reads
In SQL Server the query optimizer uses a cardinality estimator to answer data SELECTIVITY questions like the ones below. The...
2018-05-02
344 reads
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
Comments posted to this topic are about the item The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers