Most Overlooked Features in Power BI
The post Most Overlooked Features in Power BI appeared first on SQLServerCentral.
Introducing the MongoDB Document
MongoDB is a document database. As such, the data is stored as individual documents. A document is a data structure made up of one or more field/value pairs. Nearly everything you do in MongoDB is either directly or indirectly related to the documents …
The Annual Data Professional Salary Survey Closes This Week!
Take the Data Professional Salary Survey now. The 2020s have been tough: a pandemic, a recession, layoffs, and inflation. Inflation makes things particularly tricky because your costs for everything have risen a lot in the last year, but at the same ti …
Building Reports with Power BI vs Tableau from SQL Server Data
The post Building Reports with Power BI vs Tableau from SQL Server Data appeared first on SQLServerCentral.
Docker Security Principles Overview
The post Docker Security Principles Overview appeared first on SQLServerCentral.
Creating a Hyperscale Database in Azure Using the Azure Portal
Data is the lifeblood of contemporary enterprises in the digital age. Managing and growing databases to fulfill these demands is a continuous challenge as data quantities increase exponentially. Microsoft’s innovative response to this problem—Azure Hyp …
[Video] Office Hours: 21 Good Questions
This one is a 3-part episode: I take 21 questions from https://pollgab.com/room/brento and then later, work on First Responder Kit pull requests. Here’s what we covered: 00:00 Start 01:08 MooneyFlyer: Hey Brent, apart from installing and playing …
Counting more efficiently
Nearly a decade ago, I wrote a post called “Bad habits : Counting rows the hard way.” In that post, I talked about how we can use SQL Server’s metadata to instantly retrieve the row count for a table. Typically, people do the followin …
[Video] Office Hours: Wrong Side of the Bed Edition
I woke up on the wrong side of the bed after a nap. How does that even happen?!? To take the edge off, I poured myself a gin & tonic and went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 …
Sending resource alerts on Managed Instance using db_mail
The post Sending resource alerts on Managed Instance using db_mail appeared first on SQLServerCentral.
Why Don't You Upgrade in Place?
Ask a senior-level SQL Server or Windows administrator about doing in-place upgrades and you’ll likely get a negative response ranging from « that’s a bad idea » to a puzzled look and a polite scoff. To someone with less experience or a higher-level view …
Interesting Aurora MySQL Feature: The Buffer Pool Survives Restarts
“Documentation! Hey, look at that.” Lemme start this off by saying this is probably irrelevant to you. (It’s irrelevant to me, too.) If you’re strapped for time, just skip past this blog post. This one’s for the curious fo …
Le DataOps pour Power BI et Microsoft Fabric
Petit article de retour sur un événement communautaire du Club Power BI Les communautés sont des groupes de personnes qui se retrouvent pour discuter et apprendre ensemble. Elles sont passionnées par un sujet et elles ont envie et besoin de partager de …
Using a SQL Tokenizer
Imagine this: you have several directories full of SQL script files, and you need to know where a certain table is used. You’d rather like the context too, so you can check the whole SQL Expression and work out why it is running so slowly. Maybe, …
Configuring an SSIS ForEach Loop for Multiple File Types
The Problem The SSIS Foreach Loop component has a limitation when it comes to selecting different sets of files from a folder, for example, it can be easily configured to loop through TXT files or PDF files or even all types of files by setting the Fil …