SQL Server DBA, BI Analyst and Microsoft MVP

Posts Archive

Month: August 2023

Back to Archive

SQL Server - How to identify and compress tables and indexes without data compression

August 24, 2023 8 min read

Continue reading

[Live - 23/08] - SQL Server is extremely fast. You just don't know how to use it! | Part 13

August 22, 2023 1 min read

Continue reading

Microsoft certification exams: official practice tests and study materials

August 19, 2023 29 min read

Continue reading

SQL Server - How to identify the date when the trial / evaluation license will expire

August 18, 2023 1 min read

Continue reading

SQL Server - How to create login auditing using instance logs

August 15, 2023 4 min read

Continue reading

Analysis Services - How to monitor the progress of cube processing by SQL Server

August 14, 2023 24 min read

Continue reading

SQL Server - How to reset and recover the SSIS catalog password (SQL Server master key)

August 14, 2023 2 min read

Continue reading

SQL Server - How to generate a script with all database indexes

August 14, 2023 8 min read

Continue reading

SQL Server and Azure SQL - How to Create a Calendar Table Using SQL Including Holidays

August 11, 2023 21 min read

Continue reading

SQL Server and Azure SQL - Challenge for Grouping Data Using Hierarchies

August 11, 2023 4 min read

Continue reading

[Live - 02/08] - Azure Architect Journey: the AZ-305 exam in detail! | 1st edition

August 3, 2023 1 min read

Continue reading