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...]

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...]

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...]

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 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...]

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...]

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...]

Did you know that when creating a Microsoft SQL Server database application, certain design choices can hurt its performance? In a recent SentryOne webinar, I shared common Architectural Choices That Impact Performance. If you’re a DBA, do you have scripts you can run to perform these checks? If you’re a developer, do you know which common design choices are actually pitfalls? If your answer is “no,” this webinar can help. Click HERE to read more … [Read more...]

SQL Server DBAs—even those who have years of experience with relational databases—frequently make the same mistakes repeatedly. Wouldn’t you like to learn about those blunders so that you can sidestep them? Well, I have good news! In a recent webinar, I counted down the 10 most common SQL Server mistakes DBAs make. Read below as I recap the full list and share helpful resources for avoiding these common missteps. Click HERE to read more … [Read more...]

SQL Server DBAs—even those who have years of experience with relational databases—frequently make the same mistakes repeatedly. Wouldn’t you like to learn about those blunders so that you can sidestep them? Well, I have good news! In a recent webinar, I counted down the 10 most common SQL Server mistakes DBAs make. Read below as I recap the full list and share helpful resources for avoiding these common missteps. Click HERE to read more. … [Read more...]