Change Azure SQL Database Service Level Objectives in SSMS
Sometimes as a DBA, I am lazy and want the ability to execute all of my tasks in one place. Lucky for me I discovered the other day that...
2020-08-28
8 reads
Sometimes as a DBA, I am lazy and want the ability to execute all of my tasks in one place. Lucky for me I discovered the other day that...
2020-08-28
8 reads
Index Maintenance is an important aspect of database health. Above and beyond regular index rebuilds and reorganizations it is important to understand the usage of the indexes on your...
2020-08-24 (first published: 2020-08-12)
651 reads
Index Maintenance is an important aspect of database health. Above and beyond regular index rebuilds and reorganizations it is important to understand the usage of the indexes on your...
2020-08-12
14 reads
As you know, I spoke to 12 Chapter Leaders and 4 Regional Mentors yesterday. All are very upset with PASS right now and feel slighted, which as a volunteer...
2020-07-03 (first published: 2020-06-19)
259 reads
What is Azure SQL Database Serverless? When I hear the term serverless my mind gets confused. How can a database exist without a server? Azure is a cloud platform,...
2020-07-01
350 reads
What is Azure SQL Database Serverless? When I hear the term serverless my mind gets confused. How can a database exist without a server? Azure is a cloud platform,...
2020-07-01
5 reads
Under compatibility level 150, in both SQL Server 2019 and Azure SQL Database, you now can use batch mode for CPU-bound analytic type workloads without requiring columnstore indexes. There...
2020-06-29 (first published: 2020-06-16)
891 reads
On June 3rd PASS announced their annual Summit for Data Professionals was moved to a virtual format. This is not surprising to those of us in the SQL Server...
2020-06-26 (first published: 2020-06-11)
326 reads
As you know, I spoke to 12 Chapter Leaders and 4 Regional Mentors yesterday. All are very upset with PASS right now and feel slighted, which as a volunteer...
2020-06-19
3 reads
Under compatibility level 150, in both SQL Server 2019 and Azure SQL Database, you now can use batch mode for CPU-bound analytic type workloads without requiring columnstore indexes. There...
2020-06-16
47 reads
By Steve Jones
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...
As a data & AI strategist who’s seen countless projects succeed and fail, I...
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
We are planning on a fairly big code deployment to set the stage for...
Experts, I am hoping to get some help and feedback. I have a server...
Comments posted to this topic are about the item Single User SQL Server on...
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers