Sites anglophones


Most T-SQL Queries Don’t Even Try to Handle Errors.

Publié le 20 août 2021 sur brentozar.com
 

David Tovee asked a great question in yesterday’s Mastering Query Tuning class. He asked his fellow students, “How many of you actually use TRY/CATCH?” I turned it into a Twitter poll because I wanted to check a wider audience: When t …

Testing SQL Server Databases Using SQL Test

Publié le 20 août 2021 sur sqlservercentral.com
 

The post Testing SQL Server Databases Using SQL Test appeared first on SQLServerCentral.

SQL Compilations/sec is not what you think it is

Publié le 20 août 2021 sur sqlservercentral.com
 

The post SQL Compilations/sec is not what you think it is appeared first on SQLServerCentral.

Working with Get Metadata Activity in Azure Data Factory

Publié le 20 août 2021 sur sqlservercentral.com
 

Introduction While working in Azure Data Factory, sometimes we need to retrieve metadata information, like the file name, file size, file existence, etc. We can use the Get Metadata activity to retrieve metadata information from the data set and then w …

You Probably Shouldn’t Index Your Temp Tables.

Publié le 19 août 2021 sur brentozar.com
 

When you’ve got a process that uses temp tables, and you want to speed it up, it can be tempting to index the temp table to help work get done more quickly. However, in most cases – not all, but most – that’s a bad idea. To expl …

Connect to MySQL Through SSH Using the CData MySQL Driver 

Publié le 18 août 2021 sur sqlservercentral.com
 

There are two major options for securely exposing access to your MySQL database over an unsecured network: an SSL connection or an SSH tunnel. The CData MySQL Driver provides a secure, live data connection to MyS …

Microsoft at PASS Data Community Summit 2021

Publié le 18 août 2021 sur sqlservercentral.com
 

The post Microsoft at PASS Data Community Summit 2021 appeared first on SQLServerCentral.

Use SQL Server Integration Services to Add HubSpot Contacts to MailChimp Lists

Publié le 17 août 2021 sur sqlservercentral.com
 

SSIS stands for SQL Server Integration Services and is a solution for building data integrations and workflow applications that integrate with SQL Server databases. As data integration processes …

Mark Your Calendars: Free Live SQL Server Training Classes in October & November.

Publié le 17 août 2021 sur brentozar.com
 

This fall, I’m going to teach you the fundamentals of Microsoft database performance tuning, live, for free. The first class is my How to Think Like the Engine class. It’s already free online in both video and blog post formats, but this fa …

Using Coalesce to Clean Up Reports

Publié le 16 août 2021 sur sqlservercentral.com
 

The T-SQL language is quite extensive and includes many functions that are useful for various purposes. One of the lesser used ones I encounter is COALESCE(). Recently I found myself using this to help with a report recently. I decided to include a few …

SQL VIEW Comparison in SQL Server, Oracle and PostgreSQL

Publié le 16 août 2021 sur sqlservercentral.com
 

The post SQL VIEW Comparison in SQL Server, Oracle and PostgreSQL appeared first on SQLServerCentral.

How to query private blob storage with SQL and Azure Synapse

Publié le 13 août 2021 sur sqlservercentral.com
 

The post How to query private blob storage with SQL and Azure Synapse appeared first on SQLServerCentral.

Using Multiple Azure DevOps Organizations with SQL Source Control

Publié le 13 août 2021 sur sqlservercentral.com
 

The post Using Multiple Azure DevOps Organizations with SQL Source Control appeared first on SQLServerCentral.

[Video] Office Hours: Ask Me Anything About Microsoft SQL Server

Publié le 12 août 2021 sur brentozar.com
 

We took a break from roaming around Iceland long enough to check in at our home studio. While we were here, I did a live Office Hours session, taking your questions about Microsoft SQL Server. Questions I answered in the video: 00:00 Introductions 02:3 …

[Video] Office Hours: Húsavík Harbor Edition

Publié le 11 août 2021 sur brentozar.com
 

Today’s session comes to you from the harbor in Húsavík, the whale watching capitol of Europe. Questions I answered in the video: 00:00 Introductions 00:29 Is SQL Server 2019 ready for prime time now? 02:47 Does WITH NOLOCK cause hi …


Pages :