Cumulative Update #27 for SQL Server 2019 RTM
The 27th cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft […]
Tous les articles
Fine-grained Access Control for Stored Procedures
Synopsis Modern relational databases have comprehensive security mechanisms to enforce fine-grained access control for tables and views. But when […]
Power BI Treemap Chart Step-by-Step Tutorial
The post Power BI Treemap Chart Step-by-Step Tutorial appeared first on SQLServerCentral.
[Video] Creepy Office Hours in Vancouver
While in a hotel room in Vancouver for PGconf.dev, I strapped on my Apple Vision Pro headset to […]
Query Exercise: Beat ChatGPT at Finding Good Question Times
What are the best days of the week and times of the day to post a question at […]
Memory Grant Feedback Persistence in SQL Server 2022
As a SQL Server DBA, effectively controlling memory allocations is essential to guaranteeing optimal query performance. In SQL […]
PostgreSQL is Now Faster than Pinecone, 75% Cheaper, with New ...
NEW YORK – June 11, 2024 – Timescale, the PostgreSQL cloud database company, has unveiled two groundbreaking open-source […]
There’s a 6-Month Statute of Limitations on “The Last Person.”
“The last person must have set it up that way.” “The last person wrote that code.” “The last […]
Choosing Between the Lakehouse and Warehouse in Microsoft Fabric
Microsoft Fabric is a new centralized, AI-powered cloud data platform hosted by Microsoft. It combines several services […]
SQL Server 2022 is EAL 2 Common Criteria certified!
In a previous blog post in 2023 we mentioned that two Common Criteria (CC) certifications of SQL Server […]
Concepts and Issues in Test Data Generation
Data generation is the science and art of providing data for database development work that is as […]
How to Sort String Date Values on a Power BI ...
The post How to Sort String Date Values on a Power BI Slicer Visual appeared first on SQLServerCentral.
How to Set Up Microsoft Fabric Database Mirroring for Azure ...
Microsoft Fabric is a new centralized, SaaS data analytics platform which has been generally available since November 2023. […]
Nettoyage des instances et bases de données SQL Server
Avec Frédéric Brouard, SQL Spot : https://www.linkedin.com/in/frederic-brouard-alias-sqlpro-914761 et Arian Papillon, Datafly, MVP : https://www.linkedin.com/in/arianpapillon/ – Combien de […]
Migration de base de données SQL vers le cloud – ...
Avec David Barbarin, Migros Online : https://www.linkedin.com/in/mikedavem/ Si vous envisagez de migrer votre plateforme de base de […]
Amélioration des performances par partitionnement
Cas Client: amélioration des performances et de la maintenance des tables volumétriques et fortement sollicitées Avec Clément […]
Azure Arc
Azure Arc étend les services Azure aux instances SQL Server hébergées en dehors d’Azure. Azure Arc vous […]
Identify Tables With Dropped Columns
In my last article – What happens when we drop a column on a SQL Server table? Where’s […]
Sails.js for web development
Sails.js is a robust web development framework that runs on top of Node.js and uses JavaScript’s asynchronous […]
Suivi en temps réel de ma production solaire et de ...
Microsoft Fabric is a cloud-based platform that lets you, among other Data Activity, stream, analyze, and visualize […]
[Video] Office Hours in a Hotel Room
While in Nashville for a creators conference, I went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we […]
Datafrogs juin 2024 : ménage de printemps
Pour cette session des Datafrogs, le 1er juin, le sujet de notre présentation était « Ménage de printemps ». Il […]
Auditing SQL Server – Part 1 – Discovery and Documentation
Inheriting a server, whether as an inexperienced user or an experienced DBA, has many challenges. It’s very […]
Database mail and connection pool depletion
Database Mail (DBMail) in SQL Server is a feature that allows you to send emails directly from SQL […]
The signs of a new era: Prompt Injection
More than 20 years ago, I wrote a book about SQL Injection and how dangerous it can […]
Two Tweaks for Faster Backups with Ola Hallengren’s Scripts
Ola Hallengren’s free maintenance solution is widely used as a replacement for SQL Server maintenance plans. It’s a […]
WITspiration – Year 2
The post WITspiration – Year 2 appeared first on SQLServerCentral.
Basic Always On Availability Groups in SQL Server Standard
Introduction In this walkthrough, we will be setting up a Basic Availability Group in SQL Server Standard edition […]
Who’s Hiring in the Microsoft Data Platform Community? June 2024 ...
Is your company hiring for a database position as of June 2024? Do you wanna work with the […]
Effective Strategies for Storing and Parsing XML in SQL Server
XML is a common storage format for data, metadata, parameters, or other semi-structured data. Because of this, […]
SQL Server on Azure VMs: I/O analysis (preview)
Analyzing I/O problems just got easier for SQL Server on Azure VMs It is not easy to […]
Bridging Snowflake and Azure Data Stack: A Step-by-Step Guide
In today’s era of hybrid data ecosystems, organizations often find themselves straddling multiple data platforms for optimal performance […]
Powershell and SQL on the River
We are having a conference in Chattanooga, TN on Aug 16 and 17, the primary topics of […]
[Video] Office Hours: 16 Questions
Like Sixteen Candles, but different: I go through your top-voted questions from https://pollgab.com/room/brento. Strangely, my video and audio […]
PostgreSQL UNION, INTERCEPT & EXCEPT Operator
Overview In this tutorial, you will learn how to use the PostgreSQL Union, Intercept and Except operators to […]
SQL Bulk Insert Command Examples
The post SQL Bulk Insert Command Examples appeared first on SQLServerCentral.
Coming in Entity Framework 9: Better Query Parameterization
Hallelujah. With current versions of Entity Framework, when developers add a mix of parameters and specific values to […]
This Is It! The Last 3 Days of My Anniversary ...
Every year in May, I look back at when I first registered BrentOzar.com way back in May 2001. […]
Enhancing Web Application Performance through Database Optimization: A Comprehensive Study
Introduction In today’s digital age, web applications serve as the backbone of online services, catering to a myriad […]
Updated First Responder Kit and Consultant Toolkit for May 2024
If you’ve hard-coded installer file names, there’s a big change in this release. There are now just 2 […]
Snake draft sorting in SQL Server, part 4
In the previous posts in this series (part 1, part 2, part 3), I described how I […]
SQL Server Temporary Stored Procedures
The post SQL Server Temporary Stored Procedures appeared first on SQLServerCentral.
What is new in Copilot, the new features available
Introduction to copilot In Bing, you can now see a Copilot option. In the past, we had Bing […]
Manage Elastic jobs in Azure using Azure Elastic Jobs Manager
Microsoft Azure offers the Azure Elastic Job agent as a managed service, enabling efficient scheduling of T-SQL workloads […]
Takeaways from Data Grillen 2024
Before anyone tries to order something online from DataGrillen.com and thinks it will be delivered by them by […]
Okay, About That SmartPostgres.com Thing.
In some of the Query Exercises posts here, you might have noticed links over to similar query exercises […]
ライセンス関連のお問い合わせ窓口について (Azure 仮想マシン : SQL Server)
こんにちは、 SQL Server サポートです。 本記事では、Azure 仮想マシン上でご利用の SQL Server のライセンスに関するお問い合わせ窓口を紹介します。 Azure 仮想マシン上の SQL Server のライセンスやご契約に関するお問い合わせを 私ども技術サポート窓口 にお問い合わせをいただくことがありますが、恐れ入りますが専門外となるため、基本的にご案内はできないものとなります。 […]
[Video] Office Hours: I Feel Like an Amateur Edition
I started with audio problems, then had video problems halfway in. It’s amusing because we also discuss feeling […]
Troubleshoot SQL Server Always On Availability Groups with SQL LogScout
The post Troubleshoot SQL Server Always On Availability Groups with SQL LogScout appeared first on SQLServerCentral.