[Video] Office Hours in Cartagena, Colombia
Before heading out to Old Town for sightseeing, I went through your top-voted questions from https://pollgab.com/room/brento. Here’s what […]
Tous les articles
The future of AI in solving database challenges
The post The future of AI in solving database challenges appeared first on SQLServerCentral.
Paging Data in T-SQL
Sometimes when working with very large sets of data, you may not want to return all of […]
It’s Monday. Do You Know Where Your PowerShell Training Is?
You’re over the hump! Just two weeks left to go. All month long, I’m giving away our newest […]
ChatGPT and PowerShell – Some practical examples
Introduction to ChatGPT and PowerShell In this article, we will show how to work with ChatGPT and PowerShell. […]
New functions in SQL Server 2022 – LEFT_SHIFT and RIGHT_SHIFT
The post New functions in SQL Server 2022 – LEFT_SHIFT and RIGHT_SHIFT appeared first on SQLServerCentral.
Datafrogs Conférence : Recherche Full-Text
Vous trouverez ici les diapositives et les démonstration de notre session sur la recherche en texte intégral lors […]
SQL 仮想マシンのディスク拡張
こんにちは。日本マイクロソフト SQL Server サポートチームです。 今回は、Azure の SQL VM(SQL Server on Windows Server) のディスク拡張について、よくお問い合わせいただく以下の内容についてご案内します。 【本ブログで紹介させていただく内容】 A. SQL […]
The Basics of PostgreSQL Views
Article Overview This article will help you to understand what is a database view in general and in […]
What are the biggest challenges organizations face in their digital ...
The post What are the biggest challenges organizations face in their digital transformation efforts? appeared first on SQLServerCentral.
SQL Server .WRITE() Function to Update VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX) ...
The post SQL Server .WRITE() Function to Update VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX) Data Types appeared first on SQLServerCentral.
Slow Startup, Failover, and Restore Times with In-Memory OLTP
When In-Memory OLTP came out, I worked with it briefly, and I remember coming away thinking, “Who in […]
Cumulative Update #2 for SQL Server 2022 RTM
The 2nd cumulative update release for SQL Server 2022 RTM is now available for download at the Microsoft […]
The SELECT Statement in Oracle
The SELECT statement is used to retrieve information from a database. Following the execution of a SELECT […]
Announcing Polyglot Notebooks! Multi-language notebooks in Visual Studio Code
We are excited to announce that Polyglot Notebooks, Visual Studio Code’s multi-language notebook extension, is now generally […]
Announcing Data API builder for Azure Cosmos DB
We are super excited to announce the public preview of Data API builder. A new feature that […]
Data API builder for Azure SQL Databases – Public Preview
I am extremely happy and excited to announce the public preview of Data API builder for Azure […]
Recording What’s Changed when Running Oracle Migrations with Flyway
The post Recording What’s Changed when Running Oracle Migrations with Flyway appeared first on SQLServerCentral.
[Video] Office Hours at Sea: Heading to Jamaica
I’m on a boat! I’m on a 10-day Panama Canal cruise, and I stopped (well, not the boat) […]
EF Core 8 Preview 2: Lite and familiar
The second preview of Entity Framework Core (EF Core) 8 is available on NuGet today! Basic information […]
Are PostgreSQL memory parameters magic?
Configuration parameters are the most mythical creatures in the world of PostgreSQL. Ordinary PostgreSQL users often do […]
Better Keep Up: More Free PowerShell Videos This Week.
We’re almost halfway through the month. How’s it coming? You keeping up? Or are you having a tough […]
How to Install the AdventureWorks Sample Database in Azure SQL ...
The post How to Install the AdventureWorks Sample Database in Azure SQL Database appeared first on SQLServerCentral.
Find Invalid Objects in SQL Server
One of the most important responsibilities of any database administrator is to maintain the integrity of the database, […]
[Cross post] Top 25 most common SQL Server Engine Errors ...
Please take a look at the following blog post by @Joseph Pilov (and team) to get detailed explanations, causes, and […]
On-Demand Webinar – Monitoring: The ROI of Build vs. Buy
The post On-Demand Webinar – Monitoring: The ROI of Build vs. Buy appeared first on SQLServerCentral.
How to Implement CI/CD in Azure Data Factory (ADF)
Continuous Integration and Continuous Deployment (CI/CD) are integral parts of the software development lifecycle. As a Data Engineer/ […]
SELECT DISTINCT SQL Command to Return a Unique List of ...
The post SELECT DISTINCT SQL Command to Return a Unique List of Values appeared first on SQLServerCentral.
Build a Better WordPress Archives Page Using MySQL
I recently wrote about a way to generate visual, interactive calendars in HTML by combining a calendar […]
SQL Server 2022: Intel® QuickAssist Technology overview
Part of the SQL Server 2022 blog series. In SQL Server 2008 Enterprise Edition, backup compression was introduced […]
Who’s Hiring in the Microsoft Data Platform Community? March 2023 ...
Is your company hiring for a database position as of March 2023? Do you wanna work with the […]
Complex Production Database Deployments and Flyway
The post Complex Production Database Deployments and Flyway appeared first on SQLServerCentral.
AWS Lambdas with C#
The post AWS Lambdas with C# appeared first on SQLServerCentral.
Why a monitoring tool is an essential tool for growing ...
When I was a DBA involved with the management of a large number of database servers, I […]
Microsoft Drivers 5.11 for PHP for SQL Server Released
We have released Microsoft Drivers for PHP for SQL Server, version 5.11.0. This production release of the SQLSRV […]
I’m Coming to Boston for SQLSaturday!
I’m coming back to Boston for SQLSaturday this October 14th! On Friday the 13th (muhaha), before the event, […]
Synapse Serverless and Dedicated Pool: The differences no one told ...
The basic differences between Synapse Serverless and the Dedicated pool are obvious: While the serverless doesn’t store […]
Optional Code in T-SQL Scripts using SQLCMD
When you are writing T-SQL scripts to save away, for example one to create a new database, […]
It’s Monday. Get Back to Learning PowerShell.
You’re a production database administrator responsible for the health, security, and uptime of many database servers. You’ve been […]
ChatGPT in SQL Server – Practical examples
Introduction ChatGPT in SQL Server In this article, we will learn some basic examples of ChatGPT in SQL […]
Snowflake for SQL Server Developers – NULL Functions – Part ...
The post Snowflake for SQL Server Developers – NULL Functions – Part 2 appeared first on SQLServerCentral.
Understanding Azure Synapse Analytics Pricing
Introduction Azure Synapse Analytics combines data integration, enterprise data warehousing, and data analytics. It is a cloud-based limitless […]
How to Improve the Quality of Database Releases using Clones
The post How to Improve the Quality of Database Releases using Clones appeared first on SQLServerCentral.
Creating Animated Line Plots with Python
The post Creating Animated Line Plots with Python appeared first on SQLServerCentral.
Retrieving MySQL data from within Python
Applications of all types commonly access MySQL to retrieve, add, update, or delete data. The applications might […]
Les index filtrés
Depuis SQL Server 2008, il est possible de créer des index filtrés : des index nonclustered avec un […]
I’m Coming to Gothenburg and Oslo This Fall!
Back in 2020 before the wheels came off the world, I’d scheduled visits to Gothenburg and Oslo for […]
Learn PowerShell in 30 Minutes a Day, Free, Starting Now.
The clock starts now! You’re a production database administrator responsible for the health, security, and uptime of many […]
Testing before coding: shifting farther left
The post Testing before coding: shifting farther left appeared first on SQLServerCentral.
Getting Out of Character
Pre-Unicode Younger programmers have grown up with ASCII and Unicode as the only ways of representing character […]