The next release of Microsoft SQL Server, announced as SQL Server 2017, is available for download in CTP2 at http://tinyurl.com/SQLvNextLinux and offers many cool new features. One set of features that I really like focus on adaptive query processing. These new features speed processing of workloads, especially those that have historically been the hardest to tune. Click HERE to read more … [Read more...]
DBTA – They Did it Again: The Release of SQL Server 2017
May 5, 2017 by Leave a Comment
Not only has the Microsoft SQL Server engineering team added more and stronger leadership, outstanding individual engineers and staff members, but it is also radically moving its entire development process into a "cloud-first" ethos. Now, I'd like to show one of the most salient results of this new development process-accelerated product releases. It was only a few years ago (and is still the case for other data management platforms) that a major new release takes at least 2, but more likely 3 years. With the "production-ready" release of SQL Server 2017 Community Technology Preview 2.0, we … [Read more...]
DBTA – Surprising but True: The Basics are Still Difficult
April 7, 2017 by Leave a Comment
I always look forward to new research from Unisphere Research, a division of Information Today, Inc., publishers of this magazine and other great products for data professionals. The latest report which you should read is "SQL Server Transformation: Toward Agility & Resiliency 2017; PASS Database Management Survey." Click HERE to read more … [Read more...]
Testosterone Undecanoate Injection buy generic Nebido
March 2, 2017 by Leave a Comment
Nebido is a trademark of the original drug under the active substance testosterone undecanoate which is sold under a different brand in India called Cernos Depot which is produced by Sun Pharma, this company has been producing medical preparations for 30 years and has established itself in the global pharmaceutical market. Our suppliers are deeply connected to this company and can guarantee a quality product and protection against counterfeits. An analogue of Nebido called Cernos Depot is available in injections with a dosage of 1000 mg/4ml. Buy Nebido Online … [Read more...]
How Can the SQL Server Resource Governor Help You?
February 10, 2017 by Leave a Comment
MANAGING ‘NOISY NEIGHBORS’ IN SQL SERVER If you've been managing databases for any length of time, you've probably had to contend with the "noisy neighbors" scenario. In this scenario, you have several applications, each with their own database residing on a single instance of SQL Server, which don't share the resources of the server nicely. To deal with this issue, you might want to investigate Resource Governor as an alternative. READ MORE... Originally Posted in DBTA Magazine in June 09, 2015 … [Read more...]
DBTA – Introducing the SQL Server Database Experimentation Assistant
February 8, 2017 by Leave a Comment
There's a very handy new tool from Microsoft called the Database Experimentation Assistant (DEA). The DEA makes it very easy to conduct A/B testing for SQL Server upgrades, providing quantitative insight into the performance differences across two versions of a database workload on SQL Server. Click HERE to read more … [Read more...]
Learn More About the SQL Server Cardinality Estimator
January 27, 2017 by Leave a Comment
COOL FEATURES OF SQL SERVER 2014: IMPROVED CARDINALITY ESTIMATES With all the cheerleading and the steady drumbeat of new features being released to Azure, it's easy to lose track of the many cool and valuable new features released in the on-premises version of SQL Server. One of the crown jewels of SQL Server, the cardinality estimator (CE), underwent a large redesign for SQL Server 2014 to improve performance. Cardinality estimates are an extremely important part of query processing. In a nutshell, cardinality estimates are what the relational engine predicts for the number of rows affected … [Read more...]
DBTA – Major Feature Reconfiguration for SQL Server 2016 Service Pack 1
January 3, 2017 by Leave a Comment
One of the long-standing differentiators between SQL Server's Enterprise Edition (EE) and Standard Edition (SE), besides price, were the large number of features available only in EE. This is also true for other lower editions of SQL Server such as Web Edition and Express Edition. But there's big news in the air! Click HERE to read more … [Read more...]
DBTA – Here’s What You Missed at the Biggest Annual SQL Server Conference, PASS Summit 2016
December 5, 2016 by Leave a Comment
If you are a SQL Server professional, but you don't know about the PASS Summit, then you are missing out. The annual conference is convened every fall in downtown Seattle, the backyard of Microsoft, and attracted over 6,000 attendees this year. And, since it's so close to the Microsoft Redmond campus, hundreds of the SQL Server developers and program managers get to attend—answering user questions, delivering sessions, and presenting chalk talks and panel discussions. Click HERE to read more … [Read more...]
Get All of the Freebies for “End-to-End Troubleshooting Checklist for Microsoft SQL Server”
December 5, 2016 by 2 Comments
The Presentation: Slides, TSQL-Scripts, and Video One of my most enduring and popular presentations is called End-to-End Troubleshooting Checklist for Microsoft SQL Server". In this presentation, I take you through my six-step checklist from detection of a performance issue on SQL Server through identification of the root cause to remediation and finally post-mortem steps to ensure the problem is prevented (or at least detected immediately) in the future. Over the years, I've had many inquiries about the slides, T-SQL scripts, and additional troubleshooting information. I'm happy to … [Read more...]
