THE SQL Server Blog Spot on the Web

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

Damian Widera

  • 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 -  http://go.microsoft.com/fwlink/?LinkID=733372

    MSDN Subscribers - http://msdn.microsoft.com/subscriptions/downloads

    MSDN Technet - http://technet.microsoft.com/subscriptions/downloads

    Technet/MSDN Evaluation - https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016

    MSDN Evaluation – Express - https://www.microsoft.com/en-us/server-cloud/Products/sql-server-editions/sql-server-express.aspx

    Microsoft Command Line Utilities 13 for SQL Server - http://go.microsoft.com/fwlink/?LinkID=797863

    Microsoft SQL Server 2016 Feature pack – http://go.microsoft.com/fwlink/?LinkID=398150

    Microsoft SQL Server 2016 PowerPivot for SharPoint 2013 - http://go.microsoft.com/fwlink/?LinkID=398152

    Microsoft SQL Server 2016 PowerPivot for SharePoint 2016 - http://go.microsoft.com/fwlink/?LinkID=716860

    Microsoft SQL Server 2016 RS add-in for SharePoint – http://go.microsoft.com/fwlink/?LinkID=398153

    Microsoft SQL Server 2016 MDS Add-in – http://go.microsoft.com/fwlink/?LinkID=398159

    Microsoft SQL Server 2016 Report Builder - http://go.microsoft.com/fwlink/?LinkID=398161

    Microsoft SQL Server 2016 Semantic – http://go.microsoft.com/fwlink/?LinkID=398160

    (SSEI) Microsoft SQL Server 2016 Express http://go.microsoft.com/fwlink/?LinkID=800043

    (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)

     

    Cheers

    Damian

  • 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.

      

    Author

    Title

    Link

    Paul Randal

    SQL Server Wait Statistics Library

    http://bit.ly/21QmRwL

    Paul Randal

    SQL Server Latch Classes Library

    http://bit.ly/1OkTAm4

    Paul Randal

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

    http://bit.ly/1VR3vaG

    Paul Randal

    Code to analyze the transaction hierarchy in the log

    http://bit.ly/1s8NPDM

    Paul Randal

    Updated sys.dm_os_waiting_tasks script to add query DOP

    http://bit.ly/1OkTURQ

     

    Cheers

    Damian

     

  • 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.

      

    Author

    Title

    Link

    Aaron Bertrand

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

    http://bit.ly/1T2eIEX

    Aaron Bertrand

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

    http://bit.ly/1NXfbWV

    Aaron Bertrand

    Performance Surprises and Assumptions : DATEADD

    http://bit.ly/1T0NqyN

    Aaron Bertrand

    Performance Surprises and Assumptions : STRING_SPLIT()

    http://bit.ly/23q94fi

    Aaron Bertrand

    Instant File Initialization : Impact During Setup

    http://bit.ly/1rvz8di

     

    Cheers

    Damian

  • 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: http://www.stellarinfo.com/sql-database-toolkit.php.

     

    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

     

     

    Conclusion

    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! 

    Cheers

    Damian 

  • 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

     

    Cheers

    Damian 

     

     

  • 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!

    Damian 

  • 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.

      

    Author

    Title

    Link

    Jack Li

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

    http://bit.ly/1OBAms9

    Klaus Aschenbrenner

    How to pollute your Plan Cache with parameterized SQL statements

    http://bit.ly/1ntWgqK

    Adam Machanic

    SQLQueryStress: The Source Code

    http://bit.ly/1RPJTCi

    Mark Broadbent

    Problem removing files from TempDB

    http://bit.ly/1OsM1M9

    Joe Celko

    Declarative SQL: Using References

    http://bit.ly/1JVwTYK

    Michael Sorens

    Documenting Your PowerShell Binary Cmdlets

    http://bit.ly/1n6UL16

     

    Cheers

    Damian

  • 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.

      

    Author

    Title

    Link

    Solomon Rudzky

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

    http://bit.ly/1mfXWmC

    Louis Davidsson

    What Counts For a DBA

    http://bit.ly/1MuyXkS

    Merrill Aldrich

    Automate ETL Testing: Cross-Server Data Comparison with PowerShell

    http://bit.ly/1PkuebL

    Gail Shaw

    When naming transactions causes an error

    http://bit.ly/1m6i2QR

    Paul White

    Temporary Tables in Stored Procedures

    http://bit.ly/1QFLXw5

    MSSQL Tips

    Demystify TempDB Performance and Manageability

    http://bit.ly/1OJsvZ7

     

    Cheers

    Damian

     

  • 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! 

      

    Author

    Title

    Link

    Nick Burns

    Combining R and SQL Server to diagnose performance bottlenecks

    http://bit.ly/1MfFi3r

    Glenn Berry

    Introduction to Storage Spaces Direct for SQL Server

    http://bit.ly/1lN6aTI

    SQL Server Database Engine Team

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

    http://bit.ly/1Qr61C0

    Greg Low

    My Sessions from Ignite Australia on the Gold Coast now online

    http://bit.ly/1YewA1M

    Rob Farley

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

    http://bit.ly/1Y73SQe

     

    Cheers

    Damian

  • 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

    Prerequisites

    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

    Installation

    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.

    Conclusion

    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- http://www.lepide.com/lepideauditor/sql-server.html

    Download trial - http://www.lepide.com/lepideauditor/download.html

     

    Cheers

    Damian 

     

  • 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! 

      

    Author

    Title

    Link

    Rob Farley

    Anti-Harassment Policies and Codes of Conduct

    http://bit.ly/1PWUVnZ

    SQL Server Blog

    SQL Server 2016 Community Technology Preview 3.1 is available

    http://bit.ly/1OrySUU

    SQL Server Engineering Team

    Announcing SQL Server Management Studio - November 2015 Release

    http://bit.ly/1IRwEYQ

    Raul Gonzales

    The Mysterious Case of the Missing Default Value

    http://bit.ly/1OfHr0H

    Joe Chang

    Join and Query hints – serious DBAs need to learn this

    http://bit.ly/1ONt9cf

     

    Cheers

    Damian

     

  • 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! 

      

    Author

    Title

    Link

    Raj Kumar Beniwal

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

    http://bit.ly/1QQsic6

    SSW TV

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

    http://bit.ly/21pSKgG

    Ajit Jaokar

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

    http://bit.ly/1Njnpl4

    Ron Matchoro

    Azure SQL Database Threat Detection now in Public Preview

    http://bit.ly/1NExCz7

    Andy Leonard

    Biml 101 Recording and Files Are Now Available!

    http://bit.ly/1XtcoZv

     

    Cheers

    Damian

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

    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!

     

      

    Author

    Title

    Link

    CSS SQL Server Engineers

    Are my statistics correct?

    http://bit.ly/1X2OApU

    Chris Webb

    Power BI DirectQuery Mode: Not Just SSAS DirectQuery v2.0

    http://bit.ly/1SxnFkE

    Brent Ozar

    Is My SQL Server Too Big for Virtualization or the Cloud?

    http://bit.ly/1HQ6mei

    Doug Lane

    The Five Stages of Dynamic SQL Grief

    http://bit.ly/20Xjl4c

    Greg Low

    Data Tales #4: The Case of the Phantom Duplicate

    http://bit.ly/1QqLrkV

    Rob Farley

    What’s driving your data model?

    http://bit.ly/1lrDL5a

    Itzik Ben-Gan

    Packaging Intervals with Priorities

    http://bit.ly/1NX80fj

     

     Cheers

    Damian

     


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

    Hello ! Been really busy last week so instead of publish my weekly review on Monday morning I do it now. It is Wednesday, 11/11 and we have Independence Day here in Poland! Happy reading J


     

     

    Author

    Title

    Link

    Joe Chang

    Computers without ECC memory are crap - no exceptions

    http://bit.ly/1NJvy7i

    Master Data Services Team

    What's New in Master Data Services - SQL2016 CTP3

    http://bit.ly/1PofsBF

    CSS SQL Server Engineers

    The given network name is unusable because there was a failure trying to determine if the network name is valid for use by the clustered SQL instance

    http://bit.ly/1PBQInU

    Neeraj Tripathi

    SQL Server Heaps, and Their Fragmentation

    http://bit.ly/1PBQNId

    Mine / R-bloggers

    A two-hour introduction to data analysis in R

    http://bit.ly/1LKRvjS

     

    Cheers

    Damian 

     

More Posts Next page »
Privacy Statement