article thumbnail

Tuning SQL Server Reporting Services

SQL Performance

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. This article will cover many areas that database administrators need to be aware of in order to properly license, recover, and tune a Reporting Services installation.

Tuning 67
article thumbnail

SQL Server 2017 generally available on October 2nd…

SQL Server According to Bob

Scott Guthrie and Rohan Kumar officially made the announcement today at Ignite that SQL Server 2017 will be generally available on October 2nd, 2017. Andrew Brust also wrote a very nice article detailing out all the great new features that come with SQL Server 2017. Check out ScottGu’s blog post at: [link].

Servers 40
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Experience SQL Server 2017: The Fast and the Furious

SQL Server According to Bob

Please check out a new blog post I created detailing how SQL Server 2017 is Fast, Built-In. How we keep you fast and tuned with Adaptive Query Processing and Automatic Tuning. Look for more details on my blog post and the SQL Server Blog about some of these concepts and new features for performance for SQL Server 2017.

Servers 40
article thumbnail

PostgreSQL vs. Oracle: Difference in Costs, Ease of Use & Functionality

Scalegrid

Compare ease of use across compatibility, extensions, tuning, operating systems, languages and support providers. Recognized as the fastest growing database by popularity, PostgreSQL was named the DBMS of the year in both 2018 and 2017 by DB-Engines, and continues to grow in popularity in 2019. .

article thumbnail

Why Waits Alone Are Not Enough

SQL Performance

Tom Davidson, Opening Microsoft's Performance-Tuning Toolbox SQL Server Pro Magazine, December 2003. Waits and Queues has been used as a SQL Server performance tuning methodology since Tom Davidson published the above article as well as the well-known SQL Server 2005 Waits and Queues whitepaper in 2006.

Tuning 115
article thumbnail

Solaris to Linux Migration 2017

Brendan Gregg

Oracle VM Server is based on Xen. Both Xen and KVM have had many performance and security improvements, and workloads can now be tuned to run at almost bare metal speeds (say, a 3% loss or less). Outside of EC2, many other providers are deploying on KVM. I also wrote and published an entertaining SMF manifest that played music.

article thumbnail

Let’s talk SQL Server to kick off the PASS Facebook Live series

SQL Server According to Bob

I owe a great debt to this community to help me build a brand and reputation for my passion and talks on SQL Server. So bring your questions “all SQL Server” or the Microsoft Data Platform. Follow the PASS Facebook page at [link] to get more updates on how to tune in. Microsoft.