Sites anglophones


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 …

Text Mining and Sentiment Analysis: Introduction

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

Text Mining and Sentiment Analysis can provide interesting insights when used to analyze free form text like social media posts, customer reviews, feedback comments, and survey responses. Key phrases extracted from these text sources are useful to iden …

Designing a Data Archiving Strategy on Microsoft Azure – Online Course

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

If you have been reading this blog regularly, that you know that eventually, everything is going to move to the cloud. However, it does not mean, that you start moving everything to the cloud now. The word eventually is not associated with any timeline …

Analysis Services : OLEDB Error while processing in SSAS

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

Problem This is one of the errors that I frequently encounter while deploying or processing SSAS OLAP cubes on the client’s computers or on a remote server. Recently, one of my team members also faced the same issue and so I thought to write a resoluti …

Changing SET options in a Procedure or Trigger leads to Recompilation (PE012)

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

The post Changing SET options in a Procedure or Trigger leads to Recompilation (PE012) appeared first on SQLServerCentral.

How to Measure Transactions Per Seconds in SQL Server? – Interview Question of the Week #262

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

Question: How to Measure Transactions Per Seconds in SQL Server?Answer: This is very with the help of OS Performance Counter. Here is the script which I have written earlier to measure the total number of transactions on the interval. SQL SERVER …

Introduction to ColdFusion Course at Pluralsight

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

ColdFusion (CF) is a rapid web application development platform. In this course, you will learn the basics of how to use the CF platform and rapidly develop web sites. The course begins with learning the basics of ColdFusion Markup Language and moves t …

SQL SERVER – Details About SQL Jobs and Job Schedules

Publié le 31 janvier 2020 sur journey to sqlauthority
 

Yesterday I wrote a blog post about SQL SERVER – Query to List All Jobs with Owners, I got many emails to post the blog post but the most interesting email I received is from SQL Server Expert Dominic Wirth. He responded to the blog with a very i …

Do you want the chance to win Redgate goodies and books?

Publié le 31 janvier 2020 sur sqlservercentral.com
 

The post Do you want the chance to win Redgate goodies and books? appeared first on SQLServerCentral.


Pages :