SQL ConstantCare® Population Report: Summer 2023
The short story for this quarter: SQL Server 2022 adoption rates have stalled, even backtracked, and it doesn’t appear to be due to the cloud, either. For the long story: ever wonder how fast people are adopting new versions of SQL Server, or wha …
A Beginners Guide to MySQL Replication Part 3: Multi-Source Replication
Welcome back to the world of MySQL Replication! If you’ve been following this series, thank you for your support! And if you’re new here, welcome! Before we dive in, I suggest checking out the first part of the series to get up to speed. In …
Free Azure Networking Training This Week
To celebrate this month’s launch of our new class, Fundamentals of Azure Networking for the Data Professional, we’re making one video a day completely free. Here’s what’s on tap this week: July 17: Demo: Using Virtual Networks f …
Managing Test Data for Database Development
In coming up with a strategy for managing test data, first you need to understand what the many test requirements are likely to be for the particular database you are developing. Next, you need to create all the different categories of test data requir …
Power BI Data Gateway to Connect Data Sources in the Cloud and On-Premises
The post Power BI Data Gateway to Connect Data Sources in the Cloud and On-Premises appeared first on SQLServerCentral.
Building a Database Dashboard with SSRS
A database dashboard is a graphical user interface (GUI) that summarizes the key performance indicators (KPIs) for a SQL Server database. It presents the data in a visually appealing format, such as charts, graphs, tables, and other types of visualizat …
Using Power BI to Analyze My Travels
As a data professional, I have some fun with data in my life. I like numbers, and I like tracking things. I’ve written posts about my year in numbers, and recently noted the states I’ve visited. Like many of you, I’ve sometimes used this data to practi …
Sample Use Case for Using SQLCMD Utility Batch Files
The post Sample Use Case for Using SQLCMD Utility Batch Files appeared first on SQLServerCentral.
PostgreSQL 101: The journey towards PostgreSQL – tips and lessons from Grant Fritchey
The post PostgreSQL 101: The journey towards PostgreSQL – tips and lessons from Grant Fritchey appeared first on SQLServerCentral.
It’s Only Summer, but I am ready for PASS Data Community Summit Now!
The PASS Data Community Summit 2023 happens the week of November 12 in Seattle. WA. It will be my first time back in Washington state since 2019. Skipping over the years that the Summit didn’t meet in person (I missed last year’s in-person …
[Video] Office Hours: 30 Minutes of Rapid-Fire (And a Little Burnination)
Almost all of today’s questions from https://pollgab.com/room/brento were great! Well, except two. Here’s what we covered: 00:00 Start 02:13 Andrei: What’s the appropriate response/punishment for developers who insist on storing json …
Free Azure Networking Training This Month!
Raise your hand if you’ve ever blamed the network. You’re responsible for the health, security, and uptime of your company’s data services in Azure. You’ve provisioned a few services, but every now and then, you run into problem …
What Counts for a DBA – Discretion
I was looking at the list of topics I have talked about in my “What Counts for a DBA” posts over the years, and a topic really stood out as a topic I have not touched. To be fair, it is really the most essential aspect. One aspect that, if …
PASS Data Community Summit
The post PASS Data Community Summit appeared first on SQLServerCentral.
Let Your Data Do the Talking with PowerPoint Plus Power BI
What is this about This article will be about Power BI and PowerPoint collaborating. Both tools are well-known to anyone, particularly to those who are presenting data, charts and visualizations. Without a doubt, these are powerful tools for communicat …