Sites anglophones


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 …

Building SQL Server Indexes in Ascending vs Descending Order

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

The post Building SQL Server Indexes in Ascending vs Descending Order appeared first on SQLServerCentral.

Key Findings from the 2020 Database DevOps Survey

Publié le 4 février 2020 sur simple-talk.com
 

Each year Redgate Software runs a survey to learn more about how organizations practice DevOps, especially when it relates to the database. This year, over 2000 individuals responded, and they are from diverse industries and company sizes. The key find …

[Video] Watch Brent Tune Queries

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

Ever wonder somebody else does it? Watch over my shoulder as I spend 9 minutes in PowerPoint explaining the big picture, and then about 40 minutes working on this stored procedure in the StackOverflow2013 database: If you enjoy that, the Watch Brent Tu …


Pages :