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 Studio Code (VS Code), in my opinion, is a next-gen code editor that is based on open-source. It is …
PostgreSQL Basics: Object Ownership and Default Privileges
In the first security article, PostgreSQL Basics: Roles and Privileges, I discussed how roles (users and groups) are created and managed in PostgreSQL Depending on your background with permissions, particularly in other database products, some of those …
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 Mac! I’ve been using a Mac for over 15 years, but in the past, I’ve always used Windows at some layer somewhere. This time around, …
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 lot about Extended Events and have been a huge promoter of why you should be using Extended Events instead of SQL Trace for longer than I have wor …
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.
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 from PollGab.com/room/brento, and, uh, kinda looked like I was sponsored by Fendi while doing it, hahaha: Wow, those logos are bigger tha …
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 Science with Azure Machine Learning (Azure ML). Readers don’t need prior knowledge of Data Science, Machine Learning, Statistics, …
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 integrity. It is a special stored procedure related to table events. Its execution is not called by the program or started manually but triggere …
Who’s Hiring in the Microsoft Data Platform Community? February 2023 Edition
It’s Valentine’s day – let’s do some matchmaking! Is your company hiring for a database position as of February 2023? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. …
An Introduction to Assessing Normal Distribution with Python
The post An Introduction to Assessing Normal Distribution with Python appeared first on SQLServerCentral.