SQL Server Professional Development Tips and Tricks

Latest SQL Server Tips

• Capture SQL Server Database Object Changes

  
  
  
  

• PostgreSQL VACUUM, AUTOVACUUM, and ANALYZE Processes for Deleted Data

  
  
  
  

• Audit SQL Server Extended Stored Procedures Usage

  
  
  
  

• SQL Server Data Masking with DbDefence

  
  
  
  

• SQL Server Agent Job History Retention Settings

  
  
  
  

• SQL Server Metadata for Stored Procedures, User-Defined Functions and Views

  
  
  
  

• Predictive Analysis and Descriptive Analysis with Azure Stream Analytics, Machine Learning and Power BI

  
  
  
  

• What is Change Management and the SQL Server DBAs Role

  
  
  
  

SQL Server Tutorials

• SQL Server Backup Tutorial

  
  
  
  

• SQL Server SELECT Tutorial

  
  
  
  

• SQL Server Restore Tutorial

  
  
  
  

• SQL Server Stored Procedure Tutorial

  
  
  
  

• SQL Server INFORMATION SCHEMA Tutorial

  
  
  
  

• SQL Server Integration Services (SSIS) Tutorial

  
  
  
  

• SQL Server Reporting Services Tutorial

  
  
  
  

• SQL Server Performance Monitoring and Tuning Tutorial

  
  
  
  

SQL Server Webcasts

• Things I Wish I Knew as a DBA

  
  
  
  

• Mastering Microsoft SQL Server Licensing on AWS: Cut Costs and Simplify Compliance

  
  
  
  

• Identify SQL Server Performance Problems Quickly and Efficiently

  
  
  
  

• Ensuring High Availability in a Multi-Cloud Environment: Lessons from the CrowdStrike Outage