Articles Posted in the " SqlServer " Category

  • My Learning Goals 2018

    My Learning Goals 2018

    I thank Malathi (b|t) for hosting TSQL Tuesday #97. Topic for this month isĀ  “Setting learning goals for 2018″.

    TSQL2SDAY-300x300

    I want to acknowledge that my learning goal will change with time and it happens every year. My first priority is my employer. I need to learn, improve and implement what the company need. Beside that I also want to learn things that are of my personal interest.

    Microsoft Professional Program for Big Data track

    I want to finish what I started in 2017 but did not get enough time to work on. BigDataPorgressMicrosoft Professional …


  • Reading All Available SQL Error logs

    Reading All Available SQL Error logs

    There are many blog posts available online about reading SQL Server Error Log or SQL Server Agent Error Log. What I needed was to search for a string (or string within a string) in all available error logs. Save the results in a table. That way I can find the frequency and pattern of the occurrence. I am also aware that PowerShell commands can read error logs and there are few posts available online for doing that. I did not find one with everything I needed. I wrote 2 versions of this, one as a stored procedure that you can …


  • View Multiple System Health Extended Event Files

    Last week I blogged about increasing retention of System Health session files. In this post I will show how you can open multiple files at once and work with the data as one set.

    If you select multiple System Health extended event files (with extension .xel) and click open each file will open in separate window of SQL Server Management Studio (SSMS).

     

    XEFiles1

    You can see here 4 files opened in 4 different windows. Now you cannot sort, group, apply filter, export data from all 4 windows as one data set.

    XEFiles2

     

    For opening all these files in one window …