Are Changes to Query Store Logged?
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
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
The post Static data in SQL Change Automation SSMS plugin appeared first on SQLServerCentral.
Calculate Moving Averages using T-SQL in SQL Server
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
The post Building SQL Server Indexes in Ascending vs Descending Order appeared first on SQLServerCentral.
Key Findings from the 2020 Database DevOps Survey
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
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
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
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
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)
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
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
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
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?
The post Do you want the chance to win Redgate goodies and books? appeared first on SQLServerCentral.