Category Archives : #SQLServer

16

Nov

SQL Server 2017: A proven leader in database performance
SQL Server 2017: A proven leader in database performance

This post was authored by Bob Ward, Principal Architect, and Jamie Reding, Senior Program Manager and Performance Architect, Microsoft Database Systems Group.

SQL Server continues to be a proven leader in database performance for both analytic and OLTP workloads. SQL Server 2017 is fast, built-in with capabilities and features such as Columnstore indexes to accelerate analytic performance and Automatic Tuning and Adaptive Query Processing to keep your database application at peak speed.

Recently, Hewlett Packard Enterprise (HPE) announced a new world record TPC-H 10TB benchmark result¹ using SQL Server 2017 and Windows Server 2016 on their new DL580 Gen10 Server. This new amazing result at 1,479,748 Composite Query-per-Hour (QphH) was achieved at price/performance of .95 USD per QphH continuing to show SQL Server’s leadership in price and performance.

HPE also announced the first TPC-H 3TB result² on a 2-socket system using SQL Server 2017 and Windows Server 2016 with their DL380 Gen Server. They achieved a stellar 1,014,374 QphH on only 2-sockets. These results continue to show how powerful SQL Server can be to handle your analytic query workloads including data warehouses.

SQL Server also is a proven leader for OLTP workloads. Lenovo recently announced a new world-record TPC-E benchmark

Share

16

Nov

SQL Server 2017: A proven leader in database performance
SQL Server 2017: A proven leader in database performance

This post was authored by Bob Ward, Principal Architect, and Jamie Reding, Senior Program Manager and Performance Architect, Microsoft Database Systems Group.

SQL Server continues to be a proven leader in database performance for both analytic and OLTP workloads. SQL Server 2017 is fast, built-in with capabilities and features such as Columnstore indexes to accelerate analytic performance and Automatic Tuning and Adaptive Query Processing to keep your database application at peak speed.

Recently, Hewlett Packard Enterprise (HPE) announced a new world record TPC-H 10TB benchmark result¹ using SQL Server 2017 and Windows Server 2016 on their new DL580 Gen10 Server. This new amazing result at 1,479,748 Composite Query-per-Hour (QphH) was achieved at price/performance of .95 USD per QphH continuing to show SQL Server’s leadership in price and performance.

HPE also announced the first TPC-H 3TB result² on a 2-socket system using SQL Server 2017 and Windows Server 2016 with their DL380 Gen Server. They achieved a stellar 1,014,374 QphH on only 2-sockets. These results continue to show how powerful SQL Server can be to handle your analytic query workloads including data warehouses.

SQL Server also is a proven leader for OLTP workloads. Lenovo recently announced a new world-record TPC-E benchmark

Share

15

Nov

Announcing SQL Operations Studio for preview
Announcing SQL Operations Studio for preview

We are excited to announce that SQL Operations Studio is now available in preview. SQL Operations Studio is a free, light-weight tool for modern database development and operations for SQL Server on Windows, Linux and Docker, Azure SQL Database and Azure SQL Data Warehouse on Windows, Mac or Linux machines.

Download SQL Operations Studio to get started.

It’s easy to connect to Microsoft SQL Server with SQL Operations Studio and perform routine database operations—overall lowering the learning curve for non-professional database administrators who have responsibility for maintaining their organization’s SQL-based data assets.

As more organizations adopt DevOps for application lifecycle management, developers and other non-professional database administrators find themselves taking responsibility for developing and operating databases. These individuals often do not have time to learn the intricacies of their database environment, making hard to perform even the most routine tasks. Microsoft SQL Operations Studio takes a prescriptive approach to performing routine tasks, allowing users to get tasks done fast while continuing to learn on the job.

Users can leverage their favorite command line tools (e.g. Bash, PowerShell, sqlcmd, bcp and ssh) in the integrated terminal window right within the SQL Operations Studio user interface. They can easily generate

Share

15

Nov

Announcing SQL Operations Studio for preview
Announcing SQL Operations Studio for preview

We are excited to announce that SQL Operations Studio is now available in preview. SQL Operations Studio is a free, light-weight tool for modern database development and operations for SQL Server on Windows, Linux and Docker, Azure SQL Database and Azure SQL Data Warehouse on Windows, Mac or Linux machines.

Download SQL Operations Studio to get started.

It’s easy to connect to Microsoft SQL Server with SQL Operations Studio and perform routine database operations—overall lowering the learning curve for non-professional database administrators who have responsibility for maintaining their organization’s SQL-based data assets.

As more organizations adopt DevOps for application lifecycle management, developers and other non-professional database administrators find themselves taking responsibility for developing and operating databases. These individuals often do not have time to learn the intricacies of their database environment, making hard to perform even the most routine tasks. Microsoft SQL Operations Studio takes a prescriptive approach to performing routine tasks, allowing users to get tasks done fast while continuing to learn on the job.

Users can leverage their favorite command line tools (e.g. Bash, PowerShell, sqlcmd, bcp and ssh) in the integrated terminal window right within the SQL Operations Studio user interface. They can easily generate

Share

15

Nov

Announcing SQL Operations Studio for preview
Announcing SQL Operations Studio for preview

