SSMS v21: Dark Mode, Git, Vertical Tabs, and More
SQL Server Management Studio v21 Preview 1 is out and let’s give it a quick whirl. It’s installed with the Visual Studio installer. That doesn’t mean Visual Studio is installed or required – it’s not – it’s jus …
KQL: The top of a group in an easy way
When learning something new, we always compare it with what we know. In this case, we end up comparing KQL with SQL. In SQL, when we need to get the top rows based on a grouping, the process is not easy. For example, let’s say that in a table con …
Ingesting Data From REST API endpoints: Data Engineering with Fabric
Representational State Transfer (REST) is a software architectural design that has been employed throughout the software industry to create stateless web applications. An application that adheres to the REST may be informally described as RESTful. Thi …
Relationships with Microsoft Fabric GraphQL API
The post Relationships with Microsoft Fabric GraphQL API appeared first on SQLServerCentral.
T-SQL Tuesday #180 – Good enough is perfect
Today’s post is in reply to the invitation post, Josephine Bush asks the question: “How do you get to good enough and not burn yourself out with perfect?” As an editor, I read this question and I love it, but I am reminded of the Seinfeld episode calle …
Copilot in SSMS is Kinda Like IE in SSMS
You are not ready for how weird my take is. Last week at the PASS Summit conference in Seattle, Microsoft showed off the upcoming SQL Server Management Studio v21. One of the most intriguing features is that it has Copilot built in. No, not Github Copi …
Data Control Language (aka Security)
Like ancient Gaul, SQL is divided into three sub- languages. The DDL (Data Declaration Language) declares the data. This is where we find the data types, constraints, references and other structures that have to do with how the data stored . The DML (D …
[Video] Office Hours: SQL Server Questions and Answers
That face I’m making in the video thumbnail is priceless. YouTube randomly picks these, and I laughed out loud at this one. Anyhoo, let’s get to answering your top-voted questions from https://pollgab.com/room/brento: Here’s what we c …
A Tidy Database is a Fast Database: Why Index Management Matters
Everyone knows that indexes make databases faster, well not everyone as I once came across a team that wouldn’t apply « complex indexes »; which for them was an index with more than one column, but you get the point. Indexes are great, but they can also …
Demystifying Continuous Integration vs. Continuous Delivery: Part 2
Welcome to part 2 of our Demystifying Continuous Integration vs. Continuous Delivery series. In Part 1 of the series, we covered the basic concepts involved in continuous integration and continuous delivery. We also covered the primary objectives of CI …
Office Hours in the Valley of Fire
I took the Graffiti Gulf 356 out to the Valley of Fire State Park to exercise it, and took your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:39 mailbox: Hey Brent! I’m really enjoying your …
Step by step guide to setup PostgreSQL on Docker
Introduction PostgreSQL is a powerful open-source relational database management system with robust features for handling large datasets and supporting complex queries. While there are many ways you can install the PostgreSQL database on your laptop di …
Frappe and ERPNext: Leveraging ERP Capabilities for Business Solutions (Part II)
In the previous article (here) touched on the overview of Frappe and ERPNext and how they’re connected. We also learnt that ERPNext can be leveraged to solve challenges in business with a suite of tools at our disposal. We’ll continue with using Frappe …
PASS Keynote – Day 2 – Redgate
Time to start! Annabel Graham (Head of events at Redgate) comes out on stage Intro Annabel takes the stage and for me she is the face of Redgate at PASS, what better person to kick off the Redgate Keynote! Annabel has been a Redgater for 15 years and …
Data Chouette – 1 an déjà !
1 – Genèse Cela fait presque un an que nous avons lancé la chaîne Data Chouette ! Mon article Lancement de la chaîne YouTube Data Chouette date du 29 Janvier 2024 : – “ L’idée est de vulgariser, de mettre en avant ou de présenter des sujet …