How to Create a FOR Loop in SQL ServerThe post How to Create a FOR Loop in SQL Server appeared first on SQLServerCentral. 31 décembre 2021 dans Sites anglophones étiqueté t-sql par sqlservercentral.com
Run Queries Across Many Data Sources at Once with the ...The CData Query Federation Driver, allows you to federate and aggregate data across drivers as a single database connection. […] 31 décembre 2021 dans Sites anglophones étiqueté Automation / Connectivity / integration par sqlservercentral.com
Dealing with Failed SQL Migrations in MariaDB or MySQLThe post Dealing with Failed SQL Migrations in MariaDB or MySQL appeared first on SQLServerCentral. 31 décembre 2021 dans Sites anglophones étiqueté flyway / Vendors/3rd-party Products par sqlservercentral.com
A Day in the Life of a SQL Server Data ...The post A Day in the Life of a SQL Server Data Architect appeared first on SQLServerCentral. 29 décembre 2021 dans Sites anglophones étiqueté Career / Career Growth par sqlservercentral.com
DBAs at work #3: The finance company Manager DBAThe post DBAs at work #3: The finance company Manager DBA appeared first on SQLServerCentral. 29 décembre 2021 dans Sites anglophones étiqueté DBA / Vendors/3rd-party Products par sqlservercentral.com
Meetup du Club Power BI, noël 2021Le 21 décembre 2021, le Club Power BI a animé son nouveau meetup de noël et c’est […] 27 décembre 2021 dans Sites francophones étiqueté 2021 / business intelligence / Club Power BI / Evènements / Mes sessions / Power BI par blog.pgeiger.net
Learn about SQL Joins on Multiple ColumnsThe post Learn about SQL Joins on Multiple Columns appeared first on SQLServerCentral. 27 décembre 2021 dans Sites anglophones étiqueté join par sqlservercentral.com
Flyway with MariaDB for Those of a Nervous DispositionThe post Flyway with MariaDB for Those of a Nervous Disposition appeared first on SQLServerCentral. 27 décembre 2021 dans Sites anglophones étiqueté flyway / Vendors/3rd-party Products par sqlservercentral.com
Views in SQL Server 2019 with SSMSIn SQL Server, a view is a virtual table with contents that you define by means of a […] 27 décembre 2021 dans Sites anglophones étiqueté @SQLServer / Management Studio (SSMS) / SQL Server 2019 / SSMS / Views par sqlservercentral.com
CData Connect: Derived Views and Query FederationEnterprise-scale data integration demands scalable tools to not only centralize and curate data at scale, but also efficiently […] 24 décembre 2021 dans Sites anglophones étiqueté Automation / Connectivity / integration par sqlservercentral.com
Implementing Deduplication Logic in the Lakehouse using Synapse Analytics Mapping ...The post Implementing Deduplication Logic in the Lakehouse using Synapse Analytics Mapping Data Flow appeared first on SQLServerCentral. 24 décembre 2021 dans Sites anglophones étiqueté Azure / Azure Synapse (formerly Azure SQL Data Warehouse) / Azure Synapse Analytics par sqlservercentral.com
Bulk Loading Data via a PowerShell Script in FlywayThe post Bulk Loading Data via a PowerShell Script in Flyway appeared first on SQLServerCentral. 24 décembre 2021 dans Sites anglophones étiqueté flyway / Vendors/3rd-party Products par sqlservercentral.com
The SQL Server Posts You Read the Most in 2021I think of my blog posts in a few different categories: Posts that will only be read at […] 23 décembre 2021 dans Sites anglophones étiqueté SQL Server par brentozar.com
[Video] Office Hours: SQL Server at SunsetLet’s kick back with a tasty beverage and go through your highest-upvoted questions from https://pollgab.com/room/brento on the beach: […] 22 décembre 2021 dans Sites anglophones étiqueté Videos par brentozar.com
Unity state machine behavioursThe post Unity state machine behaviours appeared first on SQLServerCentral. 22 décembre 2021 dans Sites anglophones étiqueté SQL Server par sqlservercentral.com
Adding Test Data to Databases During Flyway MigrationsThe post Adding Test Data to Databases During Flyway Migrations appeared first on SQLServerCentral. 22 décembre 2021 dans Sites anglophones étiqueté flyway / migrations / Vendors/3rd-party Products par sqlservercentral.com
Early technical preview of JDBC Driver 10.1.0 for SQL Server ...We have released a new early technical preview of the JDBC Driver for SQL Server which contains a […] 21 décembre 2021 dans Sites Microsoft par MS Tech Community
Check Your SQL Server Backup Performance & Safety with sp_BlitzBackupsOut of all of the scripts in our free First Responder Kit, sp_BlitzBackups is probably the one you’ve […] 21 décembre 2021 dans Sites anglophones étiqueté Backup and Recovery / First Responder Kit par brentozar.com
Released: SCOM Management Packs for SQL Server, RS, AS, Azure ...Updates to SQL Server, Reporting Services, Analysis Services, and Azure SQL Managed Instance Management Packs are available (7.0.34.0). […] 21 décembre 2021 dans Sites Microsoft par MS Tech Community
Why cloud and hybrid estates are important – but bring ...The post Why cloud and hybrid estates are important – but bring complexity appeared first on SQLServerCentral. 20 décembre 2021 dans Sites anglophones étiqueté Cloud Computing / sql monitor / Vendors/3rd-party Products par sqlservercentral.com
Is SQL Server Profiler in Azure Data Studio?Introduction Do we have the SQL Profiler in Azure Data Studio? In a previous article, we compared SSMS […] 20 décembre 2021 dans Sites anglophones étiqueté Azure Data Studio / Profiler par sqlservercentral.com
Working with PowerShell stringsThe post Working with PowerShell strings appeared first on SQLServerCentral. 20 décembre 2021 dans Sites anglophones étiqueté PowerShell / sysadmin par sqlservercentral.com
AG force failover to DR, then reconnect to Prod nodes. ...I made a test in my testing environment. Below are my test results I have 3 nodes […] 19 décembre 2021 dans Sites Microsoft par SQL Server Support Blog
sp_helprotect is very useful in permission issue1. Customer wants to use a non-sysadmin user — Test to execute ‘xp_cmdshell’. Below scripts works fine in my […] 19 décembre 2021 dans Sites Microsoft par SQL Server Support Blog
Guidance on Apache Log4j Remote Code Execution VulnerabilityMicrosoft published guidance regarding Log4j 2 vulnerability for customers using Azure Data services. Please find the latest information […] 18 décembre 2021 dans Sites Microsoft par MS Tech Community
Performance Tuning Using Free ToolsDo you frequently upgrade your on-premises hardware in order to keep a certain level of performance? Are your […] 17 décembre 2021 dans Sites anglophones étiqueté Database Performance / DBA Tools / Free tools / Performance Tuning / SQL Server par sqlservercentral.com
Did you know SQL Monitor supports Azure databases, too?The post Did you know SQL Monitor supports Azure databases, too? appeared first on SQLServerCentral. 17 décembre 2021 dans Sites anglophones étiqueté Azure / sql monitor / Vendors/3rd-party Products par sqlservercentral.com
Editing API Driver API ProfilesRESTful APIs offer a straightforward way for businesses to work with external data and offer access to their […] 17 décembre 2021 dans Sites anglophones étiqueté Automation / Connectivity / Database / integration par sqlservercentral.com
Connecting to PostgreSQL: Learning PostgreSQL with GrantThe post Connecting to PostgreSQL: Learning PostgreSQL with Grant appeared first on SQLServerCentral. 17 décembre 2021 dans Sites anglophones étiqueté postgres / PostGreSQL par sqlservercentral.com
Announcing new features for the SQL IaaS Agent Extension!As mentioned by Pam in the blog (SQL Server on Azure VM – Now with 30% better price-performance on […] 16 décembre 2021 dans Sites Microsoft par MS Tech Community
[Video] Office Hours: SQL Server Q&A in Cabo at SunriseLet’s watch the sun rise at Land’s End and cover your top-voted questions from https://pollgab.com/room/brento/. Here’s what we […] 16 décembre 2021 dans Sites anglophones étiqueté Videos par brentozar.com
[Video] Office Hours: First Post From CaboJoin me on my balcony in Cabo as I review your top-rated questions from https://pollgab.com/room/brento. Here’s what we […] 15 décembre 2021 dans Sites anglophones étiqueté Videos par brentozar.com
BETWEEN the two of usThe post BETWEEN the two of us appeared first on SQLServerCentral. 15 décembre 2021 dans Sites anglophones étiqueté t-sql par sqlservercentral.com
DBAs at work #2: The airline DBAThe post DBAs at work #2: The airline DBA appeared first on SQLServerCentral. 15 décembre 2021 dans Sites anglophones étiqueté sql monitor / Vendors/3rd-party Products par sqlservercentral.com
Don’t Use SQL Server to Send Emails.I would like to unsubscribe from this idea. I’m not talking about Agent alerts when jobs fail. That’s […] 14 décembre 2021 dans Sites anglophones étiqueté Production Database Administration par brentozar.com
How to create Linked server from SQL Server to Azure ...Here in this blog, we are going to demo how to configure Linked server from on-prem SQL Server instance to Azure SQL database. I will have a […] 14 décembre 2021 dans Sites Microsoft par MS Tech Community
Raw Data Ingestion into Delta Lake Bronze tables using Azure ...The post Raw Data Ingestion into Delta Lake Bronze tables using Azure Synapse Mapping Data Flow appeared first […] 13 décembre 2021 dans Sites anglophones étiqueté Azure / Azure Synapse (formerly Azure SQL Data Warehouse) par sqlservercentral.com
A Flyway Teams Callback Script for Auditing SQL MigrationsThe post A Flyway Teams Callback Script for Auditing SQL Migrations appeared first on SQLServerCentral. 13 décembre 2021 dans Sites anglophones étiqueté flyway / Vendors/3rd-party Products par sqlservercentral.com
Introduction to SQL Jobs in Azure Data StudioBy default, Azure Data Studio (ADS) does not allow creating jobs, scheduling them, and creating alerts. However, there […] 13 décembre 2021 dans Sites anglophones étiqueté #job configuration / Azure Data Studio par sqlservercentral.com
Creating API Driver API ProfilesRESTful APIs offer a straightforward way for businesses to work with external data and offer access to their […] 10 décembre 2021 dans Sites anglophones étiqueté Automation / Connectivity / integration par sqlservercentral.com
Introduction to DAX for paginated reportsThe post Introduction to DAX for paginated reports appeared first on SQLServerCentral. 10 décembre 2021 dans Sites anglophones étiqueté BI / DAX par sqlservercentral.com
SQL Server Data Classification Comes AliveOverview Microsoft SQL Server 2012 introduced a feature called data classification, which allows you to mark certain columns […] 10 décembre 2021 dans Sites anglophones étiqueté Administration / data classification / Security / SQL Server par sqlservercentral.com
Flyway Teams and the Problem of Database VariantsThe post Flyway Teams and the Problem of Database Variants appeared first on SQLServerCentral. 10 décembre 2021 dans Sites anglophones étiqueté flyway / Vendors/3rd-party Products par sqlservercentral.com
[Video] Office Hours: SQL Server 2008 R2 Edition, I GuessI went through your highest-voted questions from Pollgab and talked through ’em, and strangely, there was a bit […] 9 décembre 2021 dans Sites anglophones étiqueté Videos par brentozar.com
Hotfix: JDBC Driver 9.4.1 for SQL Server ReleasedWe recently released an update to Microsoft JDBC Driver for SQL Server, version 9.4.1. The update addresses a […] 8 décembre 2021 dans Sites Microsoft par MS Tech Community
How Do You Test IOPs, Latency, and Throughput?You’ve heard these terms thrown around about storage, and you’re not sure what they mean, and how they […] 8 décembre 2021 dans Sites anglophones étiqueté Storage par brentozar.com
Create a SQL Server PolyBase Scale-out Group Using Amazon Web ...The post Create a SQL Server PolyBase Scale-out Group Using Amazon Web Services appeared first on SQLServerCentral. 8 décembre 2021 dans Sites anglophones étiqueté amazon / AWS / Big Data par sqlservercentral.com
Going to SQLBits? Join me for my Mastering Parameter Sniffing ...You’re a database developer or DBA with at least 3 years experience performance tuning queries and indexes. You […] 7 décembre 2021 dans Sites anglophones étiqueté SQLBits par brentozar.com
Utiliser les évènements étendus pour tracer l'activité dans SQL ServerDans cette vidéo, j’aimerais vous parler des événements étendus, en anglais, Extended Events, dans SQL Server. Microsoft a […] 4 décembre 2021 dans Videos par Vimeo - Rudi Bruchez
Released: SQL Server 3rd Party Backend for Django v1.1We have released version 1.1 of the SQL Server 3rd Party Backend for Django. This release contains support […] 3 décembre 2021 dans Sites Microsoft par MS Tech Community