Tags : #sqlserver

20

Jul

Behavior Change for VSS Backups on VMs with Basic Availability Groups

https://blogs.msdn.microsoft.com/sql_server_team/behavior-change-for-vss-backups-on-vms-with-basic-availability-groups/Source: https://blogs.msdn.microsoft.com/sql_server_team/behavior-change-for-vss-backups-on-vms-with-basic-availability-groups/   This week we released SQL Server 2016 SP2 CU2 and SQL Server 2017 CU9. In this blog, I’d like to go into a little more detail on one of the fixes that is part of these CUs READ MORE

19

Jul

Tiger Team at Data Platform Summit 2018
Tiger Team at Data Platform Summit 2018

https://blogs.msdn.microsoft.com/sql_server_team/tiger-team-at-data-platform-summit-2018/Source: https://blogs.msdn.microsoft.com/sql_server_team/tiger-team-at-data-platform-summit-2018/   Tiger Team (@mssqltiger) represented by (Tejas Shah and Sourabh Agarwal) will be presenting about the recent investments in SQL Server at the Data Platform Summit (#DPS10), Asia’s Premier Data & Analytics Conference taking place on 9-11 August READ MORE

19

Jul

The July release of SQL Operations Studio is now available

We are excited to announce the July 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 June release is the eighth major update since the announcement. If you missed it, the June release announcement is available here.

Highlights for this release include the following.

SQL Server Agent preview extension Job configuration support SQL Server Profiler preview extension Improvements Combine Scripts Extension Wizard and Dialog Extensibility Social content Fix GitHub Issues

For complete updates, refer to the Release Notes.

SQL Server Agent configuration

As part of our story of bringing over SSMS features and improving user experience, we are excited to introduce SQL Agent configuration support.

Summary of changes include:

Added view of Alerts, Operators, and Proxies and icons on left pane Added dialogs for New Job, New Job Step, New Alert, and New Operator Added Delete Job, Delete

12

Jul

SQL Server 2008 end of support is the first step to tomorrow’s database

Today, Takeshi Numoto blogged about the upcoming SQL Server 2008 and 2008 R2 end of support. If youve been thinking about what to do with your SQL Server 2008 and 2008 R2 databases, youre not alone. These databases reach end of support on July 9, 2019, and many organizations have started planning in earnest for this milestone.

Which brings us to Will, a database admin at that development shop downtown. Bucking the job-hopping trends of today, Wills been a stalwart for his company, wrangling data for them since the mid-2000s. He remembers leading the installation of SQL Server 2008. Back then, connections were speedy, requests processed swiftly. Security, efficiency, and good clean design existed in abundancethere was a place for every byte and every byte was in its place. App developers loved Will because he made sure their data was right where they needed it, when they needed it. What an idyllic, peaceful time!

A lot has happened in the decade since. Over the years, Wills information transfer network has grown and evolvedforking and pooling and spidering as it has had to make new, less-efficient references. The schema, once so clear, is now muddied and confusing, obscuring paths for formerly

06

Jul

Predicate Pushdown and why should I care?
Predicate Pushdown and why should I care?

https://blogs.msdn.microsoft.com/sql_server_team/predicate-pushdown-and-why-should-i-care/Source: https://blogs.msdn.microsoft.com/sql_server_team/predicate-pushdown-and-why-should-i-care/   If you follow this blog, you know that in the last couple years, we have been adding more information to showplan, to make it a one-stop-shop for all your query performance troubleshooting insights. You can see more READ MORE

06

Jul

SQL Server 2008 and 2008 R2 are reaching end of support. What’s next?

SQL Server 2008 and 2008 R2 have had a tremendous run. But all good things come to an end, right? On July 9, 2019, Microsoft will end Extended Support, which means no more updates or support of any kind, potentially leaving you vulnerable to security and compliance issues.

The good news is, you still have plenty of time and options to avoid any heartburn caused by the technology circle of life. And well lay out all of those options for youin a webinar on July 12.

In this webinar, well show you:

how to migrate your applications and data to make the transition more than just an upgrade how to avoid business disruptions and adopt the most current security technologies the advantages of moving your legacy platforms to SQL Server 2017 and Azure the range of guidance and resources available to help, no matter which path you choose

We want this transition to be as seamless and pain-free as possible for you. Register now and find out all the ways weve come up with to make that happen.

05

Jul

PowerShell cmdlets for managing SQL Vulnerability Assessments

https://blogs.msdn.microsoft.com/sqlsecurity/2018/07/05/powershell-cmdlets-for-managing-sql-vulnerability-assessments/Source: https://blogs.msdn.microsoft.com/sqlsecurity/2018/07/05/powershell-cmdlets-for-managing-sql-vulnerability-assessments/   We are pleased to announce the availability of PowerShell cmdlets for managing SQL Vulnerability Assessments for your SQL Servers. The cmdlets can be used to run assessments programmatically, export the results and manage baselines. To get started, READ MORE

02

Jul

Re-platforming and modernizing your data workloads with SQL Server on Linux

This post is authored by Marko Hotti, Senior Product Marketing Manager, SQL Server.

Today, were excited to introduce a free e-book, SQL Server on Linux: A guide to re-platforming and modernizing your data workloads. This is the thirdin a series oftechnical e-books helping you get the most out of your database. With SQL Server 2017, you can harness the latest capabilities of SQL Server on the platform of your choicewhether thats Windows, Linux, or even containers.

In this guide, you getthe technical details for preparing your Linux system for SQL Server installation, managing a mixed environment, and migrating your existing data and databases. The e-book addresses flexibility, performance, and security with your data platform, whether youre a database architect, administrator, or developer working with data.

Here’s whats covered:

An overview of SQL Server on Linuxunderstand platform options, features, pricing, and more. Getting the most out of SQL Server on Linuxreview our planning considerations to prepare your Linux system to best support your business goalssuch as performance optimization, high availability, or enterprise-grade security. Tools and managementget a rundown of the many tools available from Microsoft that make managing your mixed environment easier. Migrations and upgradesdiscover the tools and services available

29

Jun

TEMPDB – Files and Trace Flags and Updates, Oh My!
TEMPDB – Files and Trace Flags and Updates, Oh My!

https://blogs.msdn.microsoft.com/sql_server_team/tempdb-files-and-trace-flags-and-updates-oh-my/Source: https://blogs.msdn.microsoft.com/sql_server_team/tempdb-files-and-trace-flags-and-updates-oh-my/   TL;DR – Update to the latest CU, create multiple tempdb files, if you’re on SQL 2014 or earlier enable TF 1117 and 1118, if you’re on SQL 2016 enable TF 3427. And now it’s time for everyone’s READ MORE

26

Jun

Optimizing Replication Agent profile parameters for better performance

https://blogs.msdn.microsoft.com/sql_server_team/optimizing-replication-agent-profile-parameters-for-better-performance/Source: https://blogs.msdn.microsoft.com/sql_server_team/optimizing-replication-agent-profile-parameters-for-better-performance/   When SQL Server replication is used on environments with high traffic OLTP systems, users often need to adjust the agent profile parameters to increase the throughput of the log reader and distribution agents to keep up with READ MORE