Long Short-Term Memory Network for Machine Learning
The post Long Short-Term Memory Network for Machine Learning appeared first on SQLServerCentral.
Tous les articles
From Rows to Pages: The Hidden Chaos Behind SQL Server’s ...
Introduction Sampling data is a common requirement in many real-world SQL Server workloads. Whether you are trying to […]
SQLBits 2026 is Going Back to Newport, Wales.
SQLBits 2026 will be back at the International Convention Center Wales in Newport on April 22-25, and I’ll […]
Contained Availability Groups in SQL Server 2022
SQL Server 2022 introduced a new feature called Contained Availability Groups. It allows the Database Administrators to effectively […]
Save $150 on the Summit with Discount Code BRENT25
The PASS Data Community Summit is the biggest conference in the Microsoft database industry, and over the last […]
MySQL Shell Basic Configuration Management (Part 6 – Backups and ...
In this final part of the MySQL Shell Configuration Management series, we explore how to automate performance […]
Split strings by Regular Expressions in SQL Server 2025
The post Split strings by Regular Expressions in SQL Server 2025 appeared first on SQLServerCentral.
[Video] Office Hours: Docked in Miami Beach
On the last day of my Caribbean cruise, as we pull into port in Miami, let’s go through […]
Make the Comment Section Look Like a Junior DBA’s Search ...
Tomorrow’s scheduled webcast for Mastering Parameter Sniffing is off due to a scheduling issue, so in the meantime, […]
Secure PostgreSQL in Docker: SSL, Certificates & Config Best Practices
PostgreSQL is an open-source relational database management system valued for its power, standards-compliance, and extensibility. Whether you’re […]
Enable TDE for Databases in a SQL Server AlwaysOn Availability ...
The post Enable TDE for Databases in a SQL Server AlwaysOn Availability Group appeared first on SQLServerCentral.
AI is Like Outsourcing. #TSQL2sday
When you ask data people how they feel about AI, you get pretty rabid, extreme reactions. People either […]
Power BI TMDL View: Benefits, Security Risks & Best Practices
The Tabular Model Definition Language (TMDL) provides a simpler way of defining Power BI Semantic Models. Unlike […]
How to create your custom GPT SQL Expert
Introduction ChatGPT includes custom GPTs. You can create your own custom GPT. In this article, we will demonstrate […]
MongoDB and NodeJS in action
Overview MongoDB is a popular NoSQL database used for building modern, scalable applications. In this article, we’ll cover […]
MySQL Shell Basic Configuration Management (Part 5a – Optimizing MySQL ...
Welcome back to our comprehensive guide on optimizing MySQL performance using MySQL Shell. So far in this […]
[Video] Office Hours: 15 Answers in 30 Minutes
The first few questions from this week’s crop at https://pollgab.com/room/brento are very much about what-problem-are-you-trying-to-solve, but they get […]
Working with Indexes on SSMS
Overview: In SQL Server, indexing is a technique used to improve the performance of queries by reducing the […]
SQL Server Threats
Microsoft SQL Server is a robust relational database management system. It stores and processes sensitive data for countless […]
Deprecated but Forgotten: Why SQL Server’s Text, NText, and Image ...
Introduction These data types – TEXT, NTEXT, and IMAGE – have been part of SQL Server since its […]
Why CQRS and Event Sourcing Are Gaining Ground in High-Concurrency ...
In web app development company boardrooms, architects and engineers are debating old assumptions. Scaling up isn’t just about […]
How to Make Leading Wildcard Searches Fast
99.9% of you are never gonna need this. But let’s say you need to run queries with leading […]
Who’s Hiring in the Microsoft Database Community? August 2025 Edition
Is your company hiring for a database position as of August 2025? Do you wanna work with the […]
Mastering SQL VIEWs: Syntax, Use Cases, and Best Practices
VIEWs are an undervalued and underused feature in SQL. They basically consist of a query that has […]
Yet another Date Dimension
Evolution of code The thing with any bit of code that has been around for a while, is […]
Advanced SQL Server Page Forensics: Detecting Page Splits and Allocations ...
Introduction Page splits are one of those silent performance killers in SQL Server that many DBAs have heard […]
How to Access and Use Azure Key Vault Secrets in ...
When you run a CI/CD pipeline, you often need confidential values like passwords, authentication tokens, service principal secrets […]
How to Use the psql Command-Line Tool with Azure Database for PostgreSQL ...
A number of client tools are available for working with Azure Database for PostgreSQL flexible server. With […]
Connect Cloud Power BI to on prem SQL Server
Power BI has the versatility that you can publish your reports to the cloud (Power BI Service) and […]
Model Context Protocol (MCP): A Developer’s Guide to Long-Context LLM ...
Large Language Models (LLMs) like Anthropic’s Claude have unlocked massive context windows (up to 100k tokens in Claude […]
How to safely and surgically restore filegroups
In all my years working with SQL Server and navigating disaster recovery scenarios, I’ve come across surprisingly few […]
[Video] Office Hours: Interview Horror Stories Edition
Wanna hear about my worst job interviews? I drove up to 8,000 feet where it’s 30 degrees colder […]
MongoDB and Python in action
Overview As a part of this article, we will learn basics of connecting to MongoDB using a python […]
Best Way to Repair SQL Database: How to Restore SQL ...
Summary: SQL Server administrators frequently encounter the critical challenge of unexpected MDF file corruption. Such corruption can result […]
Poll Results: Yes, Your DBAs Can Read the Data.
Last week, I asked if your database administrators could read all of the data in all databases. The […]
MySQL Index Overviews: PRIMARY KEY Indexes
If you’re a developer who had interactions with indexes in the past, you certainly know that indexes […]
The Query Tuning Trick You Should Use More: Pagination
When I’m tuning queries, the normal answer is to make the query perform better – either via changing […]
How to Increase SQL Server Column Width Without IO (Input/Output) ...
One of the most hassle-prone changes that can be made in a SQL Server database is to […]
How to optimize queries using AI (SQL Expert)
Introduction ChatGPT can help you with your queries. However, some customized GPTs inside ChatGPT can be useful for […]
Nouveautés SSMS 21 & SQL Server 2025 : Copilot, Halloween ...
Exploration des nouveautés de SQL Server Management Studio 21 et SQL Server 2025, avec des démonstrations pratiques […]
Retour d’expérience client sur le change data capture et la ...
Clément Hugé Après une rapide présentation de la fonctionnalité et des avantages et inconvénients, nous nous attarderons […]
Verrouillage optimiste vs pessimiste… Les implémentations dans les SGBDR
Frédéric Brouard, SQL Spot Optimiste ou pessimiste ? Le vrai visage du verrouillage selon votre SGBD Oracle, […]
Les Nouveautés dans SQL Server 2025, IA ready !
Julien Pierre, Microsoft et Stéphane Scherrer, Microsoft SQL Server 2025 : l’IA s’invite au moteur SQL Server […]
Les synonymes dans SQL Server + Projet SQL Server dans ...
Sébastien Kobenan Sujet 1 : Les synonymes dans SQL Server Vous avez une ou plusieurs bases de […]
How to Measure Replication Latency in SQL Server AlwaysOn Synchronous ...
Synchronous replicas in SQL Server Availability Groups promise no data loss, but they don’t promise zero delay; […]
[Video] Building a Brand By Sharing Your Work
You’ve got a good job, and some spare time. You’re thinking about giving back to the community by […]
Connecting to PostgreSQL with Node.js
Overview In this article, we will understand how we can connect to PostgreSQL using Node.js application. We will […]
Taming Resource Hogs: Using SQL Server Resource Governor to Restrict ...
Taming Resource Hogs: Using SQL Server Resource Governor to Restrict User Group Consumption As a SQL Server professional, […]
Monitor SQL Server using Zabbix
Zabbix is an open-source monitoring software, like Paessler PRTG, which can monitor SQL Server performance statistics and status. […]
Poll: Can Your DBAs Read the Data?
It’s a simple question: can your database administrators read all of the data in all databases? Yes Yes, […]