[Video] Office Hours: Hot Tub Edition
Today’s Office Hours comes from a very different office! I climbed into the hot tub to review your […]
Archives de l’année : 2024
What Every DBA Should Know about Always On Readable Secondaries
This article aims to demonstrate the lesser-known impact of Always On Readable secondaries. In this article, we will […]
Redgate Summit: The Database Landscape
The post Redgate Summit: The Database Landscape appeared first on SQLServerCentral.
Query Exercise: Find Recent Superstars
For this week’s Query Exercise, we’re working with the Stack Overflow database, and our business users have asked […]
Finding Long Values Faster: Answers & Discussion
In last week’s Query Exercise, our developers had a query that wasn’t going as fast as they’d like: […]
Dynamically Create Tables in Power BI with DAX Functions
The post Dynamically Create Tables in Power BI with DAX Functions appeared first on SQLServerCentral.
Forget the Models, Your Data is the Secret Sauce for ...
Credit: Image generated by Google Bard Generative AI (GenAI) models like GPT, Gemini, PaLM, DALL-E, and others offer […]
#TSQL2sday Roundup: The Most Recent Issues You Closed.
For this month’s TSQLTuesday, I asked y’all to describe the most recent issues you closed. If you ask […]
Database Feature Toggles
In software development the concept of feature toggles are used to selectively turn on and off features. […]
Tutorial: Using the hierarchyid Data Type
The post Tutorial: Using the hierarchyid Data Type appeared first on SQLServerCentral.
Released: SQL Server 3rd Party Backend for Django v1.4
We have released version 1.4 of the SQL Server 3rd Party Backend for Django. This release contains support […]
Microsoft Drivers 5.12 for PHP for SQL Server Released
We have released Microsoft Drivers for PHP for SQL Server, version 5.12.0. This production release of the SQLSRV […]
JDBC Driver 12.6 for SQL Server Released
Version 12.6 of the Microsoft JDBC Driver for SQL Server has been released. Version 12.6.0 brings several added […]
Upcoming changes for SQL Server Management Studio (SSMS) – Part ...
Welcome to the first of three blog posts about the next releases of SQL Server Management Studio (SSMS), […]
[Video] Office Hours: Ask Me Anything About Microsoft Databases
Post your database questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss on the […]
SQL Server サービスが OS の起動時に自動起動してこなかった場合の対処策について
こんにちは。SQL Server サポート チームです。 今回は、OS の起動時に、 SQL Server サービスの起動が指定時間内に開始要求または制御要求に応答しないことでサービスの起動に失敗する場合の対処策についてご紹介します。 事象SQL Server サービスのスタートアップの種類が自動となっている場合、OS起動時に SQL Server サービスも自動で起動されます。その際に、サービス起動タイムアウト時間である30秒以内にサービスが起動できない場合があり、システム イベントログに次のようなエラーが記録され、起動に失敗します。 […]
JQ – Tool for Querying JSON documents using the CLI
In my role as a Data Engineer, I have an ever-increasing need for Querying JSON documents using the […]
Functions and Procedures: Learning PostgreSQL with Grant
One of the most useful constructs in SQL Server is the stored procedure. It gives you a […]
Cumulative Update #25 for SQL Server 2019 RTM
The 25th cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft […]
How SQL developers can maximize savings
Whether you build applications for SQL Server on-premises or in Azure, there are several options for you to […]
Query Exercise: Finding Long Values Faster
Our developers have come to us with a problem query that isn’t as fast as they’d like. Using […]
Improving Cardinality Estimation: Answers & Discussion
Your challenge for last week was to take this Stack Overflow database query to show the top-ranking users […]
Attention SQLBits 2024 Attendees!
Get ready to soar into SQLBits 2024 with us in Farnborough, UK March 19th – 23rd! Join keynote […]
Scientific Calculations in Power BI – Cube, Square, Logarithms, Powers, ...
The post Scientific Calculations in Power BI – Cube, Square, Logarithms, Powers, Inverse and more appeared first on […]
The Last Ticket/Issue I Closed #TSQL2sday
For this month’s T-SQL Tuesday, I asked y’all to write about the most recent ticket or issue that […]
SQL ConstantCare® Population Report: Winter 2023
The short story: SQL Server 2019 continues its utter domination of the Microsoft data platform landscape this quarter. […]
Tracer l'activité des développeurs sur la production
Hélas, on a laissé jouer les développeurs sur la base de production ! Question posée : par quel […]
Leave it better than you found it
This is for the folks who still have to log into remote machines and do work manually […]
Writing SQL Server code with AI using GitHub Copilot
Introduction In this article, we will see how to work with GitHub Copilot. GitHub copilot is an interesting […]
Planning a Database Testing Strategy for Flyway
The post Planning a Database Testing Strategy for Flyway appeared first on SQLServerCentral.
Automating BCP with PowerShell
I was talking with a good friend that has an environment with terabytes of information and to […]
[Video] Office Hours: Lumberjack Edition
On a chilly January day, I went through your top-voted questions from https://pollgab.com/room/brento. Yes, it actually gets cold […]
Fun with Powershell
The post Fun with Powershell appeared first on SQLServerCentral.
Use a Table Variable for Logging Entries that Need to ...
Introduction Table variables are special types of local variables that can be used to store data temporarily, similar […]
LangChain Prompt Templates with OpenAI LLMs
The post LangChain Prompt Templates with OpenAI LLMs appeared first on SQLServerCentral.
Query Exercise: Improving Cardinality Estimation
Your challenge for this week is to tune a query. Say Stack Overflow has a dashboard that shows […]
Database Changes to Find Tagged Questions Faster: Answers and Discussion
In the last Query Exercise discussion, we hit a performance wall when we were trying to quickly find […]
Dimensional Modeling Case Study Part 2 – Days Dimension
Introduction In our second case study on dimensional modelling, we delve into the intricacies of managing time-related dimensions, […]
#TSQL2sday Invitation: Describe the Most Recent Issue You Closed.
T-SQL Tuesday is a monthly blogothon where we get together and write about a different topic. I’m hosting […]
L'étude 2024 de Red Gate sur l'état de l'art en ...
Le rapport 2024 de l’éditeur américain Red Gate sur l’utilisation des outils de bases de données a […]
Resolving the MERGE statement attempted to UPDATE or DELETE the ...
The post Resolving the MERGE statement attempted to UPDATE or DELETE the same row more than once error […]
Announcing the first Microsoft Fabric Community Conference!
We are excited to welcome attendees to the 1st Microsoft Fabric Community Conference (previously known as the Data […]
Fixing the Synapse Error « Available workspace capacity exceeded error (Livy ...
If you are working with Notebooks in Azure Synapse Analytics and multiple people are using the same Spark […]
Deploying Azure SQL Database Using an ARM Template
Provisioning infrastructure in a timely and reliable manner is essential for agile development. One well-liked method that lets […]
Adding an AI Policy for Authors
In the last few months, we’ve noticed quite a bit of content submitted that seems overly structured in […]
Microsoft Fabric, la solution décisionnelle pour toutes les entreprises – ...
L’événement de l’aMS de Strasbourg a eu lieu le 18 janvier 2024. Cette fois-ci l’événement a eu […]
Office Hours: PowerBI & Fabric Q&A with Eugene Meidinger
Today’s Office Hours has a different topic. Eugene Meidinger dropped by to answer your business intelligence questions. Follow […]
Who’s Hiring in the Microsoft Data Platform Community? February 2024 ...
Is your company hiring for a database position as of February 2024? Do you wanna work with the […]
Feature Flags in Data Projects
My motivation for writing this summary was an interaction with a project owner that didn’t understand why […]
Released: Microsoft.Data.SqlClient 5.1.5
We have released an update to Microsoft.Data.SqlClient, version 5.1.5. The update addresses several issues that are important to […]