Category Archives : #SQLServer

12

Nov

Five essential skills for today’s database administrators
Five essential skills for today’s database administrators

DevOps, the cloud, and new database technologies mean our jobs as database administrators (DBAs) are changing at an ever-faster pace. If you’re fascinated by data and all the things you can do with it, it’s a thrilling time to be in the business. Here are five of the skills we see as essential parts of the modern DBA’s toolkit.

Expertise with multiple technologies: The one-size-fits-all approach to databases is fading. Just as application developers are moving toward a microservices model that focuses on the right tool for the job, organizations are choosing databases according to specific workload needs. The more you know about Hadoop, NoSQL, graph, and other technologies, the better-positioned you will be to make a positive contribution to the conversation.Collaboration: Speaking of conversations, DBAs will increasingly need to become contributing members of application teams rather than siloed specialists off in their own corners. DevOps tend to break down the barriers between IT functions. Understanding how applications work, and, even better, how they deliver business value, puts you in a position to be a creative problem solver and all-around data expert.Data science skills: Machine learning and AI are some of the fastest growing uses of data in the enterprise today.

Share

11

Nov

Build an intelligent analytics platform with SQL Server 2019 Big Data Clusters

In the most recent releases, SQL Server went beyond relational data and enabled support for graph data, R, and Python machine learning, while making SQL Server available on Linux and containers in addition to Windows. At the same time, organizations are challenged with the amount of data stored in different formats, in silos, and the expertise required to extract value out of the data. Through enhancements in data virtualization and platform management, Microsoft SQL Server 2019 Big Data Clusters provides an innovative and integrated solution to overcome these difficulties. It incorporates Apache Spark and HDFS in addition to SQL Server, on a platform built exclusively using containerized applications, designed to derive new intelligent insights out of data.

Modernize your data estate with a scalable data virtualization and analytics platform

Data integration strategies are based on extract, transform, and load (ETL) results in data duplication and transformations that diminish data quality, higher maintenance, and security risks. SQL Server 2019 has a new approach to data integration called data virtualization across disparate and diverse data sources, without moving data. Out-of-the-box connectors for data sources like Oracle, Teradata or MongoDB help you keep the data in place and secure, with less maintenance and storage cost.

Share

07

Nov

https://cloudblogs.microsoft.com/sqlserver/2019/11/07/new-in-azure-synapse-analytics-cicd-for-sql-analytics-using-sql-server-data-tools/Source: https://cloudblogs.microsoft.com/sqlserver/2019/11/07/new-in-azure-synapse-analytics-cicd-for-sql-analytics-using-sql-server-data-tools/     At Microsoft Ignite 2019,weannouncedAzure Synapse Analytics,a major evolution of Azure SQL Data Warehouse.Thesame industry leading data warehousenow provides a whole new level of performance, scale, and analytics capabilities.One of these capabilities is SQL Analytics, which provides READ MORE

Share

06

Nov

State of the SQL Server tools
State of the SQL Server tools

This week we’re announcing the general availability of SQL Server 2019, a significant milestone for Azure Data and for SQL Server customers. This presents a good moment to give an update on the state of tooling for SQL Server.

Since SQL Server 2016, the tools for SQL Server have been released independently “out of box” from the server product. This allows us to be more agile to the needs of our users, get both features and bug fixes shipped more quickly, stay aligned with the more continuous release cycle of Azure SQL, and in general allows the tools team to innovate in exciting ways. However, one side effect is that it can be difficult to understand what’s happening across the tools landscape, as things change quickly in multiple products that are releasing as frequently as every month.

The SQL Server client tools cover the full breadth and depth of the product, and can be broadly categorized as follows:

SQL Server drivers and connectivity APIs, such as Microsoft.Data.SqlClient, ODBC, JDBC, etc.SQL Server tooling APIs and scripting support, including SQL Server Management Objects (SMO), DacFX, and PowerShellCommand line tools for SQL Server like sqlcmd, bcp, mssql-cli, and sqlpackageJupyter Notebooks, a new entrant in this space

Share

05

Nov

https://cloudblogs.microsoft.com/sqlserver/2019/11/05/the-november-2019-release-of-azure-data-studio-is-now-available/Source: https://cloudblogs.microsoft.com/sqlserver/2019/11/05/the-november-2019-release-of-azure-data-studio-is-now-available/     Today we are announcing the November release ofAzure Data Studio is now available. Download Azure Data Studioand review therelease notesto get started. Please note: After downloading Azure Data Studio, say Yes to enabling the preview features READ MORE

Share

05

Nov

SQL Server Management Studio 18.4 and sqlpackage v18.4 generally available

