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 […]
Archives de l’année : 2023
[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.
Delegating permission management using Roles vs WITH GRANT OPTION
The article is published here on the Azure SQL Blog: Delegating permission management using Roles vs WITH GRANT […]
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 […]
Migration from Sybase ASE using SSMA CLI
Recently I learned a lesson through multiple testing around SSMA for Sybase. Let’s suppose you need to migrate […]
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 […]
PASS Data Community Summit 2023 – Sessions are available to ...
The post PASS Data Community Summit 2023 – Sessions are available to view! appeared first on SQLServerCentral.
Meetup du Club Power BI de Strasbourg, mai 2023
e 4 mai 2023, le Club Power BI de Strasbourg a organisé un nouveau meetup titré « Power […]
Meetup du Club Power BI de Strasbourg, mars 2023
Le 13 mars 2023, le Club Power BI de Strasbourg a organisé un nouveau meetup titré « Power […]
The PASS Summit Lineup Is Out and Registration is Open!
This year’s PASS Data Community Summit is November 13-17 in Seattle. (No online version is available this year […]
Cumulative Update #22 for SQL Server 2019 RTM
The 22nd cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft […]
Discover the Microsoft Fabric Data Wrangler
The Data Wrangler is as interesting as hidden inside Microsoft Fabric. It’s not easy to find and […]
Working around schema drift in SQL Server
At Stack Overflow, our environment has multiple implementations of a largely – but not 100% – identical […]
Bing vs Bard (Chatbot wars)
Introduction about Bing vs Bard You heard it well Chatbot wars, the war between Bing vs Bard. Ladies […]
Managing the challenge of migrating to the cloud
The post Managing the challenge of migrating to the cloud appeared first on SQLServerCentral.
Dive into RDS Custom for SQL Server – Leverage your ...
The post Dive into RDS Custom for SQL Server – Leverage your existing licenses and high availability appeared […]
Database Concurrency in PostgreSQL
Concurrency control is an essential aspect of database systems that deals with multiple concurrent transactions. PostgreSQL employs […]
SQL Server 2022 now available for both RHEL 9 and ...
We are glad to announce that SQL Server 2022 is now available in preview mode for both Red […]
Cumulative Update #7 for SQL Server 2022 RTM
The 7th cumulative update release for SQL Server 2022 RTM is now available for download at the Microsoft […]
How Would You Design This: Tracking Travels
One of the challenges for many database developers is coming up with a good design that not only […]
Data Transfer from Azure Blob Storage to Snowflake Using Pipelines
The post Data Transfer from Azure Blob Storage to Snowflake Using Pipelines appeared first on SQLServerCentral.
PostgreSQL 101: The ten PostgreSQL extensions you need to know ...
The post PostgreSQL 101: The ten PostgreSQL extensions you need to know about appeared first on SQLServerCentral.
Going to a conference where hardly anybody knows my name
On Friday and Saturday August 11 and 12, I am going to do something I haven’t done […]
[Video] Office Hours: Stump Me On SQL Server
I went through the top-voted questions from https://pollgab.com/room/brento and discussed ’em live on my Twitch channel. Here’s […]
[Video] Office Hours: Extended Answers Edition
Y’all posted so many good questions at https://pollgab.com/room/brento that I went longer than usual this time: Here’s what […]
Meet the Summit 2023 Sponsors
The post Meet the Summit 2023 Sponsors appeared first on SQLServerCentral.
Upserts in Amazon Redshift
Amazon Redshift was first announced in 2012 as a new cloud-based analytical data warehousing service. Since then, it […]
Standard Sponsor Rates End August 30!
The post Standard Sponsor Rates End August 30! appeared first on SQLServerCentral.
A Beginners Guide to MySQL Replication Part 4: Using GTID-based ...
Welcome back to another replication series! As a quick reminder, we explored various methods of using MySQL’s […]
T-SQL Tuesday #165 – My Experience with Database Job Titles
They mean very little. More on that after nothing that this is part of T-SQL Tuesday, and […]
I/O optimizations for tempdb in SQL Server and Azure SQL
I have found almost every day of my career at Microsoft, I learn something new about Microsoft SQL. […]
Analyzing Prices of SQL Server Books, New & Used
While on a road trip, Richie stopped by a used bookstore (or would that be used book store?) […]
The Curious Case of… recovering from a ransomware attack
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post […]
Azure Data Studio 1.45 Release and Hotfix
We released Azure Data Studio 1.45 over a week ago, and today we’re announcing a hotfix for it, […]
What Is an Execution Plan and How to Find It ...
In the last blog (When PostgreSQL Parameter Tuning is not the Answer), we compared several execution plans […]
Combine DATE and TIME to DATETIME2 in SQL Server
tl;dr In the following code, « DateValue » and « TimeValue » can be replaced by either variables or columns of the […]
Using Power Query to Combine Data from Multiple Sheets in ...
The post Using Power Query to Combine Data from Multiple Sheets in Excel appeared first on SQLServerCentral.
7 Essential Factors for a Successful Cloud Migration: A Non-Technical ...
The post 7 Essential Factors for a Successful Cloud Migration: A Non-Technical Guide appeared first on SQLServerCentral.