We are excited to announce that SQL Operations Studio is now available in preview. SQL Operations Studio is a free, light-weight tool for modern database development and operations for SQL Server on Windows, Linux and Docker, Azure SQL Database and Azure SQL Data Warehouse on Windows, Mac or Linux machines.

Download SQL Operations Studio to get started.

It’s easy to connect to Microsoft SQL Server with SQL Operations Studio and perform routine database operations—overall lowering the learning curve for non-professional database administrators who have responsibility for maintaining their organization’s SQL-based data assets.

As more organizations adopt DevOps for application lifecycle management, developers and other non-professional database administrators find themselves taking responsibility for developing and operating databases. These individuals often do not have time to learn the intricacies of their database environment, making hard to perform even the most routine tasks. Microsoft SQL Operations Studio takes a prescriptive approach to performing routine tasks, allowing users to get tasks done fast while continuing to learn on the job.

Users can leverage their favorite command line tools (e.g. Bash, PowerShell, sqlcmd, bcp and ssh) in the integrated terminal window right within the SQL Operations Studio user interface. They can easily generate

Share

15

Nov

SQL Server 2017 Features Bring ‘Choice’ to Developers
SQL Server 2017 Features Bring ‘Choice’ to Developers

Data is everywhere today: in the cloud, on premises, and everywhere in between, tied up in systems of nearly endless complexity. Microsoft solutions allow developers to innovate while also scaling and growing their data infrastructure. In SQL Server 2016 SP1, SQL Server made available a consistent programmable surface layer for all its editions, making it easy to write applications that target any edition of the database.  This year’s release takes it a step further with native support for Linux and Docker.

Microsoft puts the needs of the developer front and center in its data solutions. We have created the most advanced set of tools to radically lower the barriers to getting data – of any type, from anywhere – into the application design and build process. Today with the preview of Microsoft SQL Operations Studio, you can now access, run and manage this data from the system of your choice, on Windows, Linux and Docker.

Committed to choice for both database platform and tools

SQL Server 2017 also makes it easier to drive innovation via a CI/CD pipeline with the support of Docker containers.  Since the Community Technology Preview of SQL Server 2017, there have been over 2 million Docker

Share

15

Nov

SQL Server 2017 Features Bring ‘Choice’ to Developers
SQL Server 2017 Features Bring ‘Choice’ to Developers

Data is everywhere today: in the cloud, on premises, and everywhere in between, tied up in systems of nearly endless complexity. Microsoft solutions allow developers to innovate while also scaling and growing their data infrastructure. In SQL Server 2016 SP1, SQL Server made available a consistent programmable surface layer for all its editions, making it easy to write applications that target any edition of the database.  This year’s release takes it a step further with native support for Linux and Docker.

Microsoft puts the needs of the developer front and center in its data solutions. We have created the most advanced set of tools to radically lower the barriers to getting data – of any type, from anywhere – into the application design and build process. Today with the preview of Microsoft SQL Operations Studio, you can now access, run and manage this data from the system of your choice, on Windows, Linux and Docker.

Committed to choice for both database platform and tools

SQL Server 2017 also makes it easier to drive innovation via a CI/CD pipeline with the support of Docker containers.  Since the Community Technology Preview of SQL Server 2017, there have been over 2 million Docker

Share

15

Nov

SQL Server 2017 Features Bring ‘Choice’ to Developers
SQL Server 2017 Features Bring ‘Choice’ to Developers

Data is everywhere today: in the cloud, on premises, and everywhere in between, tied up in systems of nearly endless complexity. Microsoft solutions allow developers to innovate while also scaling and growing their data infrastructure. In SQL Server 2016 SP1, SQL Server made available a consistent programmable surface layer for all its editions, making it easy to write applications that target any edition of the database.  This year’s release takes it a step further with native support for Linux and Docker.

Microsoft puts the needs of the developer front and center in its data solutions. We have created the most advanced set of tools to radically lower the barriers to getting data – of any type, from anywhere – into the application design and build process. Today with the preview of Microsoft SQL Operations Studio, you can now access, run and manage this data from the system of your choice, on Windows, Linux and Docker.

Committed to choice for both database platform and tools

SQL Server 2017 also makes it easier to drive innovation via a CI/CD pipeline with the support of Docker containers.  Since the Community Technology Preview of SQL Server 2017, there have been over 2 million Docker

Share

10

Nov

Making parallelism waits actionable
Making parallelism waits actionable

https://blogs.msdn.microsoft.com/sql_server_team/making-parallelism-waits-actionable/Source: https://blogs.msdn.microsoft.com/sql_server_team/making-parallelism-waits-actionable/   During PASS we announced changes to how users will be able to make parallelism waits more actionable – specifically the “infamous” CXPACKET. This change effectively splits CXPACKET waits into an actionable wait (CXPACKET) and a negligible wait READ MORE

Share

08

Nov

New Showplan enhancements
New Showplan enhancements

https://blogs.msdn.microsoft.com/sql_server_team/new-showplan-enhancements/Source: https://blogs.msdn.microsoft.com/sql_server_team/new-showplan-enhancements/   If you follow this blog, you have seen that in the past few releases we have continuously included a number of diagnostic improvements to Showplan. You can read about some of them here. Looking at the actual READ MORE

Share