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 Server 2017–all sessions from Microsoft Data Amp are online! Complete list of links!!!

    Hello

    I have just gathered all sessions (deep dive ones) that you might have seen live on 4/19. Look how many sessions are there!!!!

    In case you missed the event and would like to – you can find all the sessions here: http://bit.ly/2pT1tcO

     

    Cheers

    Damian

  • SQL Server 2017 Community Technology Preview 2.0 now available

    I have just written a blog post about what’s new in SSAS in SQL Server 2017 CTP 2.0

    I am very impressed about all the changes Microsoft has done in the product for the last years.

    But, I am also very impressed of what is new / enhanced in this CTP regarding to SQL Server on Windows and Linux:

    • support for storing and analyzing graph data relationships
    • resumable online index rebuild
    • Adaptative Query Processing
    • Interleaved execution
    • Batch mode adaptive joins

    In addition, some functionality that was previously available in SQL Server on Windows is now available on Linux for the first time. This includes:

    • Additional SQL Server Agent capabilities – Use SQL Server Agent to keep replicas in synch with log shipping.
    • Listener for Always On availability groups – The listener enables clients to connect to the primary replica in an availability group, monitoring availability and directing connections to the replicas.

    That is not everything! Citation from the SQL Server Blog:

    Another new, key feature enhancement in CTP 2.0 of SQL Server 2017 is the ability to run the Python language in-database to scale and accelerate machine learning, predictive analytics and data science scripts. The new capability, called Microsoft Machine Learning Services, enables Python scripts to be run directly within the database server, or to be embedded into T-SQL scripts, where they can be easily deployed to the database as stored procedures and easily called from SQL client applications by stored procedure call. SQL Server 2017 will also extend Python’s performance and scale by providing a selection of parallelized algorithms that accelerate data transforms, statistical tests and analytics algorithms. This functionality and the ability to run R in-database and at scale are only available on Windows Server operating system at this time.

    You can read the release notes here: http://bit.ly/2osGdJO

    The SQL Server Blog blog post can be found here: http://bit.ly/2osILYz

    image

    Cheers,

    Damian

  • What’s new in SQL Server 2017 CTP 2.0 for Analysis Services

    Today is a great day. I have been able to take part in the #MSDataAmp conference. While listening to Scott Guthrie I found that SQL Server 2017 CTP 2.0 is available for download

    I like to way Microsoft changes the Analysis Services engine over the time. I just had opportunity to take a look what the engine offered in 2012 and to see how it has been changed since then is very impressive

    Here is what is new / changed / enhanced in the SQL Server 2017 CTP 2.0 in the SSAS engine (text copied from the Analysis Services Team Blog)

    The public CTP 2.0 of SQL Server 2017 on Windows is available here! This public preview includes the following enhancements for Analysis Services tabular.

    • Object-level security to secure model metadata in addition to data.
    • Transaction-performance improvements for a more responsive developer experience.
    • Dynamic Management View improvements for 1200 and 1400 models enabling dependency analysis and reporting.
    • Improvements to the authoring experience of detail rows expressions.
    • Hierarchy and column reuse to be surfaced in more helpful locations in the Power BI field list.
    • Date relationships to easily create relationships to date dimensions based on date columns.
    • Default installation option for Analysis Services is tabular, not multidimensional.

    Other enhancements not covered by this post include the following.

    • New Power Query data sources. See this post for more info.
    • DAX Editor for SSDT. See this post for more info.
    • Existing Direct Query data sources support for M expressions. See this post for more info.
    • SSMS improvements, such as viewing, editing, and scripting support for structured data sources.

    The complete blog post is here: http://bit.ly/2pCwMMo

     

    Cheers

    Damian

  • VarsoviaNewTech–unique conference in Poland (available for all–live streaming!!!)

    Hello folks,

    Maybe you have some time today? You can join a pretty cool conference – VarsoviaNewTech.

    var Sovia = new Tech(); is a Microsoft developer conference that showcases newest dev technologies and solutions. The event puts spotlight on Mixed Reality with HoloLens, Azure, Biological Computing, .NET Core, Bots and Conversation as a Platform, Cognitive Services, Xamarin cross-platform development, Mobile DevOps, Node.js and Serverless Computing.

    Attend var Sovia = new Tech(); on 29th of March, 2017 to hear from speakers representing Microsoft, Microsoft Research, Microsoft's ISV Partners and MVP Community. The event keynote will be delivered by Satya Nadella, Chief Executive Officer of Microsoft.

    During the event you will also have an unique opportunity to dive into the holographic world in the HoloLens Experience Zone, where you would be able to hands-on demo the Mixed Reality solutions developed by Microsoft's ISV partners.

    var Sovia = new Tech(); will be filled with strong technical sessions and will offer you great opportunities to meet, network and learn from others in the industry.

    There will be one more thing there.

    I will be showing together with Marek Byszewski and Piotr Czarnas something very very unique – a database virtualization engine that is called Querona. I have had the opportunity to play with it and it is just shocking (positively)! Wanna see / know more?

    image

    We will show how to use Microsoft Cognitive Services Face API + Recommendation API and HDI Insight data combined with relational data warehouse dat in order to produce reports in PowerBI. Cool!

    Simple as that – join the live stream!

    Cheers

    Damian

  • SQL Server on Linux: Running jobs with SQL Server Agent

     

    SQL Server Team has announced that in CTP 1.4 you can schedule tasks using SQL Server Agent! That was one of the pain things at least for me – I usually have lot of tasks in the SQL Server Agent in my environments. Seems to me that as of now I will be able to test also on Linux.

    I have copied the code from the blog just to show how simple it is to use SQL Server Agent Smile Good thing is that the stored procedures used to configure, manage and run the jobs have the same names in Linux like they have in SQL Server running on Windows

    Here is a simple example:

    • Create a job

    CREATE DATABASE SampleDB ;

    USE msdb ;

    GO

    EXEC dbo.sp_add_job

    @job_name = N’Daily SampleDB Backup’ ;

    GO

    • Add one or more job steps

    EXEC sp_add_jobstep

    @job_name = N’Daily SampleDB Backup’,

    @step_name = N’Backup database’,

    @subsystem = N’TSQL’,

    @command = N’BACKUP DATABASE SampleDB TO DISK = \

    N”/var/opt/mssql/data/SampleDB.bak” WITH NOFORMAT, NOINIT, \

    NAME = ”SampleDB-full”, SKIP, NOREWIND, NOUNLOAD, STATS = 10′,

    @retry_attempts = 5,

    @retry_interval = 5 ;

    GO

    • Create a job schedule

    EXEC dbo.sp_add_schedule

    @schedule_name = N’Daily SampleDB’,

    @freq_type = 4,

    @freq_interval = 1,

    @active_start_time = 233000 ;

    USE msdb ;

    GO

    • Attach the schedule and add the job server

    EXEC sp_attach_schedule

    @job_name = N’Daily SampleDB Backup’,

    @schedule_name = N’Daily SampleDB’;

    GO

    EXEC dbo.sp_add_jobserver

    @job_name = N’Daily SampleDB Backup’,

    @server_name = N'(LOCAL)’;

    GO

    • Start job

    EXEC dbo.sp_start_job N’ Daily SampleDB Backup’ ;

    GO

     

    You can read the SQL Server blog post here: http://bit.ly/2mUwjl4

    Cheers
    Damian

  • SQL Server next version CTP 1.4 now available

     

    Great news again from SQL Server Team – CTP 1.4!!! is available now

    This is what I have read on their blog (copied)

     

    Key CTP 1.4 enhancements

    The primary enhancement to SQL Server v.Next on Linux in this release is the ability to schedule jobs using SQL Server Agent. This functionality helps administrators automate maintenance jobs and other tasks, or run them in response to an event. Some SQL Server Agent functionality is not yet enabled for SQL Server on Linux. To learn more and see sample SQL Server Agent jobs, you can read our detailed blog titled “SQL Server on Linux: Running scheduled jobs with SQL Server Agent” or attend an Engineering Town Hall about “SQL Server Agent and Full Text Search in SQL Server on Linux.”

    The mssql-server-linux container image on Docker Hub now includes the sqlcmd and bcp command line utilities to make it easier to create and attach databases and automate other actions when working with containers. For additional detail on CTP 1.4, please visit What’s New in SQL Server v.Next, Release Notes and Linux documentation.

    In addition, SQL Server Analysis Services and SQL Server Reporting Services developer tools now support Visual Studio 2017. They are available for installation from the Visual Studio Marketplace providing the option for automatic updates going forward.

    Get SQL Server v.Next CTP 1.4 today!

    Try the preview of the next release of SQL Server today! Get started with the preview of SQL Server with our developer tutorials that show you how to install and use SQL Server v.Next on macOS, Docker, Windows, and Linux and quickly build an app in a programming language of your choice.

     

    You can reach the SQL Server blog entry here: http://bit.ly/2mUyeWN

    Cheers

    Damian

  • Public Preview for SQL Server vNext Management Pack (CTP2)

     

    According to the SQL Server Release Services Team we have a new Management Pack (CTP2) for SQL Server vNext

    The new CTP bits for SQL Server vNext Management Pack can be used to monitor SQL Servers both on Windows and Linux

    Here is the list of new features and fixes in the CTP2:

     
    • Implemented “Discovery Data Mapper”; improved queries and datasources
    • Implemented support for full cookdown for all discoveries on Linux and Windows
    • Implemented Log Shipping monitoring
    • Implemented new monitors and rules:
      • “Service Pack Compliance” monitor
      • “SQL Server Windows Service” monitor
      • “CPU Utilization (%)” monitor
      • “SQL Server Service (database)” monitor
      • “Database Health Policy (Critical)” monitor
      • “Database Health Policy (Warning)” monitor
      • “WMI Health” monitor
      • “Memory Used By Tables (MB) rule
      • “Memory Used By Indexes (MB)” rule
      • “MSSQL vNext on Windows: DB Engine CPU Utilization (%)” rule
      • “SQL Server vNext DB Engine is restarted” rule
    • Implemented new DB Space performance rules:
      • MSSQL vNext: DB Allocated Space Unused (MB)
      • MSSQL vNext: DB Free Space Total (%)
      • MSSQL vNext: DB Free Outer Space (MB)
      • MSSQL vNext: DB Transaction Log
      • Free Space Total (%)
      • MSSQL vNext: DB Free Space Total (MB)
      • MSSQL vNext: DB Allocated Space Used (MB)
      • MSSQL vNext: DB Allocated Space (MB)
    • Implemented new classes:
      • SQL Server vNext DB FILESTREAM Filegroup on <Platform>
      • SQL Server vNext DB Memory-Optimized Data Container on <Platform>
      • Generic SQL Server vNext Custom User Policy
      • SQL Server vNext Custom User Policy on <Platform>
      • SQL Server vNext Database Critical Policy on <Platform>
      • SQL Server vNext Database Warning Policy on <Platform>
      • SQL Server vNext Resource Pool Group on <Platform>
      • Generic SQL Server vNext Resource Pool
      • SQL Server vNext Resource Pool on <Platform>
      • SQL Server vNext Internal Resource Pool on <Platform>
      • SQL Server vNext User Resource Pool on <Platform>
      • SQL Server vNext User-Defined Resource Pool on <Platform>
    • Implemented new monitor and rule for FILESTREAM objects:
      • MSSQL vNext on <Platform>: DB FILESTREAM Filegroup Free Space Total (MB)
      • MSSQL vNext on <Platform>: DB FILESTREAM Filegroup Free Space Total (%)
    • Implemented new performance rules for Memory-Optimized Data filegroups:
      • MSSQL vNext on Windows: DB Memory-Optimized Data Filegroup Free Space Total (MB)
      • MSSQL vNext on Windows: DB Memory-Optimized Data Filegroup Free Space Total (%)
    • Implemented “MSSQL LogReader” module
    • Implemented Event Collection monitoring for Linux and Windows (more than 400 workflows)
    • Implemented discoveries, rollups and icons for the new classes; updated Filegroup and child classes’ icons
    • Implemented all XTP counters (more than 200 workflows)
    • Implemented “Empty Bucket percent” in the hash index monitor
    • Implemented “Average length of the row chains” in the hash buckets monitor
    • Implemented “SQL Full-text Filter Daemon Launcher Service”; added “NetworkName” property to local dbengine; refactored Windows monitoring folder structure
    • Added “Local Database” class on Windows
    • Improved the architecture: split “Windows.DBEngine” and “Windows.LocalDBEngine” classes
    • Improved error logging
    • Improved the error-handling (connectivity issues)
    • Remounted “LocalDiscoverySeed” discovery to support long names and not support wow64
    • Updated Add Monitoring Wizard: fixed layouts issues, improved multithreading and performance, implemented background loading progress
    • Updated and fixed the Knowledge Base articles and display strings; unified the workflows naming template
    • Fixed alerts for classes managed by local agent
    • Fixed Smart Connect issues connected with cached data (WMI connection)
    • Fixed Linux modules to skip smart connect
    • Fixed issue: “Total Transactions Per Second” rule runs twice in one interval
    • Fixed issue: SQL Server vNext on Windows database objects may get rediscovered
    • Fixed issue: filegroups get undiscovered in SQL Express instance
    • Fixed issue: in some situations, Add Monitoring Wizard cannot detect that test connection task is completed
    • Fixed issue: the already discovered database objects are undiscovered if database state is changed to “Offline”

    All the details regarding the new functionality can be found in the Operations Guide that can be downloaded along with the Management Pack. Full functionality will be available with SQL Server vNext GA. This CTP release only covers a subset of monitors and rules. We will work towards full functionality as we release new CTPs.

     

    You can read more: http://bit.ly/2mK9DTe

    You can download the software here: http://bit.ly/2lyk9g2

    Cheers

    Damian

  • SQL Server next version CTP 1.3 now available

     

    Great news as we can now play with the newest CTP (1.3).

    According to the official blog post (http://bit.ly/2lTp67k) the most important enhancements are:

    Key CTP 1.3 enhancement: Always On Availability Groups on Linux

    In SQL Server v.Next, we continue to add new enhancements for greater availability and higher uptime. A key design principle has been to provide customers with the same HA and DR solutions on all platforms supported by SQL Server. On Windows, Always On depends on Windows Server Failover Clustering (WSFC). On Linux, you can now create Always On Availability Groups, which integrate with Linux-based cluster resource managers to enable automatic monitoring, failure detection and automatic failover during unplanned outages. We started with the popular clustering technology, Pacemaker.

    In addition, Availability Groups can now work across Windows and Linux as part of the same Distributed Availability Group. This configuration can accomplish cross-platform migrations without downtime. To learn more, you can read our blog titled “SQL Server on Linux: Mission Critical HADR with Always On Availability Groups”.

    Other Enhancements

    SQL Server v.Next CTP 1.3 also includes these additional feature enhancements:

    • Full text search is now available for all supported Linux distributions.
    • Resumable online index rebuilds enables users to recover more easily from interruption of index builds, or split an index build across maintenance windows.
    • Temporal Tables Retention Policy support enables customers to more easily manage the amount of historical data retained by temporal tables.
    • Indirect checkpoint performance improvements. Indirect checkpoint is the recommended configuration for large databases and for SQL Server 2016, and now it will be even more performant in SQL Server v.Next.
    • Minimum Replica Commit Availability Groups setting enables users to set the minimum number of replicas that are required to commit a transaction before committing on the primary.
    • For SQL Server v.Next technical preview running on Windows Server, encoding hints in SQL Server Analysis Services is an advanced feature to help optimize refresh times with no impact on query performance.

     

    Further readings:

    Cheers

    Damian

  • Cumulative Updates for SQL Server 2012 / 2016

     

    Hello

    Things are happening!

    SQL Server 2012 SP2 has CU16 released. You can reach the KB article here and download the update

    There have been 5 issues resolved. The build number is 11.0.5678.0

     

    SQL Server 2012 SP3 has CU7 released. You can reach the KB article here and download the update.

    There have been 12 issues resolved. The build number is 11.0.6579.0

     

    SQL Server 2016 RTM has CU4 released. You can reach the KB article here and download the update.

    There have been 65 (Smile) issues resolved. The build number is 13.0.2193.0

     

    SQL Server 2016 SP1 has CU1 released. You can reach the KB article here and download the update.

    There have been 63 (Smile) issues resolved. The build number is 13.0.4411.0

     

    Other links worth to visit:

    SQL Release Services Blog

    Microsoft TechNet: SQL Server

    MSDN: SQL Server DevCenter

     

    Cheers

    Damian

  • SQL Server vNext–Linux edition

     

    It has been an incredible day for us the SQL Server Community. First of all we have a new SQL Server 2016 SP1 (described here) which changes literally everything. 

    It is not all as we can also play with the SQL Server vNext Linux Edition.

    How can we play?

    First of all – it is a public preview (CTP1) so you can download the bits.

    In case you would like to start now that there is an option to visit TechNet Virtual Labs page.

    There are 4 labs waiting:

    image

    Don’t forget and visit the Release Notes page  and check out what’s new.

    Cool stuff is coming!!

    Cheers

    Damian

  • SQL Server 2016 SP1 shocks the world!!!

    The entire World has been shocked today! We have never expected to see something like this. Go, grab SQL Server 2016 SP1 and you get all those:

    (picture from SQL Server Release Services page)

    Holly Molly!!!!

    Now in SQL Server 2016 Express you have (for FREE):

    • row level security
    • dynamic data masking
    • database snapshot
    • columnstore indexes!!!!
    • partitioning!!!!!!!!
    • compression (page, row…)
    • in memory oltp
    • Always encrypted
    • polybase…..
    • auditing!!!!!
    • multiple filestream containers

    It is like roller coaster especially for companies that use Standard edition as their primary engine.

    For details – check the SQL Server Release Services page.

     

    Cheers

    Damian

  • Great news - MVP Reconnect has been announced

    The official announcement can be found at https://blogs.msdn.microsoft.com/stevengu/2016/11/03/announcing-the-mvp-reconnect-program-the-2016-mvp-global-summit/

    What is MVP Reconnect?

    • MVP Reconnect is Microsoft’s way of keeping former MVPs in touch with Microsoft and each other.
    • The idea behind the program can be best described with an analogy from another industry; The Oscars are one of the most well recognized and prestigious awards in the film industry. From the moment someone wins their first Oscar, they become part of a very special community – that of Academy Award Winners – and they belong to this community forever, even if they don’t win an award every year. The same is true for MVPs: once an MVP, always part of the MVP community! 

    Why is this program being launched?

    • Over the years, Microsoft has received feedback from former MVPs that they were looking for ways to stay in touch with the program and with their peers. This program is an extension of Microsoft’s commitment to the MVP program and another way to recognize the expertise and engagement that folks contribute to technical communities.

    Why should you join?

    • MVP Reconnect allows members to stay connected to other community leaders and Microsoft. If your contributions to the technical community slow down temporarily, staying connected means that you maintain a good position for future recognition as an MVP. If you have a long history with the MVP program, you’ll be able to share your experiences and coach others to take full advantage of all the opportunities that the MVP award can provide.
    • Benefits include networking opportunities, recognition, and engagement offerings like invitations to community events. 

    Who is eligible for the program? What are the requirements for membership?

    • All former MVPs with a minimum award period of one year who ended their tenure “in good standing” are eligible to join. “Good standing” means that an MVP must not have been retired due to an NDA or Code of Conduct violation. There are no limitations based on technical expertise or award category!

    Where can you find more information about the program?

    How can you join?

    • In the future, MVPs who reach the end of their award tenure will be invited automatically. 
    • Former MVPs can request to join by filling out the form at https://mvp.microsoft.com/en-us/Pages/reconnect-requestform. After validating the request, Microsoft will send an official email invitation. 
    • Please note that the validation process is made easier by providing more information on the form. Specifically, supplying your MVP ID and primary email used as an MVP will help expedite the process.

     

    Cheers

    Damian

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

    I have found some great articles to be read

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

     

    Author

    Title

    Link

    Adam Machanic

    sp_whoisactive: The Big Fixes

    http://bit.ly/2f1ddJA

    Jorg Klein

    Azure Data Lake Analytics U-SQL decryption possibilities

    http://bit.ly/2dQ03MT

    CSS SQL Server Engineers

    How It Works: Online Index Rebuild – Can Cause Increased Fragmentation

     

    http://bit.ly/2ehn3nL

    CSS SQL Server Engineers

    SQL 2016 — Why can’t I STRETCH my database (I have the right user name and password)?

    http://bit.ly/2eCLqg4

    Grant Fritchey

    A Subquery Does Not Hurt Performance

    http://bit.ly/2f1mZvc

     

    Cheers

    Damian

  • Technical review–SysTools SQL Recovery

    SQL Server is a relational database that saves the entire data, which can be easily repaired by software when it is required. SQL MDF files are the main database files of SQL database. They are the base files of the primary data of SQL server and any damage to these files may result in the fall down of the complete database. Therefore any sort of corruption in these MDF files should be repaired and eliminate the risk of corruption of the entire database. The most common reason that is behind the corruption of MDF files is improper system shutdown. In addition, the SQL database may be infected with viruses and malwares that not only corrupt a single file but also have the capacity to destroy complete database. Now, the question comes how to retrieve the corrupted SQL database? There is one solution to overcome from such a situation is to utilize the third-party utility, i.e. SysTools SQL Recovery Software that repairs corrupt SQL database. This review discusses about the software  is based upon the testing performed by the application.

    Introduction

    This SQL file repair tool can repair both corrupted MDF as well as NDF files and export it to different file formats of a SQL Database. It repairs both primary and secondary database in, as it is form. It scans and retrieve numerous of NDF files or complete folder containing all NDF files. It supports SQL Server 2014 and all the below editions to recover database from mdf and ndf files.

    Different Versions to Repair Corrupt SQL Database

    The SQL Recovery software is available in two versions, i.e. Demo as well as Licensed. Users can select any version accordingly.

    · Demo Version

    The Demo version is totally free to utilize by simply downloading it from the official website of the SysTools Group. As it is a free edition, so there are limitations, i.e. it permits users to preview all the repaired components of SQL database, but cannot allow them to store and export them.

    · Licensed Version

    It is a paid edition of the software that can be bought from the official site of organization. It allows users to repair, save, and export all the data into SQL Server database.

    Features of SQL .mdf File Repair Tool

    Repair both MDF & NDF files

    The tools help to retrieve both primary as well as secondary database files such as MDF and NDF files. It maintains the originality of file data after repairing the database table’s data and even previews the complete components in it.

    Automatically Detects Server Edition

    The application is programmed in a way that it automatically detects the edition of both NDF as well as MDF files. However, if the edition is known by the servers then, users can check it manually on their own.

    Dual Scanning Way

    The SQL .mdf file repair tool provides two modes for scanning the complete SQL server database file. One mode is Quick scan that is for normal database corruption. Another mode is advance scan, which is for the deep corruption of the database files (.mdf & .ndf).

    Dual Scanning Way

    Store Scanned Files For Further Usage

    The SQL database repair tool provides the option to save the scanned data in .str file format. This feature enables the user to avoid re-scanning of the corrupted .mdf or .ndf file again and again.

    Supports Both Database Keys

    The SQL database repair tool supports both the primary as well as foreign keys along with database tables. Both the keys are supported after exporting the database that is performed via a software.

    Supports Advance Data Types

    The software supports the advance data types to repair SQL database that includes sql_variant, hierarchyid, geography, geometry data types, Datetime2, datetimeoffset, etc. Moreover, the application supports Unicode as well as ASCII XML data types.

    Quickly Recover  SQL .mdf File Components

    Once the database files scanned by SQL database recovery tool, It provides a preview of recovered items like Tables, Functions, Stored Procedures, Views, Triggers, Rules, Associated Primary Keys, Data Types, Unique Keys, and all the other SQL database components.

    Quickly Recover  SQL .mdf File Components

     

    Retrieve Deleted Table Data

    The data of SQL table gets deleted accidentally due to various situations. In such a situation, the software will help to recover the deleted data of table in exact form without losing the data.

    Repair SUSPECT SQL Server Database

    If the user is unable to access the database because of SUSPECT error then Software will helps to repair database which is marked as suspected.

    Export to SQL Server Database with Desired SQL Files

    The utility gives an option to export the repaired data directly to live SQL Server database. The users only need the credentials such as Database name, Username, Server name and password etc.

    After providing the above necessary information, user can export the desired database items from both MDF and NDF files and store it. It permits users to check or unchecked the recovered items accordingly and then exporting it to SQL Server database or as a SQL Server Compatible SQL Scripts.

    Export to SQL Server Database with Desired SQL Files

     

    Retains the Data Integrity

    The tool repairs the complete data files of SQL Server in exact form. It preserves the on-disk folder structure, formatting, styling, etc. in the same form as it was.

      Conclusion

    Considering the overall performance of the application I have to say I like it. It is also very intuitive and works very quickly. Although the software fails to repair the bulk, MDF files. However, it accurately repair highly corrupted data files (tested on 3 damaged databases). Moreover, it has easy and user-friendly interface, which is very necessary for users in repairing a corrupt SQL Server database. To sum it all up my recommendation for all the numerous of users is that this application is definitely worth trying.

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

     

    Cheers,

    Damian

More Posts Next page »
Privacy Statement