'Continuing my series on using Power Bi with my DBA Database I am going to show in this post how I create the most useful daily report for DBAs – The SQL Agent Job report.'...
https://sqldbawithabeard.com/2015/09/28/power-bi-powershell-and-sql-agent-jobs/
'June 1, 2016 by SQL Server Engineering Team
Today, we are very pleased to announce the generally available release of SQL Server Management Studio (SSMS). This release includes all updates included in the April preview release, and features a new Quick Find dialog in SSMS, improvements in the SSMS installer to allow tracking of installation progress, bug fixes in the Always Encrypted experience, and many more.
Get it here:
Download SSMS June 2016 generally available release
New in this release: SSMS is generally available starting with the June 2016 release.'...
'SQL Server is one of the most widely used RDBMS around the world, and one of the facts of this wide adoption comes from Microsoft’s commitment to add new capabilities to cater to the need of the changing landscape year over year. Along the same line, SQL Server 2016 introduces several new features and one of them is Stretch Database, which lets you move or archive your cold data from the local SQL Server database to the Azure SQL Database transparently (without writing code for data movement) so that your local SQL Server database has less overhead in maintaining them (and hence overall increasing the performance) and at the same time, stretched data is online allowing applications to access it like any other table.'...
Understanding Stretch Database Functionality in SQL Server 2016
http://www.databasejournal.com/features/mssql/understanding-stretch-database-functionality-in-sql-server-2016.html
Getting Started with Stretch Database Functionality in SQL Server 2016 – Part 1
http://www.databasejournal.com/features/mssql/getting-started-with-stretch-database-functionality-in-sql-server-2016-part-1.html
Getting Started with Stretch Database Functionality in SQL Server 2016 - Part 2
http://www.databasejournal.com/features/mssql/getting-started-with-stretch-database-functionality-in-sql-server-2016-part-2.html
'Data Exposed Studio, hosted at the SQL Konferenz in Darmstadt, Germany, presents a series of panel discussions composed of renowned speakers and SQL Server MVPs covering a wide array of interesting and insightful topics.'...
https://channel9.msdn.com/Blogs/SQL-Konferenz-2016?wt.mc_id=DX_59323
'June 3, 2016 update: The final ebook can be downloaded from the SQL Server website. Note: you will be required to complete a form to download the ebook.'...
'June 1, 2016 by SQL Server Team
This post was authored by Joseph Sirosh, Corporate Vice President, Data Group, Microsoft.
Today we announced the general availability of SQL Server 2016, the world’s fastest and most price-performant database for HTAP (Hybrid Transactional and Analytical Processing) with updateable, in-memory columnstores and advanced analytics through deep integration with R Services. Software applications can now deploy sophisticated analytics and machine learning models in the database resulting in 100x or more speedup in time to insight, compared to deployments of such models outside of the database.'...
'Join Scott Klein and Rohan Kumar LIVE on SQL Unplugged. This show is your avenue for chatting with the individuals who own the relational database at Microsoft. Tune in each month as Scott and Rohan answer your questions and discuss the insights and inner workings of the SQL Server engineering team. Be sure to follow this show on Twitter (@SQLUnplugged) for updates and information on upcoming shows.
Today's show discusses:
SQL Server 2016 GA
SQL Server on Linux
Azure SQL DW
Elastic Pools
R integration'