SQL Local Variables and Performance Issues
The post SQL Local Variables and Performance Issues appeared first on SQLServerCentral.
Tous les articles
Released: Microsoft.Data.SqlClient 3.1.7
We have released an update to Microsoft.Data.SqlClient, version 3.1.7. The update addresses several issues. Microsoft.Data.SqlClient 3.1 is […]
[Video] Office Hours: Professional Development Q&A
I was supposed to be on a flight to Mexico, but had to cancel at the last minute. […]
Query Exercise: Solving The 201 Buckets Problem
When you run a query, SQL Server needs to estimate the number of matching rows it’ll find – […]
Introducing Schema Validation in MongoDB
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Auditing SQL Server – Part 3 – SQL Server Configuration ...
The post Auditing SQL Server – Part 3 – SQL Server Configuration Audit appeared first on SQLServerCentral.
A New and Improved Data Warehouse: Data Engineering with Fabric
Microsoft Fabric is their fourth version of a Data Warehouse. Back in September of 2008, Microsoft bought DATAllegro […]
Released: Microsoft.Data.SqlClient 3.1.6
We have released an update to Microsoft.Data.SqlClient, version 3.1.6. The update addresses several issues. Microsoft.Data.SqlClient 3.1 is […]
Make Money Referring Folks to My Training!
YOU! Wanna make easy money? Black Friday is coming. Every November, we run a big sale on our […]
Auditing SQL Server – Part 4 – Database Configuration Audit
This continues my series on auditing SQL Server. The fist parts covered discovery and documentation, server level […]
LIKE Constraints
In this article, I will cover a bit about the LIKE operator, including how it works, and […]
Reduce SQL Server Blocking with READ_COMMITTED_SNAPSHOT
The post Reduce SQL Server Blocking with READ_COMMITTED_SNAPSHOT appeared first on SQLServerCentral.
Data Prediction with SQL Server Machine Learning Services, Python, and ...
AI is increasingly becoming part of everyday life across various domains. For the uninitiated, AI which stands for […]
PostgreSQL Partitioning: The Most Useful Feature You May Never Have ...
Partitioning in PostgreSQL was for many years a feature almost entirely ignored, and even today is often […]
10 tips for Test Data Management success
The post 10 tips for Test Data Management success appeared first on SQLServerCentral.
Recover a Database from Suspect Mode Step by Step
On 19th June 2024, the world faced a major outage. The computer on which the Windows operating system […]
Change Data Capture Pipeline Automation in Snowflake
This article offers technical guidance on automating updates and tracking changes of data examples using Snowflake’s CDC […]
[Video] Office Hours: Ask Me Anything About #SQLServer
I took your top-voted questions from https://pollgab.com/room/brento, including a few career-oriented ones: Here’s what we covered: 00:00 Start […]
Thoughts Before Speaking at the Software Architecture Conference
Tomorrow, August 15, I have yet another conference where I’ll speak about MySQL’s performance. To be more […]
Modernize Microsoft SQL Server 2014 workloads with Azure
We take pride in delivering innovation with each new version of Microsoft SQL Server. However, there comes a […]
Query Exercise Answer: What Makes SELECT TOP 1 or SELECT ...
This Query Exercise was very different: I didn’t ask you to solve a particular problem. I pointed out […]
SSIS in One Hour: Hands-On Tutorial
The post SSIS in One Hour: Hands-On Tutorial appeared first on SQLServerCentral.
Introducing PASS Summit Charitable Organization Scholarship
The post Introducing PASS Summit Charitable Organization Scholarship appeared first on SQLServerCentral.
SQL ConstantCare® Population Report: Summer 2024 (And Upcoming Gamification Badges)
The short story: SQL Server 2022 finally saw some growth this quarter! Two years after the release, 1 […]
As a SQL Server DBA, Postgres Backups Surprised Me.
Over the last week, I’ve been working on putting together a Postgres version of the Stack Overflow database, […]
MySQL vs PostgreSQL: Which Open-Source Database is right for you?
When I joined a growing startup company as a backend developer, we were at crossroads choosing between […]
Hiring in IT and Relevance of Domain Experience
We recently wanted to hire two candidates (SQL developers with around 5-10 years of experience) to join our […]
Microsoft Fabric: Moving Dataflows Gen 2 to different workspaces
The post Microsoft Fabric: Moving Dataflows Gen 2 to different workspaces appeared first on SQLServerCentral.
Introducing the pre-con schedule for PASS Summit 2024
The post Introducing the pre-con schedule for PASS Summit 2024 appeared first on SQLServerCentral.
Free DBA Job Interview Q&A Course This Weekend
If you’re facing an upcoming SQL Server DBA job interview, or if you’re a manager who has to […]
Promote Simple Talks podcast episode 2: Coffee chat with Huxley ...
The post Promote Simple Talks podcast episode 2: Coffee chat with Huxley Kendell appeared first on SQLServerCentral.
Express a Number or Currency in Words with T-SQL Code
The post Express a Number or Currency in Words with T-SQL Code appeared first on SQLServerCentral.
Released: SCOM Management Packs for SQL Server, RS, AS and ...
Updates to SQL Server, SQL Server Dashboards, Reporting Services, Analysis Services, and Azure SQL Managed Instance Management Packs […]
[Video] Office Hours with a Special Guest: Count Distinct
I was busy, so I asked a friend to fill in for me and answer your top-voted questions […]
Query Exercise: What Makes SELECT TOP 1 or SELECT MAX ...
These two queries both get the same answer from the Stack Overflow database: SELECT TOP 1 LastAccessDate FROM […]
Surveiller l’adoption des Microsoft Fabric Copilots
Cet article est disponible en Anglais sur LinkedIn : Monitoring Microsoft Fabric Copilot Adoption | LinkedIn. Les […]
Choosing a File Format – Data Engineering with Fabric
Microsoft Fabric has OneLake Storage at the center of all services. This storage is based upon existing Azure […]
The full agenda for the Redgate Summit New York is ...
The post The full agenda for the Redgate Summit New York is live! appeared first on SQLServerCentral.
[Video] I Must Be an Idiot: Automatic Tuning Never Works ...
I don’t get it. I’ve given this feature one chance after another, and every time, it takes a […]
MySQL Index Overviews: B-Tree Indexes
In this first entry in a multipart series on indexes, I will cover the most important index […]
Level up your learning in 2024 with PASS Data Community ...
The post Level up your learning in 2024 with PASS Data Community Summit appeared first on SQLServerCentral.
Create Document Templates in a SQL Server Database Table
The post Create Document Templates in a SQL Server Database Table appeared first on SQLServerCentral.
Git, GitHub and Visual Studio Code for SQL Server
Introduction This article will teach us to integrate Git, GitHub, and Visual Studio Code. Visual Studio Code (VSCode) is […]
Days of the Week, Bitwise Edition
I recently had to help support synchronization and distribution of workloads between multiple servers. Some of this […]
Redgate Summit: The Database Landscape – New York
The post Redgate Summit: The Database Landscape – New York appeared first on SQLServerCentral.
Cumulative Update #28 for SQL Server 2019 RTM
The 28th cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft […]
ODBC Driver 18.4 for SQL Server Released
Version 18.4 of the Microsoft ODBC Driver 18 for SQL Server has been released. Version 18.4 brings some minor […]
JDBC Driver 12.8 for SQL Server Released
Version 12.8 of the Microsoft JDBC Driver for SQL Server has been released. Version 12.8.0 brings several added […]
Génération d’une dimension Date pour les modèles sémantiques en Direct ...
L’un des éléments clés d’un modèle sémantique est la table des dates. Elle fournit une référence pour […]
Who’s Hiring in the Microsoft Data Platform Community? August 2024 ...
Is your company hiring for a database position as of August 2024? Do you wanna work with the […]