Tags : #sqlserver

18

Oct

The October release of Azure Data Studio is now available
The October release of Azure Data Studio is now available

We are excited to announce the October release of Azure Data Studio (formerly known as SQL Operations Studio) is now available.

Download Azure Data Studio and review the Release Notes to get started.

Note: If you are currently using the preview version, SQL Operations Studio, and would like to retain your settings when you upgrade to the latest version, follow these instructions. When you download Azure Data Studio, remember to enable preview features by default on first launch, and then you can disable in settings if you dont need it otherwise you will be missing preview experiences like Query Plans, certain extension support, and more.

Azure Data Studio is a new cross-platform desktop environment for data professionals using the family of on-premises and cloud data platforms on Windows, MacOS, and Linux. To learn more, visit our GitHub.

Azure Data Studio was announced Generally Available last month at Microsoft Ignite. If you missed the GA announcement, you can see “Azure Data Studio for SQL Server” on the SQL Server blog. You wont want to miss the great orthogonality matrix included comparing SSMS and Azure Data Studio and answers to many of your questions.

Check out this video for a general overview

Share

18

Oct

DBA essentials—SQL Server 2017 security, performance tuning, and more—inside out

Whether youre an experienced DBA with multiple certifications or just starting on your SQL Server DBA journey, you face challenges constantly for putting your organizations data to work. To turn the next-to-impossible into the practical, you need a comprehensive resource at your fingertips: SQL Server 2017 Administration Inside Out, by William Assaf, Randolph West, Sven Aelterman, and Mindy Curnutt. With this guide, you can get to know new and expanded SQL Server features like Columnstore, memory-optimized indexes, and Query Store, plus understand how to administer Microsoft Azure SQL Database or SQL Server 2017 virtual machines running on Azure.

Heres just some of what youll find in the ultimate guide to SQL Server 2017 (spoiler alertget free access to these chapters below):

Database server components

Even if you have a firm foundation in SQL Server configuration and administration, you want to keep the basics at-hand so you can easily refresh your memory. SQL Server 2017 Administration Inside Out provides a solid foundation in the infrastructure that makes up a database and how it works. The guide also offers helpful tips and best practices every DBA should know, like:

Keep in mind that In-Memory OLTP requires RAM overhead thats two times

Share

16

Oct

SQL Server 2019 CTP 2.0 New Features – Introducing the Page Cracker (AKA sys.dm_db_page_info)!

https://blogs.msdn.microsoft.com/sql_server_team/sql-server-2019-ctp-2-0-new-features-introducing-the-page-cracker-aka-sys-dm_db_page_info/Source: https://blogs.msdn.microsoft.com/sql_server_team/sql-server-2019-ctp-2-0-new-features-introducing-the-page-cracker-aka-sys-dm_db_page_info/   Microsoft Ignite 2018 is fading away in the rearview mirror, but the excitement over all the new features and the vision shared there is just beginning. You’re probably seeing lots of buzz around the new Big Data READ MORE

Share

11

Oct

Modernize your SQL Server at the PASS Summit 2018
Modernize your SQL Server at the PASS Summit 2018

Each year thousands of data professionals make the annual visit to Seattle, Washington for the Professional Association for SQL Server Summit. This is a community driven organization and event but Microsoft has been a major contributor, sponsor, and part of this summit since its inception.This is the second post in a series leading up to the PASS Summit 2018, to learn more about the keynotes you can reference the most recent post Join us at PASS Summit 2018 Nov 6-9, 2018.

This year myself and other members of the Microsoft SQL Server Engineering and support teams will be at the PASS Summit again in a major way with keynotes, a pre-conference session, conference sessions, theater sessions, a great booth, and the always popular Data Clinic.

We have already received great interested in our pre-conference session called Modernize Your SQL Server with Bob Ward, the Tiger Team, and CSS Escalation Engineers on Tuesday, November 6th. You can read more about this session at the PASS Summit Session webpage.

Whether you have registered or not, it is not too late to register for this pre-conference seminar. It has been awhile since I have participated in a pre-conference seminar at the PASS Summit.

Share

10

Oct

Join us at PASS Summit 2018 – Nov 6-9, 2018!
Join us at PASS Summit 2018 – Nov 6-9, 2018!

Get inspired by our industry-leading keynote speakers on the Microsoft data platform at PASS Summit 2018! There has never been a more exciting time for data professionals and developers as more organizations turn to data-driven insights to stay ahead and prepare for the future. But staying up to speed in this rapidly changing data landscape is a challenge. At PASS Summit you have the unique combination of community leaders sharing their real-world experience and Microsoft product teams providing deep insights into Microsoft data solutions.

For those attending this year, weve put together a quick guide below to all the relevant Data + AI sessions and clinics that you can look forward to. Cant wait until PASS Summit? Check out the Conference Sessions to get a taste of what you wont want to miss at PASS Summit 2018.

Register today and receive a $200 off discount with code: MSLOVESPASS

Pre-Conference activities – Tuesday, November 6

