How to Stream Data from Azure Event Hubs into a Fabric Eventhouse
At Microsoft Build 2024, Real-Time Intelligence was announced with the Real-Time hub as its centralized location for all data-in-motion. This shows the commitment of Microsoft to make Fabric your one-stop shop for all things data analytics, both stream …
Thoughts About Stack Overflow’s Annual Developer Survey
Every year, Stack Overflow runs a developer survey about technology, work, community, and more. This year’s results include 65,437 responses from developers around the world. The results are biased towards the kinds of developers who use Stack Ov …
Migrate a SQL Server Database to a PostgreSQL Database
The post Migrate a SQL Server Database to a PostgreSQL Database appeared first on SQLServerCentral.
[Video] Office Hours in a Mexican Hot Tub
While taking a dip in Cabo, I went through your top-voted questions from https://pollgab.com/room/brento. https://www.youtube.com/watch?v=OaHImrIMM6Y Here’s what we covered: 00:00 Start 01:00 OpportunityKnocking: What are your thoughts on when to …
Auditing SQL Server – Part 3 – SQL Server Configuration Audit This is the continuation of my series on auditing SQL Server. In the first part, I discussed basic server discovery and documentation. The next section went over server hardware configuratio …
Query Exercise Answer: Fixing a Slow Computed Column
In last week’s Query Exercise, we added a user-defined function to the Users table to check whether their WebsiteUrl was valid or not. I noted that even with an index on Reputation, SQL Server 2022 simply ignored the index, did a table scan, and …
Announcing New Membership Tiers: Free & Mentoring
I give away a lot of stuff in various places on the internet: videos, scripts, the new free tier of SQL ConstantCare®, and I’ve got more tricks coming soon. But until now, it’s been kind of a hassle because they’ve been scattered all …
Index cleanup : Harder than it looks
I’m not the first person to write about cleaning up unused or redundant indexes. You can read many articles about how non-clustered indexes are expensive to store and maintain, that they can occupy valuable space in memory, and that they can nega …
How to use Jupyter Notebook in VSCode
Introduction Visual Studio Code (VSCode) is a free code editor used by many programmers. In this article, we will show how to integrate VSCode with Jupyter Notebook. Also, we will learn how to use markdown code to comment on our code in VSCode. What is …
Using Query Store to Identify CPU Intensive SQL Queries and Creating Proper Indexes
The post Using Query Store to Identify CPU Intensive SQL Queries and Creating Proper Indexes appeared first on SQLServerCentral.
An Introduction to Frappe Framework: Features and Benefits
Frappe is a full-stack, battery-included web framework with MariaDB as the database, written in Python and JavaScript. Frappe is a “batteries included” framework because it equips developers with a comprehensive suite of features for buildi …
Today’s a Good Day to Talk to Your Manager About Disaster Recovery.
Last night, two major IT disasters struck: Microsoft Azure’s Central region went down for about 4 hours. The official post-mortem isn’t out yet, but rumor has it that while decommissioning legacy storage services, the product group deleted …
Notebook Jobs in Azure Data Studio
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles on how the tool works, and this one continues the series. In this article, I want to look at the way Notebook jobs can be created in Azure Data Studio …
[Video] Office Hours in My Backyard
On a pleasantly mild morning, I sat down on the patio and took your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:56 MyTeaGotCold: When going in to a database blind, do you worry at all ab …
Query Exercise: Fix This Computed Column.
Take any size of the Stack Overflow database and check out the WebsiteUrl column of the Users table: Sometimes it’s null, sometimes it’s an empty string, sometimes it’s populated but the URL isn’t valid. Let’s say that alo …