Quite a significant change has taken place within the Azure SQL Database space, more specifically the development of Azure SQL Database Serverless. Currently in preview mode this “compute” tier changes...
2019-05-14
328 reads
Before writing about pausing (and resuming) Azure SQL Data Warehouse (DW) it makes sense to discuss the architecture of this product. At a high level it involves a control...
2019-05-07
112 reads
A quick 2 minute upload (with sound, my voice) showing you how easy it is to create an Azure SQL Database using the Azure portal and then using SSMS...
2019-04-23
40 reads
There are a few ways to scale a SQL elastic pool. For this blog post I show you how to scale up. It can be done via the Azure...
2019-04-15
61 reads
The below image is a beautiful picture, now it could be worse. The red line and the green line could peak at the same time and for a very...
2019-04-11
157 reads
Yes, a really nice new shiny feature where we have the ability to suspend and resume the encryption scan for TDE – Transparent Data Encryption which is available in...
2019-04-02
160 reads
There is a new way to setup Azure elastic jobs to run against a target group of databases (targeting an elastic pool). I actually found the process quite messy...
2019-03-27
21 reads
Do you want to identify the correct Service Tier and Compute Size ( was once known as performance level) for your...
2019-03-20
663 reads
Another re-post of a video from last year, this time showing you an in-built protection of setting max server memory...
2019-03-14
487 reads
A quick video clip showing how to create a deadlock in SQL Server and find information about it.
2019-03-13
1,118 reads
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Comments posted to this topic are about the item The Long Name
Comments posted to this topic are about the item Eight Minutes
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?