Modernize your SQL Server with Bob Ward, the Tiger Team, and CSS Escalation Engineers
Speaker: Bob Ward
This session will walk you through practical options for modernizing older releases of SQL Server. There are lots of choices and the engineers at Microsoft are here to

Share

03

Oct

SSMS 18.0 public preview released
SSMS 18.0 public preview released

We are very excited to announce the public preview of SQL Server Management Studio 18.0. SSMS has been ported to the VS 2017 Isolated Shell, which brings with it many improvements to look and feel and accessibility. This release expands platform support to keep up with the announcements at Microsoft Ignite last week and includes bug fixes and feature updates across the board.

Download your copy of SSMS 18 public preview today.

New platform and feature support Support for SQL 2019 Support for Azure SQL Managed Instance Azure SQL Database support SLO/Edition Support for updated Azure SQL SKUs Support for Always Encrypted with secure enclaves UTF-8 support on collation dialog Shell improvements SSMS is based on the new VS 2017 Isolated Shell. This means a modern shell that unlocks all the accessibility features from both SSMS and VS 2017 across SSDT, DTA, Profiler, etc. Smaller download size (~400 MB). This is less than half of what SSMS 17.x is. SSMS can be installed in a custom folder. Currently, this is only available on the command line setup. Pass the extra argument to SSMS-Setup-ENU.exe, SSMSInstallRoot = C:MyFolder High DPI enabled by default. Better support for

Share

26

Sep

SQL Server 2019 Preview
SQL Server 2019 Preview

https://blogs.msdn.microsoft.com/sql_server_team/sql-server-2019-preview/Source: https://blogs.msdn.microsoft.com/sql_server_team/sql-server-2019-preview/   Earlier this week, we announced SQL Server 2019 Public Preview at Microsoft Ignite. All the features that you see in the “What’s New” page are new capabilities that shipped with the CTP 2.0 release. Some of the READ MORE

Share

26

Sep

SQL Server 2019: Celebrating 25 years of SQL Server Database Engine and the path forward

This post is authored by Amit Banerjee, Principal PM Manager, SQL Server andBob Ward,Principal Architect, Microsoft SQL Server Data Services.

SQL Server has provided enterprises the capability to manage all facets of their relational data. Over the years, we have increasingly seen a convergence for the need of combining heterogenous sets of relational and non-relational data to meet the needs of business scenarios. This requires setting up a unified data platform that transcends the boundaries of all types of data. Incidentally, we are also celebrating 25 years since SQL Server first shipped on Windows NT in 1993. The heart of SQL Server is mission critical performance, security, and availability and the use of our database platform in mission-critical environments is a testament to that fact. The SQL Server 2019 preview relational engine will deliver new and enhanced features in the areas of mission-critical performance, security and compliance, and database availability, as well as additional features for developers, SQL Server on Linux and containers, and general engine enhancements.

Earlier at Ignite, Microsoft announced the first public Community Technology Preview (CTP 2.0) of SQL Server 2019. For the first time, SQL Server 2019 comes with big data capabilities built-in, with Apache Spark

Share

25

Sep

SQL Vulnerability Assessment now supports Azure SQL Data Warehouse and Azure SQL Database Managed Instance

https://blogs.msdn.microsoft.com/sqlsecurity/2018/09/25/sql-vulnerability-assessment-now-supports-azure-sql-data-warehouse-and-azure-sql-database-managed-instance/Source: https://blogs.msdn.microsoft.com/sqlsecurity/2018/09/25/sql-vulnerability-assessment-now-supports-azure-sql-data-warehouse-and-azure-sql-database-managed-instance/   SQL Vulnerability Assessment is now available for Azure SQL Data Warehouse and for Azure SQL Database Managed Instance. The assessment functionality and experience are similar to that of SQL Vulnerability Assessment for Azure SQL Database, while exposing READ MORE

Share

25

Sep

SQL Server 2019 preview containers now available
SQL Server 2019 preview containers now available

Starting in SQL Server 2017 with support for Linux and containers, Microsoft has been on a journey of platform and operating system choice. With SQL Server 2019 preview, we are making it easier to adopt SQL Server in containers by enabling new HA scenarios and adding supported Red Hat Enterprise Linux container images. Today we are happy to announce the availability of SQL Server 2019 preview Linux-based container images on Microsoft Container Registry, Red Hat-Certified Container Images, and the SQL Server operator for Kubernetes, which makes it easy to deploy an Availability Group.

Customers are adopting SQL Server containers for many different purposes from local development to testing in DevOps pipelines to deployment with container orchestrators such as Kubernetes. SQL Server in containers are great because of their consistent, isolated and reliable behavior across environments, ease of use, and ease of starting and stopping. Customized content can be built on top of SQL Server containers, and run without being affected by the rest of the environment. This isolation makes SQL Server in containers ideal for test deployment scenarios as well as DevOps processes.

SQL Server 2019 on Linux and container images

SQL Server 2019 is now available on Red Hat

Share