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
38 reads
The business critical tier for Azure SQL Database Managed Instance is now available. Customers needing a higher level of high...
2018-12-04
38 reads
As of October 2018, Azure SQL Database Managed Instance is now generally available in the general purpose tier. Business Critical...
2018-10-03
50 reads
I am a little late in posting this, but I still wanted to share. It is a huge honor to...
2018-08-08
352 reads
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
358 reads
This month’s T-SQL Tuesday from Riley Major (b|t) asks us to figure out a way to give back to the...
2018-05-08
399 reads
Azure SQL Database Managed Instance is bridging the gap between 0n-premises SQL Server and Azure SQL Database. Azure SQL Database...
2018-03-31
732 reads
Today is the day that Azure SQL Database Managed Instance is available for the world to explore. Private preview means...
2018-03-06
294 reads
Microsoft will be decommissioning the Connect platform on 12/31/2017 due to privacy concerns and will be replacing it with a...
2017-12-11
437 reads
My latest Pluralsight course – SQL Server: Implementing a Hybrid Cloud Solution in Azure – is well over two hours and long and is based...
2017-12-11
585 reads
At SQLskills, we just launched our new training class on Azure that I will be teaching in Chicago, and my...
2017-04-27
881 reads
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
By Chris Yates
Change is inevitable. What separates thriving organizations from those that falter is not the...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Be Wary of Data
Comments posted to this topic are about the item Locking Hierarchies
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate, o_orderkey, o_custkey, o_storekey FROMdbo.orders WHEREo_orderkey = 3877;