THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Damian Widera

  • SQL Server 2014 Service Pack 2 Cumulative Update #2 Released!

    The 2nd cumulative update release for SQL Server 2014 SP2 is now available for download at the Microsoft Downloads site.

    Good thing is that registration is no longer required to download Cumulative updates.


    VSTS bug number KB article number Description Fix area
    8147939 3191487 Query performance improvement for some columnstore queries in SQL Server 2014
    8055445 3184099 SQL Server 2012 crashes with an access violation when you use the TRY…CATCH construct for bulk copy SQL service
    8001813 3189229 FIX: "Element not found" error occurs when you browse to the FileTable database directory in SQL Server 2012 or 2016 SQL service
    8198005 3171681 Reporting Services counter is missing from Windows Performance Monitor after you install SQL Server 2014 SP1 CU6 Reporting Services
    8343827 3180060 FIX: Queries that use CHANGETABLE use much more CPU after you install SQL Server 2014 SP1 CU6 SQL service
    8198037 3181260 SQL Server Analysis Services crashes when you have multiple roles and run a CREATE SESSION CUBE statement in SQL Server 2014 Analysis Services
    8197973 3161403 The file size of the PDF file generated by SSRS 2014 or 2016 is larger when compared to the earlier versions of SQL Server Reporting Services
    8204790 3195825 FIX: A deadlock occurs when you execute a query plan that has a nested loop join between two hash joins working in the batch mode in SQL Server 2014 SQL performance
    8197979 3164104 Unable to run DBCC CHECKDB when the database files reside in Azure Premium Storage in SQL Server 2014 SQL service
    8197999 3168740 An access violation occurs when you execute two parent packages that run the same child package in parallel in SQL Server 2014 or 2016 Integration Services
    8275510 3189033 FIX: Cannot uninstall service packs for SQL Server 2014 after a cumulative update is installed Setup & Install
    8198023 3025408 FIX: Access violation occurs when you run and then cancel a query on distinct count partitions in SSAS Analysis Services
    8198033 3180263 FIX: Canceling a query takes a long time in a Tabular instance of SQL Server 2014 Analysis Services Analysis Services
    8198040 3174370 A memory leak occurs when you use Azure Storage in SQL Server 2014 or 2016 SQL service
    8292291 3189645 FIX: Access violation when you run a query that uses clustered columnstore index with trace flag 2389, 2390, or 4139
    8198029 3176993 FIX: The "MSRS 2014 Windows Service: Active Session" counter incorrectly displays a very high value for SSRS 2014 or 2016 Reporting Services
    8273664 3194961 db_name() and db_id() functions fail to trigger permissions check in SQL Server

    To learn more visit pages:




  • What you should read :) during the upcoming !!! weekend - weekly SQL Server blogs review part 15

    Welcome back! I have found some great articles to be read

    Hope you will have a lot of fun reading all of them.





    Rob Farley

    Passwords – a secret you have no right to share

    Paul White

    The sorts that spills to level 15000

    Rob Farley

    Implementing a custom sort

    Arun Sirpal

    The dark side of Fn_dump_dblog

    Grant Fritchey

    SELECT * Does Not Hurt Performance




  • SQL 2016 RTM is out

    Following is the summary of all the links to acquire SQL 2016 RTM.

    The links come from Parikshit Savjani (Microsoft) so all credits to him :)


    Azure Link -

    MSDN Subscribers -

    MSDN Technet -

    Technet/MSDN Evaluation -

    MSDN Evaluation – Express -

    Microsoft Command Line Utilities 13 for SQL Server -

    Microsoft SQL Server 2016 Feature pack –

    Microsoft SQL Server 2016 PowerPivot for SharPoint 2013 -

    Microsoft SQL Server 2016 PowerPivot for SharePoint 2016 -

    Microsoft SQL Server 2016 RS add-in for SharePoint –

    Microsoft SQL Server 2016 MDS Add-in –

    Microsoft SQL Server 2016 Report Builder -

    Microsoft SQL Server 2016 Semantic –

    (SSEI) Microsoft SQL Server 2016 Express

    (SSEI – SQL Server Installer is a new friction-free experience to perform direct installations or download the setup media for SQL Express editions. More details on this coming soon)




  • What you should read :) during the upcoming !!! weekend - weekly SQL Server blogs review part 14

    Today I have really something extraordinary. We have been waiting so long to have a comprehensive wait statistics and latches description. And now we have them! Paul Randal prepared and posted a great source of information. This is a must read! By the way – Paul have had really a great week posting so much great stuff!

    Hope you will have a lot of fun reading all of them.





    Paul Randal

    SQL Server Wait Statistics Library

    Paul Randal

    SQL Server Latch Classes Library

    Paul Randal

    Reconciling set-based operations with row-by-row iterative processing

    Paul Randal

    Code to analyze the transaction hierarchy in the log

    Paul Randal

    Updated sys.dm_os_waiting_tasks script to add query DOP





  • What you should read :) during the upcoming !!! weekend - weekly SQL Server blogs review part 13

    It was long time ago I posted a blog from this series. That was also due to SQLDay conference preparation.  

    I have found a very interesting series posted by Aaron Bertrand (who will be one of the stars during this conference). I strongly advice to take some time and read these articles. And those are only the newest ones!

    Hope you will have a lot of fun reading all of them.





    Aaron Bertrand

    STRING_SPLIT() in SQL Server 2016 : Follow-Up #1

    Aaron Bertrand

    STRING_SPLIT() in SQL Server 2016 : Follow-Up #2

    Aaron Bertrand

    Performance Surprises and Assumptions : DATEADD

    Aaron Bertrand

    Performance Surprises and Assumptions : STRING_SPLIT()

    Aaron Bertrand

    Instant File Initialization : Impact During Setup




  • Stellar SQL Database Toolkit - review no 2

    Hello SQL Folks.

    Being a MVP gives me the chance to freely use and test some fancy tools and this time I would like to share my thoughts about one of such.  Today I would like to bring your attention to the Stellar SQL Database Toolkit.

    What is Stellar SQL Database Toolkit

    The tool is able to help you in three types of problems:

    ·         Password recovery

    ·         Backup recovery

    ·         Database repair


    There is a good explanation in what business scenarios the toolkit is really helpful so I strongly recommend you to visit the page:


    Let’s run the program then. The initial screen looks like on the picture below.  You can pick one of the three mentioned options:



    I started with the SQL Password Recovery as this particular option was the most interesting to me. The idea behind that is if you accidentally lost a password (could be sa password or any user password) than you would be able to change it. 



    I have prepared a login (Login4Recovery) that I am going to check. I stopped my SQL Server instance and copied the master data file into other location.



    As you can see the list of all logins is displayed. I selected the “Login4Recovery” and pressed the Change Password button. I typed a new password and that is all!







    I moved the master data file to its previous location and restarted SQL Server. I tested if the operation was really successful by using the new password to my Login4Recovery login. Everything went fine. But – you should ask yourself a question in what circumstances this operation should ever be done.

    The second option I have tested was Database Repair.  I took a sample database that has a corruption that prevents me from attaching it to the server:



    I opened the tool and the first information is as follow:



    That makes sense as it is hard to perform any operations on database files if those are under the control of the database engine. The only way is to take the data file or files away from the SQL Server.

    The next step is to select the data files. There are two possible ways to do so as you can see on the picture below:

    -          You can point in to the database

    -          You can search for it




    When you try to use the “Search in Folder” option that you have to

    ·         specify the location (“Look in” field)

    ·         select the file type

    ·         optionally select the “Search in Subfolders” checkbox

    The search operation is started when you press “Find” button. As you can see on the screen there are 28 primary data files found on my laptop. That does not mean all of them are corrupted. The tool finds all data files and it is up to you to check if they are corrupted or not. This step is just for selecting a file to be examined.




    What is really worth to notice is the last checkbox “Include Deleted Records”.  Checking this options allows the tool to search for deleted records and possibly to recover them. I have selected the option before going to the next step.




    I started with the first option (“Select Database”) and clicked the “Repair” button.

    Now the application started to work out and after a while I was informed that it is possible to repair my database. The applicaton presented the short report of all actions it had taken. 



    It is possible to take a look at the database, examine all objects and even to see the data. You can even see that for the table HumanResources.Employee two entities are displayed:

    ·         HumanResources.Employee

    ·         HumanResources.Employee (delete)

    That means that for this particular table it is possible to recover the deleted records.

    At this point it is possible to repair and save the database (means also to attach) to the given instance of SQL Server. Remember that you can pick (by selecting the checkboxes) only these objects you really need to be saved.

    To do it you have to press “Save” button from the ribbon:



    You can then decide how the repaired database be saved. There are 4 options to choose:

    ·         MSSQL file

    ·         CSV

    ·         HTML

    ·         XLS




    I have selected “MSSQL”. Now I had to choose how the database is saved:

    ·         New database

    ·         Live database


    New database means that the restored file will be created on the given server. In that case you need to specify the server and instance name (or better – to select them from the list) . Then you need to decide where the data file is located – that could be the default location for the instance or new one.



    After you press “Connect” the database is going to be created on the server and data are copied:



    And the magic happened J The database is up and running!




    Are you interested how the Live database option works? You have to specify the server name and an existing database. The recovered data will be saved to the database




    I was also wondering how other save options work. For example the option to save data to the CSV file:



    I configured the file location to be stored on my local drive and after clicking “OK” the fileswere created. You will notice that under the AdventureWorks_Data folder a new folder is created. It will be created each time you perform the save operation



    There are a lot of files in this directory – one file for each object like a table or a view:



    I opened one of the file just to check if it is properly formatted:



    Now I can see that the tool can be also used to easily export data in some particular cases!

    Let’s go back to the application once again. The very last thing to mention are the other options that are available in this Database Repair tool:



    There are a lot of options on the top menu, but please check the one described as KB – clicking on this option will open a new browser window and you will be moved to Stellar Phoenix Knowledge Base.  You can also register your product, purchase new ones or for example update it:



    Take a look also on the “Find Tree Item” search. That will search through all objects so you can very quickly navigate to them. The “Match case” and “Match whole word” check boxes are very intuitive and most of us are familiar with these options form other tools so I so not spend time describing them.


    The third functionality offered by the Stellar SQL Database Toolkit is the SQL Backup Recovery. As you can see the options are very similar to the previously described SQL Database Recovery.

    There are two options of searching for a database backup:

    a)       Selecting a file

    b)      Searching in a directory

    I have already described both options. I have selected a damaged database backup file and tried to fix it



    Then you have to pick a backup from all that exist in the file. In my case it was just one backup in the backup file but it is nothing strange to see more then one. I will not deliberate about backups in this post but I assume you know which one has to be restored first.



    After I had pressed the “Next” button I saw an information that the backup can be fixed by the tool:



    There is a chance to review the  objects and data that exist in the backup file. You can take a look on the tables, views and other objects and see the data or the object’s definition. You can pick only the needed objects to be restored by checking the checkboxes on the left side of the objects:





    At this point you have to decide what to do with the recovered file. There are options to save it to a database (for example as a new one or to overwrite the existing one) or to other types of files.



    I started with restoring the backup as a new database on one of my instances. The idea is exactly the same as previously when I was describing the data file fixing. Simply fill the necessary fields:

    a)       Server \ instance name

    b)      File location




    Now press the “Connect” button and the restoring process is taking place. If everything is fine you should see a confirmation message at the end of the process and the database is restored.



    As you see the database is now present in my instance.



    I have also tried to save the objects to the CSV file. This is one of the options you can select before the file is saved.



    The file was created exactly as I expected




    I like the tool. It is  very intuitive and does not ask to many questions. It definitely be a helpful in many cases for bot experienced and novice DBA’s. What I would really like to have in the tool in the future would be the possibility to have more description in the log file of the operation that are in progress. I know that this could be a very technical description but I think people would like it. I would!


  • What's New in SQL Server 2016 Release Candidate (RC0)

    Hello SQL folks! Are you still excited that SQL Server will be available on Linux soon?

    Now, as you probably know the SQL Server 2016 RC0 is now public so everybody can play with it now!

    You can download the version here

    You can also go and log into the Microsoft Azure and play with the SQL Server there - the VM is ready waiting for you!

    Please read what's new in the product since the first CTP here

    If you are interested what has changed since we have had version CTP 3.3 - here you are the release notes

    Stay in touch and if by any chance you are in Prague this week - I will be there! There is a MVP Open Days conference and I will be talking about the execution plans.  Drop me a note here or on twitter (@damianwidera) and we could talk about the SQL Server (but not only ;)) drinking the best Czech beers! 



  • My presentation and codes from SQLUG.SE users group meeting

    Hello SQL Folks

    I have spend the whole day in Stockholm doing presentation about SQL Server 2016 features:  QueryStore and StertchDb.

    Thanks to Johan Ahlen and Steinar Andersen I was able to be there. Thank you guys once again. It was also a chance for me to meet one of my SQLServer heroes - Erland Sommarskog. I made it! 

    It is always a great fun and big opportunity to meet people from other countries and discuss! Especially the discussion during the coffee break were very, very constructive!


    If you are interested in my presentation and code you can find it here






  • Technical Overview: SQL Server 2016 Community Technology Preview 3.3

    Hi Sql Folks!

    Accoring to the TechNet site (check here for more deatils) we can play with SQL Server CTP 3.3 now! 


    Here is what has changed or was updatec / fixed 

    New Stretch Database improvements in CTP 3.3 include:

    • Support to enable TDE on a remote DB if the local database has TDE enabled
    • Azure Stretch database edition preview with support for up to 60TB
    • Alter and drop index support for stretch tables
    • Add, alter and drop columns support for stretch tables
    • Point-in-time restore and geo-failover support
    • Query performance improvement

    SQL Server Management Studio improvements in this release include:

    • Additional Wizard features:
      • Added new SQL db credential management functionality
      • Integrated Table validation and selection updates to prevent stretch of unsupported datatypes at selection time
      • Table search functionality for table select page
      • Table selection column reordering
      • Support for temporal tables during table select
      • Integrated Azure sign in and SQL sign in credential
      • Add support for stretching using federated accounts
      • New firewall configuration and subnet detection functionality
      • Updated summary page details with pricing information
      • Improved SSMS visualization with StretchDB icons
    • Object Explorer:
      • Fly out menu updates to support disable and un-migration functionality
      • Un-migrate support functionality at database and table level

    Read the SSMS blog post to learn more.

    CTP3.3 adds support with In-Memory OLTP for:

    • Automatic update of statistics on memory-optimized tables: The statistics for memory-optimized tables are now updated automatically, removing the need for running maintenance tasks that update statistics manually.
    • Sampled statistics for memory-optimized tables: Sampling of statistics for the data in memory-optimized tables is now supported, alongside the previously supported fullscan statistics. This reduces the time it takes to collect statistics for large tables.
    • Use of LOB types varchar(max), nvarchar(max), and varbinary(max) with built-in string functions (‘+’, len, ltrim, rtrim and substring) in natively compiled modules, and as return type of natively compiled scalar UDFs.
    • Memory-optimized tables with row size > 8060 bytes, using non-LOB types. CTPs 3.1 and 3.2 supported larger rows using LOB types; as of CTP3.3, memory-optimized tables support also larger rows using types varchar(n), nvarchar(n) and varbinary(n). See below for an example.
    • The OUTPUT clause can now be used with INSERT, UPDATE and DELETE statements in natively compiled stored procedures.

    Autostats improvements in CTP 3.3

    Previously, statistics were automatically recalculated when the change exceeded a fixed threshold. As of CTP 3.3, we have refined the algorithm such that it is no longer a fixed threshold, but in general will be more aggressive in triggering statistics scans, resulting in more accurate query plans.

    Foreign Key Support enhancements in CTP 3.3

    SQL Server 2014 and earlier versions have limitations on the number of FOREIGN KEY references a table can contain, as well as the maximum number on incoming foreign key REFERENCES. The documented recommended maximum is 253, and when performing DML on tables with large numbers of incoming REFERENCES, statements time out with stack overflow error messages.

    This improvement increases the number of supported incoming foreign key REFERENCES to a table, while maintaining good performance for DML operations in both the referencing and the referenced table. The new maximum is 10,000. However, with the CTP 3.3 release, we have certain limitations on this feature:

    • We ONLY support Delete DML operation on foreign key references that go beyond the current recommended maximum of 253. Therefore, we will validate that no referencing rows exist before deletion.
    • Update and Merge operations are not supported with this release. Update will be available in RTM.
    • You will not see any change in behavior for cascading actions.
    • This is not available in ColumnStore, Hekaton or StretchDB.
    • This change is not applicable to a primary key table that is self-referencing (that is, if the table has a foreign key to itself). In this case, the behavior would remain the same as before.
    • This is not supported for partitioned foreign key tables for CTP 3.3. However, partitioned tables will be supported in RTM.

    SQL Server Analysis Services (SSAS) includes multiple additions in this release. Read the SSAS CTP 3.3 blog post to learn more.

    SQL Server Reporting Services (SSRS) includes an updated preview of its brand-new web portal with additional functionality:

    • Add the KPIs and reports that matter most to you to your Favorites and view them all in one place.
    • Manage shared data sources for your KPIs and reports and perform other management tasks.

    Read the SSRS blog post to learn more.

    Master Data Services (MDS) improvements in this release include:

    • Business rule changes
      • New, easier-to-use web UI administration page
      • Support for NOT conditional operator
      • Support for ELSE section that contains a set of actions to execute if the IF condition is false
      • Removed management UI from Excel add-in
    • Added support for purging (hard-deleting soft-deleted members) of an entity version
    • Added to the web explorer page a button to open the current entity view in the Excel add-in


    Happy playing!


  • What you should have read :) during the weekend - weekly SQL Server blogs review part 12

    Hello! Happy New Year to you all! I was really busy at the end of the last

    year because I was trying to close all opened projects. Which was not

    possible and now I know this!

    I am coming back to you with a list of posts that are a must to read !!!

    Hope you will have a lot of fun reading all of them.





    Jack Li

    What to do when you run out of disk space for In-Memory OLTP checkpoint files | CSS SQL Server Engineers

    Klaus Aschenbrenner

    How to pollute your Plan Cache with parameterized SQL statements

    Adam Machanic

    SQLQueryStress: The Source Code

    Mark Broadbent

    Problem removing files from TempDB

    Joe Celko

    Declarative SQL: Using References

    Michael Sorens

    Documenting Your PowerShell Binary Cmdlets




  • What you should have read :) during the weekend - weekly SQL Server blogs review part 11

    Hello! It is Tuesday already. I hope you had great last week especially we

    have Christmas this week J. Maybe you will find some time to read the

    great posts I prepared? Hope you will have a lot of fun reading all of them.





    Solomon Rudzky

    Stairway to SQLCLR Level 1: What is SQLCLR? - SQLServerCentral

    Louis Davidsson

    What Counts For a DBA

    Merrill Aldrich

    Automate ETL Testing: Cross-Server Data Comparison with PowerShell

    Gail Shaw

    When naming transactions causes an error

    Paul White

    Temporary Tables in Stored Procedures

    MSSQL Tips

    Demystify TempDB Performance and Manageability





  • What you should have read :) during the weekend - weekly SQL Server blogs review part 10

    Hello! It is Tuesday already but last week I found a lot of great resources.

    Hope you will have a lot of fun reading all of them! 





    Nick Burns

    Combining R and SQL Server to diagnose performance bottlenecks

    Glenn Berry

    Introduction to Storage Spaces Direct for SQL Server

    SQL Server Database Engine Team

    Built-in functions for compression/decompression in SQL Server 2016

    Greg Low

    My Sessions from Ignite Australia on the Gold Coast now online

    Rob Farley

    A new superpower for SQL query tuners – Number of Rows Read




  • Review of LepideAuditor Suite for SQL Server

    Being a MVP gives me the chance to freely use and test some fancy tools and this time I would like to share my thoughts about one of such.  

    SQL Server Auditing is an important procedure to know the answers to questions such as who made a particular change, when, and from where was this change made. Unidentified changes can influence the whole IT environment, especially when other crucial servers are interconnected with SQL Server.

    LepideAuditor Suite audits every aspect of SQL Server. It provides a common platform to audit the server components such as Active Directory, Group Policy Objects, Exchange Server, SharePoint, and SQL Server. You can simultaneously audit multiple instances of any server component.

    System Requirements

    You can audit SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, and SQL Server 2014 using this software. The minimum system requirements to install this Lepide product are listed herein below.

    ·         Dual Core or higher Processor

    ·         Minimum 4 GB RAM

    ·         Free space on hard disk

    o   Minimum 1 GB

    o   Recommended 2 GB

    ·         Any of the following 32 bit or 64 bit Windows Operating Systems.

    o   Windows XP

    o   Windows 7

    o   Windows 8

    o   Windows 8.1

    o   Windows Server 2003

    o   Windows Server 2003 R2

    o   Windows Server 2008

    o   Windows Server 2008 R2

    o   Windows Server 2012

    o   Windows Server 2012 R2

    ·         .NET Framework 4.0 or later


    You can save the auditing logs to the same or different SQL Server. The following prerequisite software should be installed on the machine where SQL Server is installed.

    ·         Microsoft System CLR Types for SQL Server 2012

    ·         Microsoft SQL Server 2012 Management Objects Setup

    ·         .NET Framework 4.0


    The installation of LepideAuditor Suite is easy and quick. You just have to download the setup file, execute it, and follow the onscreen steps. The setup files of Web Console and App Server comes with the downloaded zip file. You can install the Web Console to access the audit reports from anywhere in the network using a browser.

    LepideAuditor Suite sends real-time notifications in LepideAuditor App on your Android or Apple device through the default Lepide App Server. If you want to set up a custom App Server to send the notifications to App, then its installer file is available in the downloaded setup.

    Configuring the Software

    Once installed, you have to add the SQL Server that has to be audited. Before adding, please make sure to install the above prerequisite on the server machine. At the welcome screen, you have to provide the login credentials of the local system or domain administrator to run the software service.

    Welcome Screen of LepideAuditor Suite


    You can select an administrative user account and provide its password to run this service. Once configured the following dialog box will appear, where you have to select the component to be audited.

    Component Selection

    You have to select “SQL Server” and click “OK”. The following wizard will appear.

    Wizard to add a SQL Server option

    Two options are available here – Express Configuration and Advanced Configuration. The former is the way to add SQL Server with minimum configuration, where the latter lets you configure every aspect of SQL Server auditing. Click “Next” to start adding the SQL Server.

    Details of SQL Server

    Enter the details of SQL Server. You can also click “Browse” button to select the SQL Server. Click “Test Connection” button to test the connection to the target SQL Server. You can select whether to add server with agent or without agent. An agent will be installed on the machine where SQL Server is installed in agent-based auditing, whereas no agent will be installed if you select “Without Agent” for agentless auditing. Click “Next” once you are done. The next step lets you configure the health monitoring of SQL Server.

    Health Monitoring Settings

    You have to provide the name or IP Address and login credentials of the administrator of the computer where SQL Server is installed. Click “Next”.

    Audit Settings

    Here, you have to select what you want to audit from the following options.

    1.       Audit Everything: Everything on SQL Server will be audited.

    2.       Audit Server: Only the server except its databases will be audited.

    3.       Audit Server with selected objects: Server with the selected databases will be audited. The available databases will be listed when you will select this option. You can select the databases to be audited.

    Audit Server objects with the selected databases

    Once you have configured what to audit, you can click “Next”.

    Object Settings

    Here, you can select the desired server and database objects along with their operations to be audited. You can check the objects that has to be audited. Uncheck the others to exclude them from auditing. Click the operation cell for an object to select the object operations to be audited.

    Operations of an object

    You can check the objects that have to be monitored. Uncheck to exclude them from auditing. Once you have selected the objects and their operations to be audited, you can click “Next”.

    User Settings

    The available options are – All Users and Selected Users. You can select the latter to select the users to be audited.

    Once you have made your selection, click “Next” to proceed. The database settings appear onscreen.

    Database Settings

    You have to provide the SQL Server details and create a new database or select an existing database to store the auditing logs. There are small buttons to save the SQL Server as default for Auditor Suite or load the settings from an already saved default SQL Server.

    Click “Next” to proceed. The next steps lets you enable the archiving of logs and schedule the archiving.

    Archive Settings

    Enter the SQL Server details, select a database, and configure the schedule. The software will automatically archive the logs as per the provided schedule.

    Click “Finish” to add the SQL Server. A message box will appear onscreen to restart the software. Once restarted, you will notice a new tab for the added SQL Server in “Radar” tab. “Settings” tab will display the settings to configure the listing of SQL Server, whereas “Audit Reports” tab will show the audit reports for SQL Server.

    Glimpses of Configuration Changes

    Radar tab shows the summarized graph reports of all changes being made in SQL Server.

    SQL Server Tab

    In addition to the default tab, you can create multiple custom views. “Radar” tab for SQL Server lets you keep a check on the most critical changes such as database modification trend, table modification trend, user modification trend, top 10 failed logins, top administrators, resource utilization, all changes trend, and LiveFeed updates.

    Audit Reports

    You can switch to “Audit Reports” tab to view 50+ predefined reports that highlights every change made in the configuration of your SQL Servers.

    Audit Report

    Here, you can view the audit report in both text and graph views.

    Graph Report

    You can apply date range, working hours, and keyword filters to these reports. In addition, the columns can be grouped by and you can search for a particular event.

    Filtered table

    These reports can be saved on the disk and scheduled to be delivered automatically at predefined intervals.

    Create Schedule

    Alerts, Updates, and Notifications

    You can configure real-time alerts that can be delivered to the provided email addresses, displayed at LiveFeed widget of Radar Tab, and sent to the LepideAuditor App installed on your Android or Apple device.

    Create Alert

    These alerts can be used to show the live updates in LiveFeed widget in the Radar tab of SQL Server.

    LiveFeed Widget

    You can also receive the notifications in LepideAuditor App. This app is available in both Google Play Store and Apple App Store.

    App Notifications of SQL Server

    Search in Notifications

    Options in App

    Share Notifications

    In addition, you can install LepideAuditor Suite Web Console to host a report server using which you can let the selected users view the selected audit reports in a Web browser from anywhere in the network.

    All Server Object Modification Report in Web Console

    The best part is that LepideAuditor Suite also has a dedicated report on Console Auditing that shows the changes made to the configuration of the software itself.


    After viewing the working of LepideAuditor Suite, I recommend you all to install this software for auditing any or multiple SQL Servers in the environment. It audits and tracks every change being made to the configuration of SQL Server. The vast set of predefined audit reports along with the options to customize, save, filter, and email the reports periodically make the task easier. Real-time alerts in email, LiveFeed and LepideAuditor App keeps you notified about the critical changes.

    Product page link-

    Download trial -





  • What you should have read :) during the weekend - weekly SQL Server blogs review part 9

    Hello! It is Tuesday already but last week I found a lot of great resources. Hope you will have a lot of fun reading all of them! 





    Rob Farley

    Anti-Harassment Policies and Codes of Conduct

    SQL Server Blog

    SQL Server 2016 Community Technology Preview 3.1 is available

    SQL Server Engineering Team

    Announcing SQL Server Management Studio - November 2015 Release

    Raul Gonzales

    The Mysterious Case of the Missing Default Value

    Joe Chang

    Join and Query hints – serious DBAs need to learn this





  • What you should have read :) during the weekend - weekly SQL Server blogs review part 8

    Hello! It is Monday so I am delivering you the new articles to read!

    Hope you will have a lot of fun reading all of them! 





    Raj Kumar Beniwal

    How to Import And Display Data From Web Page Using Power BI Desktop

    SSW TV

    Asynchronous Programming with Xamarin | Filip Ekberg at Xamarin Hack Day Sydney

    Ajit Jaokar

    Recurrent neural networks, Time series data and IoT – Part One

    Ron Matchoro

    Azure SQL Database Threat Detection now in Public Preview

    Andy Leonard

    Biml 101 Recording and Files Are Now Available!




More Posts Next page »
Privacy Statement