SQL Server DBA, BI Analyst and Microsoft MVP

Posts Archive

Month: February 2019

Back to Archive

SQL Server - When You Should Use ORDER BY in Queries and When You Should Never Use It

February 24, 2019 5 min read

Continue reading

SQL Server - Understanding the Risks of the TRUSTWORTHY Property Enabled in a Database

February 24, 2019 7 min read

Continue reading

SQL Server - How to avoid SQL Injection? Stop using Dynamic Query with EXEC(@Query). Now.

February 24, 2019 16 min read

Continue reading

[Live] - Power BI Service vs Power BI Report Server - 02/27/2019 at 8:30 PM

February 22, 2019 1 min read

Continue reading

SQL Server - How to identify and collect information from slow queries using Extended Events (XE)

February 19, 2019 11 min read

Continue reading

SQL Server - Using Calculated or Computed Columns for Performance Tuning

February 13, 2019 8 min read

Continue reading

SQL Server - How to avoid and protect yourself from Ransomware attacks, like WannaCry, on your database server

February 12, 2019 10 min read

Continue reading

VMware Player - Using the Independent Nonpersistent Disk Mode

February 11, 2019 2 min read

Continue reading

SQL Server - How to avoid brute force attacks on your database

February 11, 2019 21 min read

Continue reading

SQL Server Performance Tuning Tips - What Is the Difference Between Seek Predicate and Predicate?

February 8, 2019 1 min read

Continue reading

[FREE and ONLINE Event] - 02/07/2019 at 8:00pm - Data Architecture and Governance in BI Projects with Power BI

February 6, 2019 1 min read

Continue reading

SQL Server Performance Tuning Tips - Implicit Conversion: Never Again

February 3, 2019 13 min read

Continue reading