SQL SERVER – Database Mail Error: The SMTP Server Requires a Secure Connection or the Client was not Authenticated. The Server Response Sas: 5.5.1
Have you ever configured database mail using Gmail account? There are many articles on the internet describing the steps. In this blog, we would learn about fixing an error “The SMTP server requires a secure connection or the client was not authe …
[Video] What to Do When SQL Server is Slow
Someone comes running in and asks, “Are you doing something on the SQL Server right now? Can you take a look at it? It seems really slow.” It’s one of the most common complaints we get about our databases – and yet, most of us d …
[Video] SQL Query Optimization: Why Is It So Hard to Get Right?
The first paper on cost-based query optimization was published in 1979 by Patricia Selinger from IBM Research. This paper laid the basic framework for optimizing relational queries that is still in place today. While there have been many technical enha …
Introducing Microsoft BI Reporting and Analysis Tools
Choose the right BI tool by learning about the different strengths of the Microsoft analysis and reporting tools. Microsoft provides a variety of BI tools that can address key workloads, such as Power BI and Excel. The article discusses the workloads a …
SQL SERVER – Many BACKGROUND Threads with Command VDI_CLIENT_WORKER
There are so many wait types available in SQL Server and sometimes I feel that it’s an ocean of wait types. I have already written about most common wait types earlier. In this blog, we would learn about VDI_CLIENT_WORKER / VDI_CLIENT_OTHER wait …
What is the FCB_REPLICA_SYNC spinlock?
A question came up on the Data Platform MVP email list last night asking what the FCB_REPLICA_SYNC spinlock is. I answered the question and then promised to do a quick blog post, as there’s no information online about it that I could find. Explan …
Does It Matter Which Field Goes First in an Index?
Let’s take the dbo.Users table from the Stack Overflow database, which holds exactly what you think it holds – the list of users: StackOverflow.dbo.Users Say I want to count up all of the people with 1 reputation point:SELECT COUNT(*) FROM …
Calculating MTD, QTD, YTD, Running and Cumulative Total in Power BI
In this tip, you will be walked through a method to calculate MTD, QTD, YTD and running total in Power BI. This method is useful in stock calculations and balance sheet calculations.
SQL SERVER – Event ID: 1135 – Cluster node ‘NodeName’ was Removed From the Active Failover Cluster Membership
When I work with customers, there are situations when I get chance to learn something from them. I was engaged with an AlwaysOn availability group engagement and got some interesting information from a customer which I am sharing here. In this blog, we …
First Responder Kit Release: Like pssdiag, if pssdiag had parents who cared
I went to the PFE and guess what he told me? Guess what he told me? He said girl you better try fix those spinlocks too No matter what you do, now run this tool You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements#1620: …
T-SQL Window Functions and Performance
T-SQL window functions make writing many queries easier, and they often provide better performance as well over older techniques. For example, using the LAG function is so much better than doing a self-join. To get better performance overall, however, …
How The Cloud Turns Performance Tuning Into Cost Savings
Barely Metal In Ye Olde Olden Dayyes, companies would outline hardware budgets and refresh cycles. Every 3-5 years, they’d lick a thumb and hold it up to the CPU fans. If they felt a soft breeze, they’d buy the same number of CPUs. If they …
Scale-Out SQL Server Integration Services Environment: A Sample Pattern
This white paper illustrates how Microsoft SQL Server Integration Services (SSIS) can be used in conjunction with commodity hardware or virtual machines running in Microsoft Azure to build elastic, highly available, and highly scalable ETL solutions.
Practical Real World Performance Tuning – Fun and Reviews
Unless you are staying under the rock, you would be familiar with Practical Real World Performance Tuning course. This is the second part about behind the scene story. You can read my first part here – Practical Real World Per …
[Video] Why Performance Tuning Wisdom Needs Expiration Dates
Several months ago, Erik said something like, “We should do a performance art piece where one person does the talking, while another person does demos that contradicts everything they say.” I thought it was a brilliant idea. We just had to …