Getting Out of Character
Pre-Unicode Younger programmers have grown up with ASCII and Unicode as the only ways of representing character […]
Archives du mois : février 2023
Getting Started with Azure SQL Bindings: Part 1
Expanding on the excellent post by Drew Skwiers-Koballa; Developing with Azure SQL bindings and Azure SQL trigger for […]
Can You Nest Transactions in SQL Server?
To find out, let’s set up a simple status log table: DROP TABLE IF EXISTS dbo.StatusLog; CREATE TABLE […]
Top 25 SQL Server Engine Errors Based on support case ...
About 6 months ago we decided to look at what SQL Server engine error messages are most commonly […]
[Data Virtualization] May need to update Java (JRE7 only uses ...
At end of October 2022 we saw an issue where a customer using PolyBase external query to Azure […]
Event exceeds the number of allowable bound actions
Did you know that there is a limit to the number of actions you can add to a […]
SQL Server 2022 : Database Ledger
Database ledger : découvrez cette nouvelle fonctionnalité de sécurité de SQL Server 2022. Basée sur la technologie de […]
How to create a Sankey Chart in Power BI Desktop
The post How to create a Sankey Chart in Power BI Desktop appeared first on SQLServerCentral.
How to Forecast Data in Power BI
Introduction In this article, we will learn how to Forecast data in Power BI. Forecasting in Power BI […]
The business value of frequent deployments
The post The business value of frequent deployments appeared first on SQLServerCentral.
Find 40 Problems in This Stored Procedure.
Aaron Bertrand posted a challenge: We’re going to use the AdventureWorks sample database (get your copy here), where […]
An Overview of PostgreSQL Window Functions
This article is a guide on using SQL window functions in applications that need to make computational heavy […]
Getting started with SSIS External Configuration File
The post Getting started with SSIS External Configuration File appeared first on SQLServerCentral.
Find 40 Problems in this SQL Server Stored Procedure
I’ve been at this for a while now, and have a very particular set of rules and […]
SQL Server 2022 : bug Filestream
En construisant mes démos, je suis tombé sur ce bug : lorsqu’on tente d’ajouter un filegroup filestream à […]
Office Hours: Short Text Answers Edition
Not all of the questions y’all post at https://pollgab.com/room/brento require long-winded responses. Brandon: Do you seen a rise […]
Undoing Actions on Groups of Database Tables
The post Undoing Actions on Groups of Database Tables appeared first on SQLServerCentral.
Azure Automation With Visual Studio Code
Introduction Azure Automation is a cloud-based service that provides consistent management capabilities across Azure and non-Azure environments. Visual […]
PostgreSQL Basics: Object Ownership and Default Privileges
In the first security article, PostgreSQL Basics: Roles and Privileges, I discussed how roles (users and groups) […]
EF Core 8 Preview 1: Raw, lazy, and on-time
The first preview of Entity Framework Core (EF Core) 8 is available on NuGet today! Basic information […]
Updated First Responder Kit and Consultant Toolkit for February 2023
Thanks to this technique to run SQL Server on Apple Silicon chips, I’m now developing exclusively on my […]
SQL Server 2022: Measuring Extended Events Performance Impacts
Have you ever wondered if Extended Events is affecting the performance of your workload? I have written a […]
3 Key Areas to Drive Digital Transformation
The post 3 Key Areas to Drive Digital Transformation appeared first on SQLServerCentral.
json_object and json_array Functions SQL Server 2022 Tutorial
The post json_object and json_array Functions SQL Server 2022 Tutorial appeared first on SQLServerCentral.
Cumulative Update #1 for SQL Server 2022 RTM
The 1st cumulative update release for SQL Server 2022 RTM is now available for download at the Microsoft […]
Cumulative Update #19 for SQL Server 2019 RTM
The 19th cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft […]
Join us in our castle at SQL Bits, March 15-18
The post Join us in our castle at SQL Bits, March 15-18 appeared first on SQLServerCentral.
Resources for PL-900 Microsoft Power Platform Fundamentals Certification Exam
The post Resources for PL-900 Microsoft Power Platform Fundamentals Certification Exam appeared first on SQLServerCentral.
[Video] Office Hours Brought to You by Quest Software
Today’s episode of Office Hours is brought to you by Quest Software. I went through your top-voted questions […]
Security Update for SQL Server 2022 RTM GDR
The Security Update for SQL Server 2022 RTM GDR is now available for download at the Microsoft Download […]
Security Update for SQL Server 2019 RTM CU18
The Security Update for SQL Server 2019 RTM CU18 is now available for download at the Microsoft Download […]
Security Update for SQL Server 2017 RTM CU31
The Security Update for SQL Server 2017 RTM CU31 is now available for download at the Microsoft Download […]
Azure Machine Learning Introduction: Part 1 Overview and prep work
The five-part series is designed to jump-start any IT professional’s journey in the fascinating world of Data […]
OLE DB Driver 19.3 for SQL Server Released
Version 19.3 of the Microsoft OLE DB Driver for SQL Server has been released. Version 19.3 adds Windows […]
Easily migrate SQL Server applications to the cloud with Azure
Microsoft Azure knows SQL Server best and will support your cloud migration at no cost for qualifying scenarios. […]
ODBC Driver 18.2 for SQL Server Released
Version 18.2 of the Microsoft ODBC Driver 18 for SQL Server has been released. Version 18.2 brings Windows ARM64 […]
Getting Started with Flyway Migrations on Oracle
The post Getting Started with Flyway Migrations on Oracle appeared first on SQLServerCentral.
A Simple Tutorial for DML Triggers
Introduction The trigger is a method provided by SQL Server to programmers and data analysts to ensure data […]
Who’s Hiring in the Microsoft Data Platform Community? February 2023 ...
It’s Valentine’s day – let’s do some matchmaking! Is your company hiring for a database position as of […]
What is ChatGPT – Is it the rise of the ...
Introduction to ChatGPT ChatGPT is a Generative Pre-trained Transformer. It is a chatbot created by OpenAI (An American […]
An Introduction to Assessing Normal Distribution with Python
The post An Introduction to Assessing Normal Distribution with Python appeared first on SQLServerCentral.
How do your DevOps plans really measure up?
The post How do your DevOps plans really measure up? appeared first on SQLServerCentral.
Join Redgate at SQL Bits, March 15-18
The post Join Redgate at SQL Bits, March 15-18 appeared first on SQLServerCentral.
Steps to add a new disk to SQL Server failover ...
The post Steps to add a new disk to SQL Server failover cluster instance and move a user […]
PostgreSQL Temporary Table
Overview In this tutorial, we will learn about a PostgreSQL temporary table and its usage. We will study […]
How to ask for programming help
Over the past 25 years, I have answered a lot of programming questions in online forums, from […]
[Video] Office Hours: Quiet Sunday Edition
While waiting for the dry cleaner to open, I went live to stream a quiet session going through […]
Petit guide de Transact SQL – Partie 1
Des types de données aux tables temporelles… Ce petit guide est constituée de 4 parties qui vont être […]
Firebase and Supabase: Key differences you need to know
The tools classified as “Realtime Backend / API“, or tools that can rapidly process an API call […]
Azure Developer CLI (azd) – February 2023 Release
We’re pleased to announce that the February 2023 release (0.6.0-beta.1) of the Azure Developer CLI (azd) is […]