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
21 reads
SQLEspresso
Adaptive Joins in SQL Server
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-10 (first published: 2020-09-02)
1,598 reads
Adaptive Joins in SQL Server
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
18 reads
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-09-08 (first published: 2020-08-28)
327 reads
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
6 reads
Caution When Dropping Unused Indexes on an Azure SQL Database
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)
642 reads
Caution When Dropping Unused Indexes on an Azure SQL Database
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
12 reads
What is Azure SQL Database Serverless?
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
346 reads
What is Azure SQL Database Serverless?
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
4 reads
Open Letter to PASS
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
Blogs
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Monday Monitor Tips: CIS Compliant
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
Forums
sqlbackups through veeam not updating msdb tables
We have veeam backups happening everyday on a server where all sql databases are...
Testing whether TRY_CONVERT is losing precision
Hello All, I am using TRY_CONVERT to parse character data into a decimal column....
need help with assigning a value to a variable
Hi I am trying to assign the value of the variable using the output...
Question of the Day
The Reindeer Count
How many reindeer does Santa have pulling his sleigh? (according to the famous song) Hint, the answers are not base 10.
See possible answers