Unpivoting Multiple Sets of Columns in SQL Server using CROSS APPLY
The post Unpivoting Multiple Sets of Columns in SQL Server using CROSS APPLY appeared first on SQLServerCentral.
[Video] Office Hours: Brent’s Cursed Technology Edition
I first answered these while standing at a harbor in Maine, but upon arriving home, I realized my camera had failed to record any audio. Doh! So I took the list of questions from https://pollgab.com/room/brento and streamed ’em from my home offic …
Source Control with GIT, Power BI and Microsoft Fabric
Source control is fundamental when dealing with projects and sharing code between multiple developers. Power BI present some challenges related to source control. But it’s finally providing us with a solution to these challenges. Let’s anal …
What is Microsoft Fabric all about?
In this article, we will introduce Microsoft Fabric and how it relates to Power BI Premium Capacity we will turn to the mechanics of capacity utilization, and we will briefly look at how to monitor the performance loads of our Fabric resources. In a fu …
[Video] Office Hours in Camden Harbor
On an overcast morning in scenic Camden, Maine, I stood on the docks and took your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:54 Alma Fahlstrøm: Does index fragmentation matter with column sto …
Advanced SQL Server installation using Powershell DSC
Introduction In the previous article, we learned how to install a SQL Server instance with basic parameters like InstanceName, Features, SourcePath, SQLSysAdminAccounts, etc using Powershell DSC. In this article, we’ll discover how to enhance our SQL S …
Azure DocumentDB: Working with Microsoft's NoSQL Database in the Cloud
The post Azure DocumentDB: Working with Microsoft's NoSQL Database in the Cloud appeared first on SQLServerCentral.
Back home from the PASS Data Community Summit
What a week it was. While it wasn’t my first in person conference this year, it felt different. For the past 20+ years, the Summit has been one of the standard parts of my year. It was always marked on my calendar as where I would be, and for yea …
Why Haven’t You Disabled SA? Wrong Answers Only.
On social media, I asked folks, “Why haven’t you disabled the SA account in your SQL Servers? Wrong answers only.” The results were pretty funny: “I went a step further and also created an account called ‘as’. Now my …
Strategies for queries against bit columns
Recently someone posted a question where they couldn’t quite figure out how to construct a predicate based on a bit parameter. They tried to write a procedure like this, which wouldn’t parse, of course: CREATE PROCEDURE dbo.whatever @flag b …
“How do my peers do this?” The latest best practices for IT architects implementing a major business initiative
The post “How do my peers do this?” The latest best practices for IT architects implementing a major business initiative appeared first on SQLServerCentral.
What are Warehouses in Microsoft Fabric?
The post What are Warehouses in Microsoft Fabric? appeared first on SQLServerCentral.
PASS Summit 2023 – Community Keynote – AIOps and ChatGPT – Prepare to Ride the Next Wave
Last but not least, the Community Keynote. Hang on to your hats, this is going to be an interesting ride! President/Founder of SQL Skills – Kimberly Tripp Surprised people make the Friday keynote. Agreed. This is hard and exhausting! On day to go …
Is your organization using MongoDB? Help the Redgate Flyway team understand your pain points.
The post Is your organization using MongoDB? Help the Redgate Flyway team understand your pain points. appeared first on SQLServerCentral.
How to get your security team on board with your cloud migration
The post How to get your security team on board with your cloud migration appeared first on SQLServerCentral.