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

Why Design Impacts Performance on Microsoft SQL Server

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

Top 10 SQL Server Mistakes Made by DBAs

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

Top 10 SQL Server Mistakes Made by DBAs

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

Rightsizing Your Cloud Consumption on AWS

Running SQL Server workloads in the cloud can yield tremendous price/performance benefits, but dialing in the optimal cloud consumption model can be a challenge. I recently moderated an MSSQL Tips webinar, entitled Rightsizing Your Cloud Consumption on AWS. In the webinar, SentryOne Solutions Engineering Manager, Denis McDowell, and AWS Partner Solutions Architect, Tom Staab, shared guidance to help attendees optimize their cloud resource consumption on the AWS platform. Click HERE to read more. … [Read more...]

Data Modeling & Database Design for Developers

The classic standards of database design and normalization are a “gold standard” that many developers struggle with, either because they: Don’t know what the standards areDon’t want to apply them to their designs because they seem old-fashionedAre handed an application that has an already completed but inadequate designI recently teamed up with Louis Davidson (@drsql), a renowned Microsoft MVP and data architect specializing in relational database design with SQL Server, for the SentryOne webinar, “Data Modeling & Database Design for Developers.” Click HERE to read more. … [Read more...]

DBTA – A New Chapter of Business Intelligence Begins with Azure Synapse

I’ve been working with Microsoft business intelligence products since their official inclusion in the product line back in the days of SQL Server 7, around 1998. From that time forward, the business intelligence line of products has seen periods of greater or lesser innovation according to Redmond’s strategic plan. Lately, we’re in an upswing. In late 2019, Microsoft brought forth its latest iteration of its business intelligence tools, Azure Synapse Analytics. With this release, Microsoft further aligned and clarified its capabilities for handling data warehousing, data lakes, data pipelines, … [Read more...]

Join Me at These SQL Server Events in December 2019

Hi friends. Just because it’s the end of the year doesn’t mean things are slowing down. If you are close by, I encourage you to come to see me at one of these three upcoming events: Click HERE to read more. … [Read more...]