Blogs

/Blogs

Script: Find The Fragmented Indexes In A Database

We do create indexes to improve the search performance of our queries. But over a period of time, because of DML operations (inserts/deletes/updates), the data will get spread across the disc (Physical order of pages [...]

By |July 2nd, 2020|Categories: Scripts, SQL Server|Comments Off on Script: Find The Fragmented Indexes In A Database

Script: Find Tables Without Clustered Index

Before we start fine tuning SQL Server, it is good to make sure all basic best practices are in place. One such best practice is to have a clustered index on every table in the [...]

By |July 2nd, 2020|Categories: Scripts, SQL Server|Comments Off on Script: Find Tables Without Clustered Index

Faster INSERTs in Tempdb – Optimized/Minimal Tempdb Logging

Faster INSERTs in Tempdb – Optimized/Minimal Tempdb Logging In this blog post, we will see how SQL Server optimises Tempdb logging for faster CRUD operations. For the purpose of this tutorial, we will perform the [...]

By |July 2nd, 2020|Categories: SQL Server|Comments Off on Faster INSERTs in Tempdb – Optimized/Minimal Tempdb Logging

SARGABILITY, CAST, CONVERT & More…

The phrase Sargability is quite popular in SQL Server world. Wikipedia says: “In relational databases, a condition (or predicate) in a query is said to be sargable if the DBMS engine can take advantage of [...]

By |July 2nd, 2020|Categories: SQL Server|Comments Off on SARGABILITY, CAST, CONVERT & More…

DPG Bulletin: June 30, 2020

Fresh SQL Content Sargability, CAST, CONVERT & More Faster INSERTs in Tempdb (Minimal/Optimized Tempdb Logging) Intro - SQL Server Transparent Data Encryption and Extensible Key Management Using Azure Key Vault Latest News from Microsoft Azure [...]

By |June 30th, 2020|Categories: DPG Bulletin|Comments Off on DPG Bulletin: June 30, 2020

Recorded Webinar: Bridging the gap between SSRS and Power BI

Hello Friends, Here is a popular webinar from our recordings: Bridging the gap between SSRS and Power BI Bridging the gap between SSRS and Power BI Speaker: Manohar Punna (Data Platform MVP, Australia) [...]

By |June 30th, 2020|Categories: Webinars|Comments Off on Recorded Webinar: Bridging the gap between SSRS and Power BI