Sites anglophones


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 …

Hands-On with Columnstore Indexes: Part 2 Best Practices and Guidelines

Publié le 24 juin 2020 sur simple-talk.com
 

The series so far: Hands-On with Columnstore Indexes: Part 1 Architecture Hands-On with Columnstore Indexes: Part 2 Best Practices and Guidelines A discussion of how columnstore indexes work is important for making the best use of them, but a practical …

How to Upgrade SQL Server Evaluation Edition to Developer Edition

Publié le 24 juin 2020 sur brentozar.com
 

Six months ago today, you installed SQL Server Evaluation Edition. You told yourself you’d take care of that sooner or later, and…you forgot. Now, your SQL Server won’t start: Error 17051: SQL Server evaluation edition has expired. A …

When SQL Server Performance goes Bad: the Fill Factor and Excessive Fragmentation

Publié le 24 juin 2020 sur sqlservercentral.com
 

The post When SQL Server Performance goes Bad: the Fill Factor and Excessive Fragmentation appeared first on SQLServerCentral.

Solving Oracle Performance Issues in 4 Easy Steps

Publié le 24 juin 2020 sur sqlservercentral.com
 

The post Solving Oracle Performance Issues in 4 Easy Steps appeared first on SQLServerCentral.

Bad Idea Jeans: Building Big Query Plans

Publié le 23 juin 2020 sur brentozar.com
 

When you build a monitoring tool that sends advice via email, you discover two things: Some people have really, really big execution plans Email servers have reasonable limits on file attachment sizes Add those two things together, and Richie found him …

How to Find the Estimation Cost for a Query

Publié le 23 juin 2020 sur sqlservercentral.com
 

execut The post How to Find the Estimation Cost for a Query appeared first on SQLServerCentral.

SSIS Variable and Parameter Analysis

Publié le 23 juin 2020 sur sqlservercentral.com
 

Introduction If you have an SSIS project that’s matured over time and makes good use of variables and parameters, you’re probably nervous about deleting any of them, even if you think that they are no longer in use. Wouldn’t it be great to be sure and …


Pages :