How to Set Up Microsoft Fabric Database Mirroring for Azure Cosmos DB
Microsoft Fabric is a new centralized, SaaS data analytics platform which has been generally available since November 2023. It offers different types of analytical workloads, such as batch processing with Spark (in either a lakehouse or a warehouse) or …
Identify Tables With Dropped Columns
In my last article – What happens when we drop a column on a SQL Server table? Where’s my space? – I have shown what happens when we drop a column from a table. Today, we are going to check if we have a way to find tables with dropped columns. Why? As …
Sails.js for web development
Sails.js is a robust web development framework that runs on top of Node.js and uses JavaScript’s asynchronous features to speed up the production of applications. Its adherence to the Model-View-Controller (MVC) architecture, which simplifies fea …
Suivi en temps réel de ma production solaire et de ma consommation électrique avec Microsoft Fabric
Microsoft Fabric is a cloud-based platform that lets you, among other Data Activity, stream, analyze, and visualize data from different sources, such as sensors, smart meters, or IoT devices. Since last Microsoft May 2024 events Real-Time Intelligence …
[Video] Office Hours in a Hotel Room
While in Nashville for a creators conference, I went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:38 Bisal Basyal: What is the best way to manage roles in sql server in Azure VMs (m …
Auditing SQL Server – Part 1 – Discovery and Documentation
Inheriting a server, whether as an inexperienced user or an experienced DBA, has many challenges. It’s very helpful to evaluate the servers, document issues, and record the current configuration. It can also be beneficial to evaluate the current …
The signs of a new era: Prompt Injection
More than 20 years ago, I wrote a book about SQL Injection and how dangerous it can be. Probably you can still find some sites suffering with this problem, but it’s not usual anymore (I hope so). We are in the AI era and a new era brings new prob …
Two Tweaks for Faster Backups with Ola Hallengren’s Scripts
Ola Hallengren’s free maintenance solution is widely used as a replacement for SQL Server maintenance plans. It’s a more powerful, flexible tool for backups, corruption checking, and index & statistics updates. If you’re using it …
WITspiration – Year 2
The post WITspiration – Year 2 appeared first on SQLServerCentral.
Basic Always On Availability Groups in SQL Server Standard
Introduction In this walkthrough, we will be setting up a Basic Availability Group in SQL Server Standard edition as a base for HA. This is a group of SQL servers that work together to ensure high availability of applications and services. Any HA platf …
Who’s Hiring in the Microsoft Data Platform Community? June 2024 Edition
Is your company hiring for a database position as of June 2024? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must inclu …
Effective Strategies for Storing and Parsing XML in SQL Server
XML is a common storage format for data, metadata, parameters, or other semi-structured data. Because of this, it often finds its way into SQL Server databases and needs to be managed alongside other data types. Even though a relational database is not …
Bridging Snowflake and Azure Data Stack: A Step-by-Step Guide
In today’s era of hybrid data ecosystems, organizations often find themselves straddling multiple data platforms for optimal performance and functionality. If your organization utilizes both Snowflake and Microsoft data stack, you might encounter the n …
Powershell and SQL on the River
We are having a conference in Chattanooga, TN on Aug 16 and 17, the primary topics of which are clearly in the name of the conference! We have 3 tracks, and one of the tracks is for ANY topic (technical/professional is probably better, but I am excited …
[Video] Office Hours: 16 Questions
Like Sixteen Candles, but different: I go through your top-voted questions from https://pollgab.com/room/brento. Strangely, my video and audio is ever so slightly out of sync in this episode. 00:00 Start 01:26 GuaroSql: Hey Brent! How are you? It is ne …