Tags : #sqlserver

20

Sep

Cloud Data and AI Services training roundup September 2018
Cloud Data and AI Services training roundup September 2018

To help you stay up to date on online training opportunities, were releasing a monthly list of the latest free Data and Artificial Intelligence (AI) sessions in one convenient post.

SQL Server

With SQL Server virtual machines, you can use full versions of SQL Server in the cloud without having to manage any on-premises hardware. SQL Server virtual machines also simplify licensing costs when you pay as you go. They run many different geographic regions worldwide and offer a variety of machine sizes.

Leverage SQL Server by moving to Azure Virtual Machines

As data continues its exponential growth, its increasingly important to trim costs and manage risks while ensuring that your users have uninterrupted access. Register for this upcoming session to learn how to get started with SQL Server on Azure virtual machines, migrate your on-premises database to the cloud and use built-in features such as automated backup and patching.

Intelligence (AI)

Infuse your apps, websites, and bots with intelligent algorithms to see, hear, speak, understand, and interpret your user needs through natural methods of communication. The Microsoft AI platform offers a comprehensive set of flexible AI services for any scenario and enterprise-grade AI infrastructure that runs AI

19

Sep

Developer’s Choice: Hinting Query Execution model
Developer’s Choice: Hinting Query Execution model

https://blogs.msdn.microsoft.com/sql_server_team/developers-choice-hinting-query-execution-model/Source: https://blogs.msdn.microsoft.com/sql_server_team/developers-choice-hinting-query-execution-model/   Over the years you have read a number of blogs advocating for or against trace flags that influence SQL Server’s query execution model. You can see a number of query execution related trace flags are documented at READ MORE

13

Sep

SQL Audit logs in Azure Log Analytics and Azure Event Hubs
SQL Audit logs in Azure Log Analytics and Azure Event Hubs

https://blogs.msdn.microsoft.com/sqlsecurity/2018/09/13/sql-audit-logs-in-azure-log-analytics-and-azure-event-hubs/Source: https://blogs.msdn.microsoft.com/sqlsecurity/2018/09/13/sql-audit-logs-in-azure-log-analytics-and-azure-event-hubs/   We are pleased to announce that Azure SQL Database Audit logs can now be written directly to Azure Log Analytics or Azure Event Hubs. This ability, now available in public preview, provides SQL Database Auditing customers with READ MORE

06

Sep

SQL Server on Linux: ADAuth issues 3: Could not obtain information about Windows NT group/user ‘CONTOSOuser’

https://blogs.msdn.microsoft.com/sql_server_team/sql-server-on-linux-adauth-issues-3-could-not-obtain-information-about-windows-nt-group-user-contosouser/Source: https://blogs.msdn.microsoft.com/sql_server_team/sql-server-on-linux-adauth-issues-3-could-not-obtain-information-about-windows-nt-group-user-contosouser/   AD authentication is a popular mechanism for login and user authentication. It works very well in many scenarios, especially for enterprise applications. AD authentication is a supported scenario on SQL Server on Linux. Imagine a scenario where READ MORE

05

Sep

SSMS 17.9 is now available
SSMS 17.9 is now available

We are excited to announce the release of SQL Server Management Studio (SSMS) 17.9!

Download SSMS 17.9 and review the Release Notes to get started.

SSMS 17.9 provides support for almost all feature areas on SQL Server 2008 through the latest SQL Server 2017, which is now generally available.

In addition to enhancements and bug fixes, SSMS 17.9 comes with several new features:

ShowPlan improvements Azure SQL support for vCore SKUs Bug Fixes

View the Release Notes for more information.

ShowPlan improvements

Graphical Showplan now shows the new row mode memory grant feedback attributes when the feature is activated for a specific plan: IsMemoryGrantFeedbackAdjusted and LastRequestedMemory added to the MemoryGrantInfo query plan XML element. For more on row mode memory grant feedback, see Books Online.

For more on row mode memory grant feedback, view the Adaptive Query Processing documentation.

Image from Adaptive Query Processing

Azure SQL support for vCore SKUs

Added support for vCore SKUs in Azure DB creation. For more information on vCore, check out the full blog.

Image from Azure SQL DB blog

Bug fixes

