Sites anglophones


Azure Data Factory vs SSIS vs Azure Databricks

Publié le 3 juillet 2020 sur sqlservercentral.com
 

The post Azure Data Factory vs SSIS vs Azure Databricks appeared first on SQLServerCentral.

How Bad are Bad Page Splits – The Rest of the Story

Publié le 2 juillet 2020 sur sqlservercentral.com
 

In Part 1 of this article we looked at a specific use case (probably exaggerated) that gave us an idea about how CPU and IO performance might be affected by a bad page split. We continue this analysis looking at what really happens to the data on the l …

Easily manage SQL Server licensing with SQL Monitor 10.1

Publié le 2 juillet 2020 sur sqlservercentral.com
 

The post Easily manage SQL Server licensing with SQL Monitor 10.1 appeared first on SQLServerCentral.

What Do You Do Better Than the Cloud?

Publié le 1 juillet 2020 sur brentozar.com
 

It sounds like a trick question, but I’m serious. If your company’s management is just now starting to consider the cloud in 2020, your reaction shouldn’t be to cast a shadow on cloud vendors. Instead, think of it as writing your own …

SQL Server Data Masking with DbDefence

Publié le 1 juillet 2020 sur sqlservercentral.com
 

The post SQL Server Data Masking with DbDefence appeared first on SQLServerCentral.

You Can Disable Parameter Sniffing. You Probably Shouldn’t.

Publié le 30 juin 2020 sur brentozar.com
 

During my parameter sniffing classes, people get a little exasperated with the complexity of the problem. Parameter sniffing is totally hard. I get it. At some level, it’d be great to just hit a magic button and make the whole thing go away. So i …

Generate Role Member Reports using dbatools and the ImportExcel PowerShell modules

Publié le 30 juin 2020 sur sqlservercentral.com
 

As one of dbatools’ first members, I’ve been using it for years and it’s really my goto tool. This task was no different! Today’s tip and trick using dbatools is about generating an Excel workbook that contains lists o …

Understanding Views in SQL

Publié le 30 juin 2020 sur sqlservercentral.com
 

The post Understanding Views in SQL appeared first on SQLServerCentral.

Redgate Streamed

Publié le 30 juin 2020 sur sqlservercentral.com
 

The post Redgate Streamed appeared first on SQLServerCentral.

All 2020 classes now online in September and October!

Publié le 30 juin 2020 sur sqlskills.com - paul randall
 

Back in April when nearly everyone was locked down, we moved all our Chicago classes to October. Now, given the continuing COVID-19/coronavirus pandemic and the many travel restrictions companies have in place, we decided that in-person classes ar …

Things To Consider When Submitting Sessions to Paid Online Conferences

Publié le 29 juin 2020 sur brentozar.com
 

Lots of paid conferences are happening online these days, so some of you will be presenting an online session or pre-con for the first time. I’ve done a bunch of these and been burned in a bunch of ways, so lemme save you some time and heartache. …

Creating a Serverless Database in Azure

Publié le 29 juin 2020 sur sqlservercentral.com
 

I have been experimenting with Azure in my spare time, trying to better understand this cloud service and how I can use it for data projects. My employer is considering building some applications here, so I want to be prepared. In this article, I decid …

Cloud adoption rates see increase in 2020

Publié le 26 juin 2020 sur sqlservercentral.com
 

The post Cloud adoption rates see increase in 2020 appeared first on SQLServerCentral.

Using SQL Server Profiler to Capture Stored Procedures Executions

Publié le 26 juin 2020 sur sqlservercentral.com
 

The post Using SQL Server Profiler to Capture Stored Procedures Executions appeared first on SQLServerCentral.

Sit Down. We Need to Talk About Your Scalar Functions.

Publié le 25 juin 2020 sur brentozar.com
 

Thanks for coming today. I apologize for baiting you in here with a picture of toilet paper. That’s not even in the US – that’s from my Iceland trip, before I flew back here to the US. Look, we all make mistakes. That’s not the …


Pages :