Sites anglophones


Overcoming Database DevOps challenges – Part 1

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

The post Overcoming Database DevOps challenges – Part 1 appeared first on SQLServerCentral.

More About AT TIME ZONE

Publié le 30 juillet 2021 sur sqlskills - jonathan kehayas
 

This post is a follow up to my previous post on the performance impacts of the AT TIME ZONE implementation in SQL Server based on some observations and comments that were made on Twitter by my good friend Simon Sabin and then later in comments. The fir …

Share your favorite Redgate tool – win technical training from Pluralsight!

Publié le 30 juillet 2021 sur sqlservercentral.com
 

The post Share your favorite Redgate tool – win technical training from Pluralsight! appeared first on SQLServerCentral.

PostGres and SQL Server – Divided by a common language

Publié le 30 juillet 2021 sur sqlservercentral.com
 

My database career took off when I was sent on the two SQL Server 6.5 training courses.  As a developer and later as a DBA I stayed with SQL Server until 2014. Since then I have been exposed to a variety of database platforms and technologies. …

How to enable SQL Server trace flags

Publié le 30 juillet 2021 sur sqlservercentral.com
 

The post How to enable SQL Server trace flags appeared first on SQLServerCentral.

[Video] Office Hours: Ask Me Anything About Professional Development

Publié le 29 juillet 2021 sur brentozar.com
 

Erika and I are on the road in Iceland, roaming around the countryside, and I’m taking you with us. This week, we’re in Siglufjörður, a beautiful little oceanfront fishing village in the north. In the mornings, before Erika wakes u …

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

Publié le 28 juillet 2021 sur brentozar.com
 

Erika and I are on the road in Iceland, roaming around the countryside, and I’m taking you with us. This week, we’re in Siglufjörður, a beautiful little oceanfront fishing village in the north. In the mornings, before Erika wakes u …

How Does Microservices Architecture Change Database Deployment?

Publié le 28 juillet 2021 sur sqlservercentral.com
 

The post How Does Microservices Architecture Change Database Deployment? appeared first on SQLServerCentral.

High Precision Multiplication

Publié le 28 juillet 2021 sur sqlservercentral.com
 

Whenever large numbers are multiplied in SQL Server, a loss of precision may occur. I am working with a database that makes extensive usage of the type DECIMAL(38, 18) to hold large numbers. When multiplying two numbers, precision is loss in most cases …

How to query blob storage with SQL using Azure Synapse

Publié le 28 juillet 2021 sur sqlservercentral.com
 

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

Updated First Responder Kit and Consultant Toolkit for July 2021

Publié le 27 juillet 2021 sur brentozar.com
 

I’m slowing the First Responder Kit update frequency down to once every 2 months. I know from firsthand experience working with clients that folks just can’t patch quickly enough, hahaha. Folks who want to be on the bleeding edge updates ca …

Upcoming Office Hours: Get Your Questions In Now

Publié le 26 juillet 2021 sur brentozar.com
 

From time to time, when my incredibly busy (cough)vacation(/cough) schedule permits, I do a live Office Hours stream where I take your questions and answer ’em live. I’m going to do a couple of them this week, but I’m going to do them …

Much Ado about nothing: missing data

Publié le 26 juillet 2021 sur sqlservercentral.com
 

The post Much Ado about nothing: missing data appeared first on SQLServerCentral.

How to Compare Two SQL Prompt Styles

Publié le 26 juillet 2021 sur sqlservercentral.com
 

The post How to Compare Two SQL Prompt Styles appeared first on SQLServerCentral.

Why Power Query as an Activity in Azure Data Factory and SSIS?

Publié le 26 juillet 2021 sur sqlservercentral.com
 

This article will describe how the Power Query activity in Azure Data Factory (ADF) and Integration Services (SSIS) can be useful. In addition to that, I will share the differences of the Power Query activity between SSIS and ADF. Why Power Query and W …


Pages :