Boost productivity with ‘Solution Summary’ cards
Solution Summary cards are the name I have given to simple 1-page documents we provide to developers […]
Tous les articles
Released: SCOM Management Packs for SQL Server, RS, AS (7.0.38.0)
Updates to SQL Server, Reporting Services, and Analysis Services Management Packs are available (7.0.38.0). You can download the […]
Implementing ETL Logging on Lakehouse using Delta Lake's Time Travel ...
The post Implementing ETL Logging on Lakehouse using Delta Lake's Time Travel capability appeared first on SQLServerCentral.
Working with T-SQL function AVG ()
This article will explain SQL Server average function, AVG(), and its use cases. Many times, we need to […]
Introducing the SQL Server 2022 blog series
Introducing a new blog post series to highlight new features and enhancements available with SQL Server 2022. SQL […]
Searching through a database via SQL
Imagine that while developing or testing a SQL Server database, you get an error message mentioning a […]
[Video] Office Hours: Professional Development Questions
Most of the questions y’all post at https://pollgab.com/room/brento are technical ones, but there were a handful of interesting […]
How to use Azure-SSIS integration runtime to run SSIS packages ...
Integration runtime for Azure-SQL Server Integration Services (SSIS) makes it possible to simply run SSIS packages in […]
SQL Monitor: On-demand demo [Watch now]
The post SQL Monitor: On-demand demo [Watch now] appeared first on SQLServerCentral.
How to tell what SQL Server versions you are running
The post How to tell what SQL Server versions you are running appeared first on SQLServerCentral.
Is Remote Work the New Normal for DBAs?
An intriguing Office Hours question came in through my PollGab room. Anatoli asked, “Is remote work the new […]
Hybrid Cloud Monitoring
For years database server’s were hosted on either on-premises or colocation data centers. It was straightforward to […]
Parameterizing Azure Policy and Ensuring Azure SQL AD Authentication
I wrote before about enforcing Azure SQL AD Authentication using Azure Policies in two different ways. First, […]
Now is the Right Time for the 2022 Brent Ozar ...
We normally do this in the fall, but given last week’s news, I bet you can understand why […]
SQL Server Sample Databases
Northwind, Pubs, Aventureworks, AdventureworksDW, WideWordImporters, etc are important sample databases used in SQL Server. In this article, we […]
SQL Database Snapshots for Reporting, Auditing and Data Recovery
The post SQL Database Snapshots for Reporting, Auditing and Data Recovery appeared first on SQLServerCentral.
I’m Coming Back to Israel for the Data.TLV Summit!
The Data.TLV Summit on September 15th is a big free conference on data engineering, business intelligence, data analysis, […]
Python Try Except Code Samples
The post Python Try Except Code Samples appeared first on SQLServerCentral.
Randomizing the Day Inside a Month Using T-SQL
I recently ran across an interesting situation in our development databases. We have begun to protect various PII […]
DevOps 101 webinar: The role of Automation
The post DevOps 101 webinar: The role of Automation appeared first on SQLServerCentral.
Early technical preview of JDBC Driver 11.1.2 for SQL Server ...
We have released a new early technical preview of the JDBC Driver for SQL Server which contains several […]
I Wish SQL Server Warned About Hard-Coded Estimates.
I wish we got a yellow bang on execution plans when SQL Server was making up an estimate […]
Real-Time Monitoring of MySQL Server
When an application runs without any glitch in business, no one bothers. However, as soon as the […]
2021 Session video library available
The post 2021 Session video library available appeared first on SQLServerCentral.
How to run Kubernetes clusters locally on Windows
The post How to run Kubernetes clusters locally on Windows appeared first on SQLServerCentral.
Pour One Out for Distributed Replay. It’s Deprecated in SQL ...
I love how Microsoft treats deprecated and discontinued features in SQL Server. No, seriously. I give Microsoft a […]
File-Based Log Monitoring on AWS MYSQL RDS
We have often seen that one solution often does not have multiple different scenarios in the real […]
Power BI Report Builder Expressions – Build In Fields and ...
Power BI Report Builder expressions are an important topic to have smarter and more interactive reports. In this […]
Insights from the SSRS database
The post Insights from the SSRS database appeared first on SQLServerCentral.
Released: Microsoft.Data.SqlClient 5.0 Preview 3
Microsoft.Data.SqlClient 5.0 Preview 3 has been released. This release contains improvements and updates to the Microsoft.Data.SqlClient data provider […]
Hotfix: Microsoft Drivers 5.10.1 for PHP for SQL Server Released
We recently released an update to Microsoft Drivers for PHP for SQL Server, version 5.10.1. The update addresses a […]
SQL Database Overview
The post SQL Database Overview appeared first on SQLServerCentral.
Fixing « The Distributor has not been installed correctly » Error with ...
The Problem To migrate a SQL Server database to AWS or to implement a data migration/transfer strategy to […]
SQL Monitor supports Amazon RDS Monitoring
The post SQL Monitor supports Amazon RDS Monitoring appeared first on SQLServerCentral.
What’s new with SQL Tools
Hello community, the June release of Azure Data Studio 1.37 is here! We are also excited to announce […]
MYSQL Long Running Queries
When any business or application begins, the amount of the data is limited, and the complexity of […]
Introducing the MySQL SELECT statement
The series so far: Getting started with MySQL Working with MySQL tables Working with MySQL views Working […]
Recapping recent updates to client tools in SQL Server
Hello from the SQL Experiences team! As a follow-up to Microsoft Build at the end of May, we […]
New Buying Option: Lifetime Access to Class Recordings
Wanna buy my Recorded Class Season Pass: Fundamentals or Mastering, but you don’t want an annual subscription? Now […]
Find Database File Latency – SQL in Sixty Seconds #198
Lots of people asked me to create a video on my earlier blog post SQL SERVER – […]
Security Update for SQL Server 2019 RTM CU16
The Security Update for SQL Server 2019 RTM CU16 is now available for download at the Microsoft Download […]
Security Update for SQL Server 2017 RTM CU29
The Security Update for SQL Server 2017 RTM CU29 is now available for download at the Microsoft Download […]
Security Update for SQL Server 2016 SP3 Azure Connect Feature ...
The Security Update for SQL Server 2016 SP3 Azure Connect Feature Pack GDR is now available for download […]
Summit 2022 Community Pre-cons have been announced
The post Summit 2022 Community Pre-cons have been announced appeared first on SQLServerCentral.
Introduction to artificial intelligence
The post Introduction to artificial intelligence appeared first on SQLServerCentral.
Understanding Shared Access Signature and Access Policy in Azure Storage
Introduction You may want to provide access to the files from your Azure storage account container, there are […]
Security Update for SQL Server 2016 SP3 GDR
The Security Update for SQL Server 2016 SP3 GDR is now available for download at the Microsoft Download […]
Security Update for SQL Server 2016 SP2 CU17
The Security Update for SQL Server 2016 SP2 CU17 is now available for download at the Microsoft Download […]
Announcing Entity Framework 7 Preview 5
Entity Framework 7 (EF7) Preview 5 has shipped with support for Table-per-Concrete type (TPC) mapping. This blog […]
[Video] Office Hours: Palm Springs, California Edition
On a road trip from San Diego to Vegas, I stopped in Palm Springs and answered your highly-upvoted […]