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

DBTA – PASS Summit 2019 and SQL Server 2019

The annual PASS Summit, the industry’s largest gathering of SQL Server professionals, hosted more than 4,000 attendees in Seattle recently recently. PASS (www.pass.org) has grown to more than 300 local chapters around the world, and its 1,000th SQL Saturday will likely be held sometime in early 2020. The opening keynote by Rohan Kumar, corporate vice president of data and AI at Microsoft, focused on the achievements and growth of SQL Server in the marketplace, as well as on the new features and capabilities now available in the public release of SQL Server 2019. (Details about the keynote are … [Read more...]

Virtualizing SQL Server: Strategies and Best Practices

SQL Server virtualization is an expectation today, including for mission-critical systems. In its first decade of implementation, virtualization was rare for database workloads. However, virtualization is largely defacto across medium- and enterprise-sized business in the USA and around the world. Despite widespread adoption by more than 60% of medium and big business, some businesses remain nervous about taking on a SQL Server virtualization project, largely because of performance concerns and unfamiliarity. But we’re here to help! With proper planning, use of best practices, and … [Read more...]