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 …
FOR XML PATH Changed The Way I Think About T-SQL #TSQL2sday
The first time I saw FOR XML PATH being used to generate a comma-delimited list, I think I stared at it, shook my head to clear the cobwebs, stared at it some more, and then closed the code editor thinking it was complete witchcraft. And that same thin …
The GROUP BY Clause
When you’re learning SQL DML, the most complicated clause is typically the GROUP BY. It’s a fairly simple grouping based on values from the FROM clause in a SELECT statement. It’s what a mathematician would call an equivalence relatio …
Influencing Successful Cloud Transformational Change
The post Influencing Successful Cloud Transformational Change appeared first on SQLServerCentral.
Enterprises that adopt Database DevOps save an average of $4.3M per year (Video)
The post Enterprises that adopt Database DevOps save an average of $4.3M per year (Video) appeared first on SQLServerCentral.