Working with Documents in the MongoDB Compass GUI
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the items in the series, click here. Throughout this series, I’ve discussed various ways to work with the documents in a MongoDB collection. If you’ve been following …
[Video] Office Hours in Bulgaria
I went through your top-voted questions from https://pollgab.com/room/brento while in front of the National Gallery for Foreign Art in Sofia. Here’s what we covered: 00:00 Start 03:12 MyTeaGotCold: If all of my columns are nvarchar, is the …
Announcing Free SQL Server Monitoring.
You already use sp_Blitz and the rest of the free, open source First Responder Kit to give your SQL Servers a health check now and then. But let’s be honest: you don’t do it often enough. You wish you had an easier way to know when your bac …
Manage OneLake Storage With PowerShell – Data Engineering with Fabric
Microsoft Fabric has OneLake Storage at the center of all services. This storage is based upon existing Azure Data Lake Storage and can be accessed with familiar tools Previously, we talked about how Azure Storage Explorer and AzCopy both needed manu …
Redgate recommended in Bloor Test Data Management market update
The post Redgate recommended in Bloor Test Data Management market update appeared first on SQLServerCentral.
Docker Logging Guide Part 1: Basic Concepts and Importance
The post Docker Logging Guide Part 1: Basic Concepts and Importance appeared first on SQLServerCentral.
Hot off the press
Every day an avalanche of news hits us from all directions in all kinds of media. So what are the hottest topics people are currently talking about and commenting on? To give you an idea, here’s a selection of technology stories and updates from …
Use “We” Not “You”. #tsql2sday
For T-SQL Tuesday this month, Louis Davidson suggested we give our past self some advice. I’d tell myself, “Use ‘we’, not ‘you’.” For years, when I gave advice, I’d say things like: “You’re do …
It’s a recovery strategy, not a backup strategy
I’ve talked about it before; you shouldn’t have a backup strategy, you should have a recovery strategy. I can’t possibly care if my backups succeed if I’m not bothering to test that they can be restored. And if they can’t …
General program for PASS Summit 2024 now available
The post General program for PASS Summit 2024 now available appeared first on SQLServerCentral.
Meet the new Google AI Assistant Gemini
Introduction to Gemini Gemini’s intro. In the beginning, there was Bard. A powerful language model, crafted by Google AI, it brought forth a new era of communication and understanding. Bard, with its vast knowledge and ability to process information, b …
What does SQL NULL mean and how to handle NULL values
The post What does SQL NULL mean and how to handle NULL values appeared first on SQLServerCentral.
How much Space can I expect to recover from a rebuild after dropping a column?
In my last article – Identify Tables With Dropped Columns – we saw how we can identify tables that have columns that were dropped. Today, we are going to check a way to approximately calculate how much space we can expect to recover if we rebuild our t …
[Video] Office Hours in Sofia, Bulgaria
I was honored to speak at the Present to Succeed conference in Sofia, Bulgaria, run by a former SQL Server MCM. Sofia is a beautiful city, and the gorgeous Patriarchal Cathedral of St. Alexander Nevsky (Wikipedia) was close to my hotel, so I dragged my …
Microsoft Fabric, the Land of Wizards and Trolls
In my previous article (What is Microsoft Fabric All About) I explained what Microsoft Fabric is, how it came about and whether it brings anything new to the data insights domain. In this article, I would like to go a bit deeper into the dark corners o …