Today we’re announcing the release of SQL Server Management Studio (SSMS) 18.4. This update has full support for SQL Server 2019 capabilities as well as some bug fixes.

You can download SQL Server Management Studio 18.4 today and review SQL Server Management Studio release notes for details.

In addition, we’re also announcing sqlpackage v18.4 is now generally available. This means cross-platform support for sqlpackage is officially generally available.Download the latest release today.

In this blog, you will learn about the new features in these two exciting releases.

SQL Server Management Studio 18.4 featuresGeneral SQL Server Management Studio

SQL Management Objects and scripting

Supports the script of a materialized view in SQL Data Warehouse

Data classification

Added support for a custom information protection policy for data classification

Query store

Added the “Max plan per query” value in the dialog propertiesAdded support for the new custom capture policies

Key bug fixes include:

General SQL Server Management StudioObject ExplorerFixed an issue where dropping an Azure SQL Database in Object Explorer was showing an inaccurate error message.SQL AgentFixed an issue where the agent operator UI would not update the operator name when it was changed in the UI and it wouldn’t be scripted. See the feedback forum to learn more.General SQL Server Management StudioFixed a long

Share

05

Nov

Welcome to the 21st annual PASS Summit
Welcome to the 21st annual PASS Summit

PASS Summit has become an annual pilgrimage for thousands of SQL Server professionals from around the world to join together. My very first demo at PASS Summit was in 2010, and today marks the third time I’ve had the honor of being invited to deliver the day one keynote.

It has been incredible to reflect on how this event continues to support our community, providing unique opportunities for us to learn, connect, and share. The friends we make along the way, the networking and business opportunities that arise out of hallway meetings, the product announcements, and the technical deep dives are all focused on building and supporting the community. Because we are in this with you, PASS Summit provides us with the privileged opportunity to be able to listen to the community. To sit and understand your own firsthand experiences with the products and together embark on a journey of driving the industry forward to meet the expectations of an ever-changing tech landscape.

So to start off, a simple thank you to each one of you for spending the time, money, and energy to be a part of this amazing, open community of data friends and fans. It’s going to be a

Share

04

Nov

Gain intelligence over data with SQL Server 2019, now generally available

Today we’re announcing that SQL Server 2019 is generally available. It’s been an amazing journey with a tremendous response from customers. Ever since we announced preview of SQL Server 2019 at Ignite 2018, it has seen 50 percent more adoption than SQL Server 2017, our highest performing SQL Server release to date.

SQL Server 2019 delivers performance, security, and intelligence over all your data

SQL Server 2019 enables enterprises to gain intelligence over all data types, both structured and unstructured, by combining the power of new big data clusters with enhanced data virtualization. These powerful additions to SQL Server enable enterprises to not only store and query big data at scale but also combine it with structured data in whatever database it may reside such as SQL Server, Oracle, MongoDB, PostgreSQL, and others.SQL Server also includes built-in AI capabilities to enable comprehensive analytics and AI solutions for all your data needs.

Customers like Dr Foster, a Telstra and healthcare analytics company, are delighted to have this capability built into SQL Server 2019.

Dr Foster required a solution that would help limit the amount of data movement, reduce duplication of data sets across the estate, and surface all of our business-critical relational data via a

Share

04

Nov

SQL Server 2019 is now generally available

https://cloudblogs.microsoft.com/sqlserver/2019/11/04/sql-server-2019-is-now-generally-available/Source: https://cloudblogs.microsoft.com/sqlserver/2019/11/04/sql-server-2019-is-now-generally-available/     As you saw from our launch announcement earlier today, over a year ago at Microsoft Ignite we announced our first preview of SQL Server 2019 and today our latest release is now generally available. You have READ MORE

Share

31

Oct

Unify your data lakes with HDFS tiering in SQL Server Big Data Clusters

As the volume and variety of data has risen, it has become more common to store the data in disparate and diverse data sources. A challenge many organizations face today is how to gain insights from all of their data across many different data sources. With SQL Server 2019 Big Data Clusters, through innovative enhancements, were extending the data virtualization capabilities even more with a new feature called HDFS tiering.

HDFS tiering allows you to easily integrate and gain insights from all of your data by accessing unstructured data stored on remote data lakes. This can be done by mounting the remote HDFS/S3 compatible data source to your local HDFS data lake.

This new functionality is Microsoft’s latest major contribution to the Apache Hadoop open source project and will be available in the market first in SQL Server 2019 Big Data Clusters.

Before we look closer at HDFS tiering, lets quickly look at SQL Server Big Data Clusters as a data platform.

SQL Server Big Data Clusters

SQL Server Big Data Clusters is a complete data platform for analytics and AI with a local HDFS data lake built-in for storing high volume and/or unstructured data. In the big data cluster, you can use two different

Share