Who’s Hiring in the Microsoft Data Platform Community? December 2022 ...
Is your company hiring for a database position as of December 2022? Do you wanna work with the […]
Archives de l’année : 2022
Update: ODBC Driver 17.10.2 for SQL Server Released
Version 17.10.2 of the Microsoft ODBC Driver 17 for SQL Server has been released. Version 17.10.2 brings a few […]
Connecting the Dots of Azure SQL CICD Part 3: Testing ...
In part 3 of our Azure SQL database change management (CICD) series we cover testing your code […]
The Good, The Bad, and Suboptimal of Sticking to What ...
The Good In the late 1990s, one of the world’s most popular technologies was waning. COBOL. Relational […]
Webinar | Database Monitoring: The ROI of Build vs. Buy
The post Webinar | Database Monitoring: The ROI of Build vs. Buy appeared first on SQLServerCentral.
Amazon EC2 | Creating a Connection to an Amazon RDS ...
Introduction In a previous article, we showed how to expose an Amazon RDS instance to the public internet […]
SQL Server 2022 Paid Editions Require a Licensing Key
The post SQL Server 2022 Paid Editions Require a Licensing Key appeared first on SQLServerCentral.
Dealing with the Bits of a Binary Value in SQL ...
How you used to do it For example, say you want to find all the read-write database […]
Backing Up MySQL Part 7: MySQL Enterprise Backup
MySQL Enterprise Backup is a known tool for everyone inside of the world of MySQL, no matter […]
A Real-world Implementation of Database DevOps: People, Processes, Tools
The post A Real-world Implementation of Database DevOps: People, Processes, Tools appeared first on SQLServerCentral.
SQL RAISERROR to Better Handle Errors
The post SQL RAISERROR to Better Handle Errors appeared first on SQLServerCentral.
Getting started with ROUND() and Its Use Cases
In this article, I will explore one of the SQL Server mathematical functions, ROUND. The T-SQL ROUND() function […]
Subqueries in MySQL
Part of Robert Sheldon’s continuing series on Learning MySQL. The series so far: Getting started with MySQL […]
Mentoring 2023 – want some help from me?
[Edit 12/16/2022:the deadline for submissions is now closed.] In 2015 I mentored 54 people for six months. In […]
Cardinality Estimation Feedback in SQL Server 2022
Part of theSQL Server 2022 blog series. Cardinality estimation (CE) is a process used by the query optimizer […]
The Black Friday Sale Has Been Extended!
I got a *lot* of last minute emails this year from companies whose purchasing processes were moving slowly. […]
FCI failed to do failover because of ReAclDirectory : Failed ...
Customer was trying to apply SQL2014 SP3 in Failover cluster instance. They applied patch to passive node, then […]
Basic Checks on a New AWS RDS SQL Server
Introduction In this article, we shall imagine that we were just recruited by a new company and handed […]
Webinar | Test Data Management
The post Webinar | Test Data Management appeared first on SQLServerCentral.
Slow “Having” Query? Try Pre-Filtering.
I was helping a client with a query, and I’m going to rework the example to use the […]
New In SQL Server 2022 and Azure SQL: XEvent Performance ...
Running Extended Event (XEvent) sessions on SQL Server has a cost. Since XEvents was designed for high-performance, this […]
Azure KeyVault を用いて AG 環境の暗号化を実施する
こんにちは、 SQL Server サポートです。 今回は、 Always On 可用性グループを構成するデータベースを Azure Key Vault を利用し TDE 暗号化する手順についてご紹介します。 手順の大まかな流れとしては以下の公開情報の手順を、プライマリ、セカンダリ両方で実施し、同じ非対称キーを用いてTDE暗号化する流れとなります。 Azure […]
A week in Seattle in 8 Slides at the PASS ...
Being from home for over a week, having a good travel companion is crucial. And with rising data […]
Being Agile – A Success Story
Introduction What is Agile? The definition of Agile varies depending on the perspective of a person. For example, […]
SQL Server at Scale – Using an Archive Table – ...
The post SQL Server at Scale – Using an Archive Table – Part 2 appeared first on SQLServerCentral.
The Curious Case of… community
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post […]
Backing Up MySQL Part 5: Backing Up Big Data
According to research made by Statista in 2022, the amount of data that is being worked with […]
[Video] Office Hours: Black Friday Edition
My Black Friday sale is in its last days, so most of my time at the moment is spent […]
Express.js or Next.js for your Backend Project
Backend projects create projects to execute code on a centralized server and then communicate results with a […]
Is Azure SQL Database a Good Choice for your Database ...
The post Is Azure SQL Database a Good Choice for your Database Applications? appeared first on SQLServerCentral.
Why bother automating?
The post Why bother automating? appeared first on SQLServerCentral.
Troubleshooting external data and access policies in Azure SQL and ...
The article is published here on the Azure SQL Blog: Troubleshooting external data and access policies in Azure SQL […]
Contest: Guess the Next SQL Server Release Date
When will Microsoft officially release SQL Server 2023 (or 2024, or whatever it’ll be) for download? The dust […]
Migrate Azure Analysis Services to Power BI Premium
Power BI has evolved into the leading platform for both self-service and IT-managed enterprise business intelligence. The […]
Using SQL Backup in Development Work
The post Using SQL Backup in Development Work appeared first on SQLServerCentral.
Are You Underpaid? Let’s Find Out: The 7th Annual Data ...
Whew. This is a crazy time, isn’t it? The aftermath of the pandemic is kicking in, and there […]
Backing up MySQL Part 4: mydumper
There are many tools we can use to back up our MySQL databases. Some are well-known and […]
Converting Data Across Time Zones: An In-Depth Primer
If only the entire world used UTC, wouldn’t life be so much easier? We can dream, can’t […]
SQL Server 2022: Azure AD Authentication
SQL Server 2022 is finally GA and one of the features I was most expecting is finally […]
Microsoft lance officiellement SQL Server 2022
La déclinaison 2022 du SGBD de Microsoft, SQL Server, passe en mode GA (disponibilité générale). La firme de […]
Looking Back at the 2022 #PASSDataCommunitySummit in Seattle
I’m back home in Vegas, back down to Inbox Zero, and I’ve had some time to think about […]
New Flyway Course on Redgate University
The post New Flyway Course on Redgate University appeared first on SQLServerCentral.
Amazon RDS – Configuring a Connection to a SQL Server ...
Introduction In a previous article, we explored the factors worth considering when deploying a database in the public […]
An Introduction to SQL Triggers
The post An Introduction to SQL Triggers appeared first on SQLServerCentral.
Installations rapides
Si comme moi vous déployez fréquemment des instances SQL Server pour des tests divers et que vous êtes […]
Backing up MySQL Part 3: mysqlpump
In the MySQL world, there are a couple of ways to take backups of your data. Backups […]
#PASSdataCommunitySummit Keynote Day 3 Live Blog
Today at the PASS Data Community Summit in Seattle, Kimberly Tripp is doing the first-ever in-person community keynote. […]
Retrouvez la version d'origine
Savez-vous que les fichiers de données ou de sauvegarde de SQL Server embarquent l’information sur la version d’origine […]