Sites anglophones


Understanding SQL Server Replication

Publié le 6 février 2020 sur sqlskills - jonathan kehayas
 

This blog post is a part of a series on SQL Server Transactional Replication.  If you want to find the other posts in the series, check out the main page for the series here.SQL Server Replication is one of the components of SQL Server that often …

Free Pluralsight this weekend and 500,000 hours of SQLskills viewing!

Publié le 6 février 2020 sur sqlskills.com - paul randall
 

Back in 2012 we started recording online courses for Pluralsight, with our debut being my course on SQL Server: Myths and Misconceptions. Fast forward to the end of 2019 and our 65th published course was Jonathan’s SQL Server: Using SentryOne Pla …

Which SQL Server Enterprise Edition Should I Download?

Publié le 6 février 2020 sur brentozar.com
 

When you’re downloading SQL Server, it’s important to choose Enterprise Core, not Enterprise. The plain “Enterprise” one is limited to just 20 CPU cores. But let’s say you didn’t know that, and you waltzed over …

SQL Server Performance Tuning Real-World Scenarios – Training Day at #SQLBits 2020

Publié le 6 février 2020 sur journey to sqlauthority
 

I am very excited to present my day long (pre-con) known as Training Day at SQLBits. SQLBits is the largest conference in Europe and has the best possible learning experience out there in the SQL World. I will be presenting a day-long training day (pre …

Introduction to PIVOT operator in SQL

Publié le 6 février 2020 sur sqlservercentral.com
 

Introduction A Pivot table is a technique to summarize a large amount of data that can be visualized into rows and columns. It is also referred to as the magnifying glasses of your data.  It allows the users to transform rows into columns. In addi …

Updates to the Deployment Suite for Oracle

Publié le 6 février 2020 sur sqlservercentral.com
 

The post Updates to the Deployment Suite for Oracle appeared first on SQLServerCentral.

Wanna Learn How I Use the First Responder Kit?

Publié le 5 février 2020 sur brentozar.com
 

My newest class, How I Use the First Responder Kit, has been going great – but there’s a catch. I designed this class as a mix of training and consulting, so I’m giving you advice on your server as we go. Because of that, I can only f …

SQL SERVER – Best Practices for Dynamics NAV AX CRM

Publié le 5 février 2020 sur journey to sqlauthority
 

In the last 3 months, I have done nearly 11 consulting engagement for Dynamics NAV AX CRM while working on Comprehensive Database Performance Health Check. While working on the SQL Server application, we have options to do quite lots of things but when …

Load Time Series Data with SQL Server

Publié le 5 février 2020 sur sqlservercentral.com
 

The post Load Time Series Data with SQL Server appeared first on SQLServerCentral.

Custom Deployments from Source Control using SQL Compare Command line

Publié le 5 février 2020 sur sqlservercentral.com
 

The post Custom Deployments from Source Control using SQL Compare Command line appeared first on SQLServerCentral.

What Are Soft Deletes, and How Are They Implemented?

Publié le 4 février 2020 sur brentozar.com
 

Normally when you run a DELETE statement in a database, the data’s gone. With the soft delete design pattern, you add a bit column like IsDeleted, IsActive, or IsArchived to the table, and instead of deleting rows, you flip the bit column. This c …

Are Changes to Query Store Logged?

Publié le 4 février 2020 sur SQLSkills.com - Erin Stellato
 

The Query Store feature is a bit unique in that its status can change without user interference, which means it is important to understand how changes to Query Store are logged.  A couple weeks ago John Deardurff posted a question on Twitter askin …

SQL SERVER – Drop All Auto Created Statistics

Publié le 4 février 2020 sur journey to sqlauthority
 

This is a follow up of my earlier blog post How to Drop All the User Created Statistics by SQL Server? – Interview Question of the Week #158. During the recent consulting engagement, Comprehensive Database Performance Health Check, I ended up a v …

Static data in SQL Change Automation SSMS plugin

Publié le 4 février 2020 sur sqlservercentral.com
 

The post Static data in SQL Change Automation SSMS plugin appeared first on SQLServerCentral.

Calculate Moving Averages using T-SQL in SQL Server

Publié le 4 février 2020 sur sqlservercentral.com
 

Introduction In Financial Data, analyzing the Moving Average (MA) is a very common practice. The direction of the moving average conveys important information about prices, whether that average is simple or exponential. A rising moving average shows th …


Pages :