SQL Server Developer Tips and Tricks

Latest SQL Server Tips

• 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

  
  
  
  

• Easy and Cost Effective way to Encrypt Every SQL Server Database

  
  
  
  

• Implement Azure Database for MySQL Step-by-Step

  
  
  
  

• Uncover SQL Server Missing Indexes

  
  
  
  

• Azure Managed Instance Download and Restore SQL Server Backup

  
  
  
  

SQL Server Tutorials

• SQL Server SELECT Tutorial

  
  
  
  

• SQL Server Stored Procedure Tutorial

  
  
  
  

• SQL Server INSERT Tutorial

  
  
  
  

• Visual Studio 2010 and SQL Server Tutorial

  
  
  
  

• SQL Server Database Development Tutorial

  
  
  
  

• SQL Server Data Tools (SSDT) SQL Project Tutorial

  
  
  
  

• SQL Server Regex Tutorial

  
  
  
  

• SQL Server Window Functions Tutorial

  
  
  
  

SQL Server Webcasts

• Things I Wish I Knew as a DBA

  
  
  
  

• Identify SQL Server Performance Problems Quickly and Efficiently

  
  
  
  

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

  
  
  
  

• Optimizing SQL Server Backups on AWS: Best Practices and Cost-Efficient Strategies