Microsoft Drivers 5.10 for PHP for SQL Server ReleasedWe have released Microsoft Drivers for PHP for SQL Server, version 5.10.0. This production release of the SQLSRV […] 31 janvier 2022 dans Sites Microsoft par MS Tech Community
7 Trends in DB DevOps & Monitoring: The infographicThe post 7 Trends in DB DevOps & Monitoring: The infographic appeared first on SQLServerCentral. 31 janvier 2022 dans Sites anglophones étiqueté db devops / monitoring / Vendors/3rd-party Products par sqlservercentral.com
Creating a Database and Tables in PostgreSQL: Learning PostgreSQL with ...The post Creating a Database and Tables in PostgreSQL: Learning PostgreSQL with Grant appeared first on SQLServerCentral. 31 janvier 2022 dans Sites anglophones étiqueté postgres / PostGreSQL par sqlservercentral.com
PostgreSQL in Azure Data StudioAzure Data Studio (ADS) comes with an extension to access a PostgreSQL database. In this article, we will […] 31 janvier 2022 dans Sites anglophones étiqueté Azure Data Studio / PostGreSQL par sqlservercentral.com
Cumulative Update #15 for SQL Server 2019 Big Data ClustersToday, we announce the release of the latest cumulative update, CU15, for SQL Server Big Data Clusters. Improvements […] 28 janvier 2022 dans Sites Microsoft par MS Tech Community
Cumulative Update #15 for SQL Server 2019 RTMThe 15th cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft […] 28 janvier 2022 dans Sites Microsoft par MS Tech Community
Is Your SSIS Catalog Migration ReadyAre you planning to migrate your SSIS Catalog to a newer version of SQL Server? You might like […] 28 janvier 2022 dans Sites anglophones étiqueté SSIS Catalog Compare / SSIS Catalog migration par sqlservercentral.com
SQL Server Monitoring Using Free ToolsDo you sometimes wonder how the pieces of your SQL Server systems are doing over time? Do you […] 28 janvier 2022 dans Sites anglophones étiqueté Database / Database Administration / database monitoring / Databases / monitoring / SQL Server / sql server agent / t-sql / Transact SQL / TSQL / Uncategorized par sqlservercentral.com
Install SQL Server and Oracle using PowerShell and Windows ContainersThe post Install SQL Server and Oracle using PowerShell and Windows Containers appeared first on SQLServerCentral. 28 janvier 2022 dans Sites anglophones étiqueté data platform / Oracle / PowerShell par sqlservercentral.com
Debugging Flyway Callbacks and Migrations that Use PlaceholdersThe post Debugging Flyway Callbacks and Migrations that Use Placeholders appeared first on SQLServerCentral. 28 janvier 2022 dans Sites anglophones étiqueté flyway / Vendors/3rd-party Products par sqlservercentral.com
[Video] Office Hours: Ask Me Anything About SQL Server in ...I watched the sun rise from my balcony in Cabo this morning and answer your questions from https://pollgab.com/room/brento. […] 27 janvier 2022 dans Sites anglophones étiqueté Videos par brentozar.com
How to Integrate Azure DevOps with Azure Synapse StudioThere are two ways you can develop and execute code in Azure Synapse Studio: Synapse live development Git […] 26 janvier 2022 dans Sites anglophones étiqueté Azure DevOps Git / Azure Synapse (formerly Azure SQL Data Warehouse) / Azure Synapse Analytics par sqlservercentral.com
Testing a Flyway Database MigrationThe post Testing a Flyway Database Migration appeared first on SQLServerCentral. 26 janvier 2022 dans Sites anglophones étiqueté flyway / Vendors/3rd-party Products par sqlservercentral.com
Crowdsourcing quality: Can the hive mind/herd mentality help you in ...The post Crowdsourcing quality: Can the hive mind/herd mentality help you in software testing? appeared first on SQLServerCentral. 26 janvier 2022 dans Sites anglophones étiqueté DevOps / DevOps and Continuous Delivery (CI/CD) / Test / Testing par sqlservercentral.com
When Should You Use DESC in Indexes?The short answer is that if your query orders columns by a mix of ascending and descending order, […] 25 janvier 2022 dans Sites anglophones étiqueté indexing par brentozar.com
Working with Fail Activity in Azure Data FactoryIntroduction In this article, we will talk about a newly introduced activity in Azure Data Factory, which is […] 24 janvier 2022 dans Sites anglophones étiqueté Azure / Azure Data Factory par sqlservercentral.com
Exploring the Flyway Schema History TableThe post Exploring the Flyway Schema History Table appeared first on SQLServerCentral. 24 janvier 2022 dans Sites anglophones étiqueté flyway / Vendors/3rd-party Products par sqlservercentral.com
How to replace an identity column with a sequence numberThe post How to replace an identity column with a sequence number appeared first on SQLServerCentral. 24 janvier 2022 dans Sites anglophones étiqueté Learn SQL / learning / SQL Server par sqlservercentral.com
Negative Blocking Session Ids (-5 = Latch ANY TASK RELEASOR)SQL Server may report a blocking session id as a negative integer value. SQL Server uses negative sessions ids […] 22 janvier 2022 dans Sites Microsoft par MS Tech Community
Prevent Accidental Data Deletion in Azure Storage Container with Soft ...Introduction While working with Azure Storage, data might be accidentally or erroneously deleted. We can prevent the total […] 21 janvier 2022 dans Sites anglophones étiqueté Azure / Azure Storage par sqlservercentral.com
Choosing Between SQL Server Integration Services and Azure Data FactoryThe post Choosing Between SQL Server Integration Services and Azure Data Factory appeared first on SQLServerCentral. 21 janvier 2022 dans Sites anglophones étiqueté Azure / Azure Data Factory par sqlservercentral.com
The Redgate Advocates Predict… 3 Key Challenges to Overcome in ...The post The Redgate Advocates Predict… 3 Key Challenges to Overcome in 2022 appeared first on SQLServerCentral. 21 janvier 2022 dans Sites anglophones étiqueté Vendors/3rd-party Products par sqlservercentral.com
Released: Microsoft.Data.SqlClient 4.0.1We have released an update to Microsoft.Data.SqlClient, version 4.0.1. The update addresses several issues that are important to […] 20 janvier 2022 dans Sites Microsoft par MS Tech Community
Playing popular game of Wordle using T-SQLA current frenzy surrounding the game of Wordle has swept the community. I have been playing this game […] 19 janvier 2022 dans Sites anglophones étiqueté games / stored procedures / t-sql / T-SQL Challenges / Transact SQL par sqlservercentral.com
Reporting on Changes Made by Flyway Migration ScriptsThe post Reporting on Changes Made by Flyway Migration Scripts appeared first on SQLServerCentral. 19 janvier 2022 dans Sites anglophones étiqueté flyway / migrations / Vendors/3rd-party Products par sqlservercentral.com
SQL Identity Column Gaps and Conversion in SQL Server, Oracle ...The post SQL Identity Column Gaps and Conversion in SQL Server, Oracle and PostgreSQL appeared first on SQLServerCentral. 19 janvier 2022 dans Sites anglophones étiqueté cross platform / multi-platform par sqlservercentral.com
Updated First Responder Kit and Consultant Toolkit for January 2022In this release, sp_Blitz shows some information about clusters and AGs, sp_AllNightLog and sp_DatabaseRestore get some love, and […] 18 janvier 2022 dans Sites anglophones étiqueté First Responder Kit Updates par brentozar.com
dbaTools – Mise en oeuvre des groupes de disponibilitéL’utilisation de PowerShell est devenue un standard de l’administration, y compris pour les DBAs. Bien qu’il existe des […] 18 janvier 2022 dans Sites francophones étiqueté Non classé par conseilit.wordpress.com
SQL Server Dacpac in Azure Data StudioIntroduction This article will introduce you to the SQL Server Dacpac in Azure Data Studio. We will also […] 17 janvier 2022 dans Sites anglophones étiqueté Azure Data Studio / bacpac / dacpac par sqlservercentral.com
Where’s the best place to live as a DBA?The post Where’s the best place to live as a DBA? appeared first on SQLServerCentral. 17 janvier 2022 dans Sites anglophones étiqueté DBA / RedGate / Vendors/3rd-party Products par sqlservercentral.com
Power BI Zoom and FocusThe post Power BI Zoom and Focus appeared first on SQLServerCentral. 17 janvier 2022 dans Sites anglophones étiqueté BI / Power BI par sqlservercentral.com
Datafrogs : les very LARGE databases (VLDB)Aujourd’hui, c’était les datafrogs, une journée de conférences organisée par notre ami Rudi Bruchez. J’ai eu le plaisir […] 15 janvier 2022 dans A la Une / Sites francophones par blog.datafly.pro
Error Handling Quiz Week: Where Are You Handling Errors?This week’s series on error handling has been an eye opener for many of us. We’ve laughed. We’ve […] 14 janvier 2022 dans Sites anglophones étiqueté t-sql par brentozar.com
Quantifier predicatesThe post Quantifier predicates appeared first on SQLServerCentral. 14 janvier 2022 dans Sites anglophones étiqueté Databases / Programming / t-sql par sqlservercentral.com
Performance Tuning Using Free Tools, Part 2Does the cost of running SQL Server often surprise you? The cost may come from buying on-premises hardware […] 14 janvier 2022 dans Sites anglophones étiqueté Database Administration / Performance Tuning / query optimization / SQL Query / SQL Server / t-sql / Tools for development / Transact SQL / TSQL par sqlservercentral.com
A Database DevOps Workflow Using Redgate DeployThe post A Database DevOps Workflow Using Redgate Deploy appeared first on SQLServerCentral. 14 janvier 2022 dans Sites anglophones étiqueté db devops / Vendors/3rd-party Products par sqlservercentral.com
Cumulative Update #28 for SQL Server 2017 RTMThe 28th cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft […] 13 janvier 2022 dans Sites Microsoft par MS Tech Community
Error Handling Quiz Week: Making a Turkey Sandwich with XACT_ABORTCAN YOU BELIEVE THAT HOT MESS IN YESTERDAY’S POST?!? I know, right? You thought that by combining try/catch […] 13 janvier 2022 dans Sites anglophones étiqueté t-sql par brentozar.com
A Fond FarewellIf you haven’t guessed from the title, I’m writing this post because I am leaving SQLskills. This Friday, […] 12 janvier 2022 dans Sites anglophones étiqueté Uncategorized par SQLSkills.com - Erin Stellato
The Curious Case of… tracking page compression success rates(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post […] 12 janvier 2022 dans Sites anglophones étiqueté partitioning / The Curious Case of... par sqlskills.com - paul randall
Error Handling Quiz Week: Combining Transactions And TRY/CATCHIn yesterday’s epic cliffhanger, you might have been shocked to discover that a plain ol’ transaction does not […] 12 janvier 2022 dans Sites anglophones étiqueté t-sql par brentozar.com
Creating a SQL Server Agent Job to Run Python Scripts ...The post Creating a SQL Server Agent Job to Run Python Scripts in a Virtual Environment appeared first […] 12 janvier 2022 dans Sites anglophones étiqueté Python / sql server agent par sqlservercentral.com
Automating Flyway UndosThe post Automating Flyway Undos appeared first on SQLServerCentral. 12 janvier 2022 dans Sites anglophones étiqueté flyway / Vendors/3rd-party Products par sqlservercentral.com
Error Handling Quiz Week: Will a Transaction Help?In yesterday’s post, we tried a TRY/CATCH, and those of us who actually ran the demo scripts were […] 11 janvier 2022 dans Sites anglophones étiqueté SQL Server par brentozar.com
Get a Hadoop Sandbox for testing/troubleshooting POLYBASE and Hadoop in ...This guide will take you step by step into deploying a hadoop sandbox into Azure. You then will […] 10 janvier 2022 dans Sites Microsoft par SQL Server Support Blog
Error Handling Quiz Week: Tryin’ TRY/CATCHLet’s say we have two tables, Parent and Child, and we need to guarantee that they both get […] 10 janvier 2022 dans Sites anglophones étiqueté t-sql par brentozar.com
Getting Started with Cloud-hosted Databases using SpawnThe post Getting Started with Cloud-hosted Databases using Spawn appeared first on SQLServerCentral. 10 janvier 2022 dans Sites anglophones étiqueté spawn / Vendors/3rd-party Products par sqlservercentral.com
How to filter DAX for paginated reportsThe post How to filter DAX for paginated reports appeared first on SQLServerCentral. 10 janvier 2022 dans Sites anglophones étiqueté BI par sqlservercentral.com
The Changing Landscape of Information ManagementIntroduction In today’s world, data is considered the new gold. Every enterprise is in a rush to gather […] 10 janvier 2022 dans Sites anglophones par sqlservercentral.com
Query control made easyOverview As we all know, data security is a never-ending battle. Every day, we hear of new data […] 7 janvier 2022 dans Sites anglophones étiqueté Security / SQL Server par sqlservercentral.com