Snowflake Temporary Tables vs. Transient Tables
The post Snowflake Temporary Tables vs. Transient Tables appeared first on SQLServerCentral.
Archives du mois : mars 2023
Shrink Database Log Files One by One
I have about 25-30 client databases on my computer for testing purposes when I support or do new […]
GENERATE_SERIES: My new go-to to build sets
I have come across a lot of use cases for manufacturing rows on the fly, aside from […]
Generic ODBC external data sources may not work after installing ...
Symptoms After you install SQL Server 2019 CU19 or SQL Server 2022 CU2, external data sources using […]
Update XML files using PowerShell
There are many blogs on internet already speaking about updating XML files in PowerShell, but I felt […]
A Beginners Guide to MySQL Replication Part 1
MySQL Replication is a process where data from one MySQL database known as the source (formerly called […]
Let's make it easy! How to read System Health and ...
Hi Everyone, The system_health session is an extended event session that is included by default with SQL […]
[Video] Office Hours: Ask Me Anything About SQL Server in ...
Off the coast of Costa Rica, I went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: […]
Data API Builder Quickstart Demo from VS Live Vegas
I was fortunate enough to be able to present Data API builder the week of March 20th […]
Piping, Filtering and Using Flyway Output in PowerShell
The post Piping, Filtering and Using Flyway Output in PowerShell appeared first on SQLServerCentral.
The role of forethought for a computer engineer
If you have ever played a game of chess against someone good, or perhaps against a computer, […]
Accelerated Database Recovery enhancements in SQL Server 2022
Part of the SQL Server 2022 blog series. We are excited to share that there are several Accelerated Database […]
Is SQL Server 2019 More CPU-Intensive Than SQL Server 2016?
I’m running into something that I’m having a hard time believing. A client was hitting CPU issues during […]
The Curious Case of…. alcoholism
Hello, my name is Paul, and I’m a high-functioning alcoholic. For the last ten years or so, I’ve […]
Using Virtual Network Data Gateways to Secure Access to Azure ...
Power BI and Azure are two related services, but with a considerable independence between them. Power BI […]
This is the Last Week of Free PowerShell Training.
You’ve been working hard all month to get through our newest class, Fundamentals of PowerShell for DBAs. This week, […]
SQL Server – Recherche Full-Text
Conférence Datafrogs de mars 2023 : « une histoire de mots… l’indexation textuelle ». Explorons en détail les fonctionnalités de […]
How to use the SQL WHERE Clause with Examples
The post How to use the SQL WHERE Clause with Examples appeared first on SQLServerCentral.
Passing parameters to query without TVFs
Problem Statement You have a need to extract data from a table or view with 1 or more […]
Database Monitoring: The ROI of Build vs. Buy
The post Database Monitoring: The ROI of Build vs. Buy appeared first on SQLServerCentral.
Une histoire de mots… l’indexation textuelle
Frédéric Brouard, SQL Spot : https://www.linkedin.com/in/frederic-brouard-alias-sqlpro-914761 et Arian Papillon, Datafly, MVP : https://www.linkedin.com/in/arianpapillon/ S’il existe des outils […]
Les nouveautés SQL Server 2022
Julien Pierre, Microsoft et Pascal Deliot, Microsoft 2022 a été marqué par de bien nombreux événements : […]
Adoptez une approche Lakehouse pour vos projets BI avec Azure ...
Sébastien Kobenan, Exakis Nelite Data Warehouse ou Data Lake ? Ne choisissez plus. Adoptez une approche Lakehouse. […]
Les bonnes mauvaises pratiques des groupes de disponibilité AlwaysOn
Amar Adghar, Microsoft et Stéphane Scherrer, Microsoft Depuis dix ans, les Groupes de Disponibilité (AG pour Availability […]
SQL Server, les structures de données
Christophe Laporte, ConseilIt, MVP Tout développeur ou administrateur de bases de données devrait comprendre comment SQL Server […]
Azure Synapse, en avant les pools
Avec l’arrivé d’Azure Synapse Analytics, nous avons à disposition des pools Dedicated et Serveless. On fait le […]
How to Connect SQL Server and Create C# Objects for ...
If you’re a developer or a database administrator, you undoubtedly know that SQL Server and other relational database […]
SQL Server, Oracle and PostgreSQL Database Security Roles, Schemas, Grants, ...
The post SQL Server, Oracle and PostgreSQL Database Security Roles, Schemas, Grants, Privileges and Owners – Part II […]
Thought Leadership resource page
The post Thought Leadership resource page appeared first on SQLServerCentral.
Announcing the New Azure Cosmos DB Desktop Data Migration Tool
Today we’re excited to introduce a brand new Azure Cosmos DB Desktop Data Migration Tool. You can […]
Office Hours: Questions That Didn’t Make the Cut
Sometimes, y’all post questions at https://pollgab.com/room/brento and they don’t get a lot of upvotes, and reading through ’em, […]
Updating SQL Server containers deployed on Kubernetes!
I’m sure you’ve thought about how to update SQL Server containers running on a Kubernetes cluster at some […]
[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 […]
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.