In SSMS 17.9, there were many bug fixes.

Replication Monitor Fixed an issue that was causing Replication

05

Sep

SQL Server on Linux: ADAuth issues 2: Common AD Login Issues
SQL Server on Linux: ADAuth issues 2: Common AD Login Issues

https://blogs.msdn.microsoft.com/sql_server_team/sql-server-on-linux-adauth-issues-2-common-ad-login-issues/Source: https://blogs.msdn.microsoft.com/sql_server_team/sql-server-on-linux-adauth-issues-2-common-ad-login-issues/   AD authentication is a popular mechanism for login and user authentication. It works very well in many scenarios, especially for enterprise applications. AD authentication is a supported scenario on SQL Server on Linux. Imagine a scenario where READ MORE

04

Sep

SQL Server on Linux: ADAuth issues 1: Issues with joining a VM to a domain

https://blogs.msdn.microsoft.com/sql_server_team/sql-server-on-linux-adauth-issues-1-issues-with-joining-a-vm-to-a-domain/Source: https://blogs.msdn.microsoft.com/sql_server_team/sql-server-on-linux-adauth-issues-1-issues-with-joining-a-vm-to-a-domain/   AD authentication is a popular mechanism for login and user authentication. It works very well in many scenarios, especially for enterprise applications. AD authentication is a supported scenario on SQL Server on Linux. Configuring the Linux VM READ MORE

30

Aug

The August release of SQL Operations Studio is now available
The August release of SQL Operations Studio is now available

We are excited to announce the August release of SQL Operations Studio is now available.

Download SQL Operations Studio and review the Release Notes to get started.

SQL Operations Studio is a data management tool that enables you to work with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux. To learn more, visit our GitHub.

SQL Operations Studio was announced for Public Preview on November 15th at Connect(), and this August release is the ninth major update since the announcement. If you missed it, the July release announcement is available here.

Highlights for this release include the following.

Announcing the SQL Server Import extension SQL Server Profiler Session management New community extension: First responder kit Quality of Life improvements: Connection strings Bug bash galore

For complete updates, refer to the Release Notes.

Announcing the SQL Server Import extension

It all started from a simple idea: Take the #1 most used wizard in SSMS in the past year and bring this wizard to SQL Operations Studio. When we first released our Wizard and Dialog extensibility APIs in June, this was the perfect candidate to test our wizards and highlight to the community that

29

Aug

Installing SQL Server 2017 for Linux on Ubuntu 18.04 LTS
Installing SQL Server 2017 for Linux on Ubuntu 18.04 LTS

https://blogs.msdn.microsoft.com/sql_server_team/installing-sql-server-2017-for-linux-on-ubuntu-18-04-lts/Source: https://blogs.msdn.microsoft.com/sql_server_team/installing-sql-server-2017-for-linux-on-ubuntu-18-04-lts/   Prior to SQL Server for Linux 2017 CU10 the package dependencies prevented install on Ubuntu 18.04 LTS. The SQL Server 2017 installation packages have updated use the libssl1.0.0 package, allowing installation to occur on Ubuntu 18.04 LTS READ MORE

09

Aug

Cloud data and AI services training roundup August 2018
Cloud data and AI services training roundup August 2018

To help you stay up to date on online training opportunities, were releasing a monthly list of the latest free Data and Artificial Intelligence (AI) sessions in one convenient post.

SQL Server

Build modern applications using the language of your choice, on-premises and in the cloud, now on Windows, Linux, and Docker containers.

Prepare for Windows Server 2008 and SQL Server 2008 End of Support
Support for SQL Server 2008/ 2008 R2 and Windows Server 2008 will end in July 2019 and January 2020, respectively, which means youll no longer receive security patches for these versions. When you join this session, youll learn how to migrate your applications and data, avoid business disruptions, and adopt the most current security technologies. You will also receive guidance for your migration and find resources to help you move quickly. Azure Database services for PostgreSQL and MySQL

Azure Database Services for PostgreSQL and MySQL provide fully managed, enterprise-ready community PostgreSQL/MySQL database as a service. These community editions help you easily lift and shift to the cloud, using languages and frameworks of your choice. On top of that, you get built-in high availability and capability to scale in seconds, helping you easily adjust