Author: Sachin Diwakar

  • sql server performance tuning and query optimization

    Pinal Dave – SQL Server Performance Tuning Made Easy Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. SQL Server 2016 / 2017 has …

  • sql server agent history cleanup

    SQL Server DBA Interview Questions | How to change SQL server Agent Job history Retention Period In this video you will learn the answer of SQL Server DBA Interview Question “What is by default SQL Server Agent Job history Retention? If you need to keep …

  • sql server internal version numbers

    Database enhancements in SQL Server 2019 In this video, Bob Ward, the Principal PM Architect talks about the database enhancements in SQL Server 2019. Learn more: …

  • sql server performance tuning training

    Pinal Dave – SQL Server Performance Tuning Made Easy Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. SQL Server 2016 / 2017 has …

  • sql server agent history cleanup distribution

    Scheduling SQL Server Jobs with SQL Agent Learn more about Logical Read: http://bit.ly/Logicalread_SQLAgent Discover how to take advantage of SQL Agent to automate many of your routine IT database …

  • sql server internals book

    Inside SQL Server Latches – Bob Ward The SQL Server database engine uses latches for internal synchronization to critical operations. So why would you care about what a latch is? Well, if you have …

  • sql server performance tuning best practices

    Microsoft SQL Server Performance Tuning, Live Brent’s session at Microsoft Ignite 2015 in Chicago. He covers trace flag 4199, columnstore indexes, scaling out to AG secondaries, Cardinality Estimator …

  • sql server agent history table

    SQL Server DBA Tutorial 117-How to Create Job using SQL Server Agent In this video you will learn how to create a job using SQL Server Agent in SQL Server. It shows step by step process of creating the job using SQL Server …

  • sql server interview test

    Top 65 SQL Interview Questions and Answers | SQL Interview Preparation | SQL Training | Edureka MYSQL DBA Certification Training https://www.edureka.co/mysql-dba This Edureka video on Top 65 SQL Interview Question and Answers (SQL Interview …

  • sql server performance tuning scripts

    SQL Server Performance Tuning Made Easy SQL Server Performance Tuning is still a mystery to many. Quite often even an experienced SQL Server DBA, often gets confused as to how to figure out where …

  • sql server agent history

    SQL job history is missing | How to check sql agent job history This video talks about SQL job history is missing How to check sql agent job history job history missing in sql ssis job history missing in sql where sql job agent …

  • sql server interval

    MSSQL – Query to group by time intervals = group by 15 minutes time intervals this simple example will group data by time intervals – in my case 15 minutes More info with ready to copy and paste query …

  • sql server performance tuning tips

    Pinal Dave – SQL Server Performance Tuning Made Easy Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. SQL Server 2016 / 2017 has …

  • sql server agent history retention

    SQL Server DBA Interview Questions | How to change SQL server Agent Job history Retention Period In this video you will learn the answer of SQL Server DBA Interview Question “What is by default SQL Server Agent Job history Retention? If you need to keep …

  • sql server interview questions pdf

    Top 50 SQL Interview Questions and Answers Part 1 Find PDF and PPT at: …