Resizing Tempdb (When TEMPDB Wont Shrink)
Occasionally, we must resize or realign our Tempdb log file (.ldf) or data files (.mdf or .ndf) due to a growth event that forces the file size out of...
2020-09-09
265 reads
Occasionally, we must resize or realign our Tempdb log file (.ldf) or data files (.mdf or .ndf) due to a growth event that forces the file size out of...
2020-09-09
265 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-09-08 (first published: 2020-08-28)
374 reads
SQL Server 2017 (compatibility 140) brought us many Intelligent Query Processing (IQP), formally known as Adaptive Query Processing, features that improve performance on workloads straight out of the box...
2020-09-02
39 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
32 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)
673 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
22 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)
270 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
371 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
19 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)
920 reads
By Brian Kelley
I wear many hats in technology, and one of those is as a (cyber)security...
By Steve Jones
We keep adding stuff to Redgate Monitor, and it’s easy to miss some of...
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Comments posted to this topic are about the item Azure SQL Hyperscale Unveiled
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
Comments posted to this topic are about the item MiniMax m3 and SQL Server
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers