DBTA – Azure Cosmos DB Adds Features and Free Tier

I’ve kept you informed over the years about not just the latest news and features in SQL Server, but across the entire Microsoft Data Platform, both on-premise and in the cloud This includes additional products such as SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and their cloud siblings, Azure Synapse Analytics, and Azure Data Factory (ADF). Another important and powerful sibling product is Azure Cosmos DB, previously dknown as Document DB, which I first wrote about here many years ago. WHAT IS COSMOS DB? Click HERE to read more … [Read more...]

SQL Server 2008 End of Life: What Are Your Support Options?

It’s no secret that Microsoft wants us to move off old and unsupported versions of SQL Server. It’s good for their bottom line. But it is definitely not simply a money grab To be hones, as a Mdicrosoft Data Platform MVP and an independent software vendor (ISV), I also want you to move off old, unsupported versions of SQL Server. Why, you might ask? For the same reasons that Microsoft does from a technical perspective—supporting a never-ending parade of software versions makes life harder and harder. Consider the test matrix for ISVs to ensure that their app can work for both old and new … [Read more...]

Join Me for Office Hours, Online Learning, and Conversation

After some internal conversations last week, the rest of the SentryOne team and I decided to kick it up a notch with more knowledge sharing and more opportunities for conversation and fellowship. With all the stress of the global pandemic, I look forward to a bit of extra carousing and kibitzing with y’all. Announcing Monthly Open Office Hours Click HERE to read more … [Read more...]

Webinar Recap: SQL Server Indexing for Developers and Accidental DBAs

Have you been tasked with making queries run faster? Indexes can often help with query performance, but do you know where to start. Good news! I recently participated in a SentryOne webinar with SQL Server expert, Sebastian Meine, Ph.D., on "SQL Server Indexing for Developers and Accidental DBAs."  Click HERE to read more … [Read more...]

Webinar Recap: Introduction to SQL Server Query Tuning

If you find yourself asking questions like, "How do I know if a query is running efficiently?" or, "What metrics and indicators tell me when a query is misbehaving?" then you need to watch my recent webinar Introduction to Query Tuning During the webinar, I walked through how to assess query performance, guarantee a consistent query tuning process, and avoid common performance killers in SELECT statements running on Microsoft SQL Server and Azure SQL Database. I demonstrated query tuning with both SSMS and the free SentryOne tool, Plan Explorer. Click HERE to read more … [Read more...]

Book a SentryOne Database Expert to Speak at Your Virtual Meeting

We’re all doing the best we can in this time of global pandemic. Times are tough, both from a health and economic point of view. On behalf of everyone here at SentryOne, I want to take a moment to encourage you that we will get through this. It will not be easy. And the aftershocks of this once-in-a-century event will reverberate for a long time to come. Despite all the difficulties, we do have a few things to be thankful for, such as the fact that as IT pros, much of our work and learning can take place online. Expert Speakers and a Vast Library of Topics Click HERE to read … [Read more...]

SQL Server Troubleshooting Horror Stories and Lessons Learned

If you spend any time with veteran SQL Server DBAs, you’ll hear troubleshooting horror stories that will make you cringe. I recently moderated a two-part SentryOne webinar, “SQL Server Troubleshooting Horror Stories and Lessons Learned,” which included a panel of renowned industry thought leaders from SQLskills: Paul Randal, Kimberly Tripp, Jonathan Kehayias, Erin Stellato, and Tim Radney.  Also lyrica help me how to order pregabalin Click HERE to read more … [Read more...]

Webinar Follow-Up: Top 5 SQL Server Challenges Automated with PowerShell

Webinar Recap The dbatools.io team and I held a webinar on PowerShell for the DBA, which offers unique scalability and programmatic control for just about any buy generic androgel workflow on Windows OS or supported versions of Linux. The webinar was a panel format and included experts such as dbatools.io leader Chrissy LeMaire, and contributors Sander Stad, Rob Sewell, and Kirill Kravtsov. Click HERE to read more … [Read more...]

Introduction to SQL Server Internals and Architecture

New appliances and gadgets typically come with instruction manuals, but let’s be honest—who reads those? It’s true that you can probably figure out how to operate a new appliance without the manual, but it might reveal hidden features or tips for optimal use that you wouldn’t have known about otherwise. The same holds true for SQL Server. You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works. In fact, many great developers, DBAs, and designers get their daily work completed on time and with reasonable quality while never really … [Read more...]

DBTA – Azure Arc and the Rising Tide of Kubernetes

At first glance, a new product billed as part of the Azure Man­agement platform might not seem interesting or relevant for data management professions. But as you will see, if your organiza­tion is using or thinking about using Microsoft Azure, then this is important news for you. A FOUNDATION OF CONTAINERS EXPANDS WITH KUBERNETES I first wrote about Docker containers and Kubernetes in the February/March 2019 issue of DBTA. To summarize, containers are somewhat akin to virtual machines (VM), but they are smaller, faster, and less resource-intensive than a VM running the same … [Read more...]