Webinar: The Impact of the Cloud on Databases
The post Webinar: The Impact of the Cloud on Databases appeared first on SQLServerCentral.
Sites anglophones
How to create a SQL Server presentation in 5 minutes ...
Introduction This SQLServerCentral article shows how to create a SQL Server presentation in 5 minutes using AI. AI […]
Working with NULL Values in SQL
The post Working with NULL Values in SQL appeared first on SQLServerCentral.
SQL Server Row Level Security Deep Dive. Part 3 – ...
Previous sections gave a brief introduction to RLS, including some common use cases. They also showed how […]
How to Use SQL to Analyze the Bitcoin Blockchain
Background The Bitcoin blockchain is a vast and complex database. It contains over 100 million blocks, each of […]
Decision Tree – Credit Card Fraud Detection
Credit card fraud detection is an important application of machine learning techniques, including Decision Trees. The goal is […]
SQL Unit Testing reference guide for beginners
The post SQL Unit Testing reference guide for beginners appeared first on SQLServerCentral.
Working with MySQL constraints
MySQL provides a set of constraints that you can include in your table definitions to help ensure […]
[Video] Office Hours at Jökulsárlón Glacial Lagoon
Post your Azure SQL DB and SQL Server questions at https://pollgab.com/room/brento and upvote the ones you’d like to […]
How To Connect to SQL Server Database From PowerShell
PowerShell can be a valuable tool for data analytics and data orchestration, especially when dealing with SQL Server […]
Microsoft Fabric: Lakehouse and Data Factory in Power BI environment
Microsoft is merging Data Factory and Power BI Dataflows in one single ETL solution. It’s not a […]
[Video] Office Hours at the Blue Lagoon
Road trip time! I’m recovering from jet lag after flying over to Iceland, so I went through your […]
Quickstart: Connect SQL Server machines to Azure Arc
The post Quickstart: Connect SQL Server machines to Azure Arc appeared first on SQLServerCentral.
Who’s Hiring in the Microsoft Data Platform Community? September 2023 ...
Is your company hiring for a database position as of September 2023? Do you wanna work with the […]
Orchestrating a MySQL Container on Kubernetes
If you’ve been using MySQL for a while and want to learn how to orchestrate MySQL containers, […]
Why Australian Azure SQL DBs Went Down for 8+ Hours
On August 30, Azure’s Australia East data center had a big problem, affecting customers like Bank of Queensland […]
Optimized Plan Forcing with Query Store in SQL Server 2022
In this article, we will delve into the world of Query Store and explore how to use Optimized […]
How To Use Flyway for Database Migration in Spring Boot
The post How To Use Flyway for Database Migration in Spring Boot appeared first on SQLServerCentral.
SQL Server Row Level Security Deep Dive. Part 2 – ...
The previous section in this series was an introduction to Row Level Security (RLS) and some use […]
Setting up Drill Through in the New Power BI Report ...
The post Setting up Drill Through in the New Power BI Report User Interface appeared first on SQLServerCentral.
Export and Import SSISDB in just a few clicks
From SQL Server 2012 onwards, Microsoft introduced a new deployment model in SSIS called the project deployment model. […]
[Video] Office Hours: Overly Caffeinated Edition
After consuming waaaay too much coffee, I went through your top-voted questions from https://pollgab.com/room/brento: Here’s what we covered: […]
[Video] Office Hours: All About Miles Edition
Today’s webcast featured an awful lot of questions from one particular person who was super-active at https://pollgab.com/room/brento: Here’s […]
Let’s talk about Artificial Intelligence, ChatGPT and Gobbledegook
The post Let’s talk about Artificial Intelligence, ChatGPT and Gobbledegook appeared first on SQLServerCentral.
Free Webcast: Avoiding Deadlocks by Tuning Queries
You’ve been getting more and more deadlock errors, and users are starting to complain. You’re wondering if your […]
Microsoft Fabric: Loading On-Premises and External Data
Loading On-Premises and external data is a fundamental need for a Data Platform such as Microsoft Fabric. […]
How to export data to SQL Server using Bard (Google ...
The article will explain how to export data to SQL Server with Bard can be challenging. Previously, we […]
10 reasons to choose Flyway
The post 10 reasons to choose Flyway appeared first on SQLServerCentral.
A Beginners Guide to MySQL Replication Part 5: Group Replication
This article is part of Aisha Bukar’s 6 part series on MySQL Replication. The entries include: Part […]
Different Ways to Format Currency Output in SQL
The post Different Ways to Format Currency Output in SQL appeared first on SQLServerCentral.
Yet Another Reason to Not Use sp_ in your SQL ...
In 2012, Aaron Bertrand said most everything I knew (and a bit more) about the issues with […]
Screen Scraping with Python and BeautifulSoup Code Examples
The post Screen Scraping with Python and BeautifulSoup Code Examples appeared first on SQLServerCentral.
The PostgreSQL Role Part 1
Article Overview In this article, we will cover the PostgreSQL database role object that groups together one or […]
[Video] Office Hours: I Need Your Help with These
Today, I need your help with some of the top-voted questions from https://pollgab.com/room/brento. Chime in in the comments: […]
Spot the Five Differences and Win a Summit Ticket
Spot all five differences in the two images and enter our prize draw competition to be in with […]
[Video] Office Hours: Really Long (and Really Short) Answers
Today’s batch of questions from https://pollgab.com/room/brento requires some really long answers, and some are right to the point. […]
Sessions for Summit 2023 are now LIVE!
The post Sessions for Summit 2023 are now LIVE! appeared first on SQLServerCentral.
How to secure legacy ASP.NET MVC against Cross-Site (CSRF) Attacks
The post How to secure legacy ASP.NET MVC against Cross-Site (CSRF) Attacks appeared first on SQLServerCentral.
Updated First Responder Kit and Consultant Toolkit for August 2023
Turns out y’all actually work over the summer – there are actually cool new features this month! I […]
Fabric Lakehouse: Convert to Table feature and Workspace Level Spark ...
I have been working as a no-code data engineer: Focused on Data Factory ETL and visual tools. […]
Learning PostgreSQL With Grant: Introducing VACUUM
While there are many features within PostgreSQL that are really similar to those within SQL Server, there […]
Database Monitoring for Developers
The post Database Monitoring for Developers appeared first on SQLServerCentral.
Working with SQL Server Stored Procedures and .NET
The post Working with SQL Server Stored Procedures and .NET appeared first on SQLServerCentral.
Provisioning Microsoft Fabric: A Step-by-Step Guide for Your Organization
Learn how to provision Microsoft Fabric with ease! Unveiled at Microsoft Build 2023, Microsoft Fabric is a cutting-edge […]
Import Text and CSV Files into SQL Server Database with ...
The post Import Text and CSV Files into SQL Server Database with SSIS Script Task appeared first on […]
A LEFT OUTER JOIN in SQL: What Is It?
What is a LEFT OUTER JOIN? In SQL, a LEFT OUTER JOIN is a type of join operation […]
[Video] Office Hours in Telluride, Colorado
We headed up to the mountains to get away from the Vegas heat. Before the sun rose, I […]
How much has data technology changed over the years?
The simple answer to this question is “a lot.” The funny part, however, is that everyone who […]
Office Hours: Before Heading Out on Vacation
I took a break from packing my bags long enough to answer your top-voted questions from https://pollgab.com/room/brento. Here’s […]
Managing Change
Change is inevitable… Change for the better is not. (Jeff Moden) Time has taught me to view change […]