Choosing Between the Lakehouse and Warehouse in Microsoft Fabric
Microsoft Fabric is a new centralized, AI-powered cloud data platform hosted by Microsoft. It combines several services of the existing Azure Data Platform – such as Azure Data Factory – with Power BI, while also introducing new services. I …
Concepts and Issues in Test Data Generation
Data generation is the science and art of providing data for database development work that is as realistic and controllable as possible. The skills of generating realistic data are an essential part of being a database developer. It is important: you …
How to Sort String Date Values on a Power BI Slicer Visual
The post How to Sort String Date Values on a Power BI Slicer Visual appeared first on SQLServerCentral.
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 …