Building PasteThePlan.com: Removing Comments
PasteThePlan.com We have this PasteThePlan where you can copy/paste the contents of execution plans, and then share the links around the web. You’ve pasted 16,621 plans so far, and I’m always amused to see them continuing to trickle in ever …
SQL SERVER – Enable Additional Logging for SQL Server Agent
When I searched for this topic, I was getting blogs where they were talking about additional logging for the job step in SQL Server Agent jobs. In this blog, I would share my learning about logging about SQL Server Agent itself.Like the ERRORLOG file f …
Do Not Set Trustworthy On for the SSISDB Catalog
The Problem Recently, we suddenly started having issues with deploying SSIS-packages to our SSISDB catalog on SQL Server 2016 Standard Edition. I am writing this blog to share the solution we have found, which I have not been able to find anywhere onli …
PASS Summit 2020
The post PASS Summit 2020 appeared first on SQLServerCentral.
Automate SFTP File Transfer with SQL Server Agent and WinSCP
The post Automate SFTP File Transfer with SQL Server Agent and WinSCP appeared first on SQLServerCentral.
Securing Data in SQL Server
Recently I have been having quite a few discussions around security of data inside of SQL Server and how to prevent the massive data breaches that we have been hearing about on the news. Like most things some people want “THE ANSWER” …
Why Database Monitoring Tools Are So Hard to Interpret
SentryOne’s Greg Gonzalez recently published a post about “Why Wait Stats Alone Are Not Enough.” Sure, Greg’s obviously biased towards his own monitoring tool, but his post is really well-written and fair. I want to explain the …
SQL SERVER – Display Rupee Symbol in SSMS
Recently, I was reached out by one of the my financial technology clients based out of the USA who has just launched their services in India. Their system worked fine in most of the area but the challenge was to display the Indian currency sign. They r …
Basic Concepts of Probability Explained with Examples in SQL Server and R
The post Basic Concepts of Probability Explained with Examples in SQL Server and R appeared first on SQLServerCentral.
Month-over-Month calculation using DAX in Power BI
Introduction Period-over-period is an analysis technique in business that measures some value in the present and compares it to the same measurement in a comparable period of time in the past. The goal is to adjust the slice of the past you are viewing …
What are Different Methods to Know the Row Count of Table? – Interview Question of the Week #261
Question: What are Different Methods to Know the Row Count of Table?Answer: The answer to this question is very simple and many. I have previously blogged about this topic many times. Here are a few sample questions one can on this topic:How many users …
SQL SERVER – Heaps, Scans and RID Lookup
Today we will discuss a question which I was recently asked by my client during the Comprehensive Database Performance Health Check. The question was do heaps are very bad and always force a table scan? The answer is NOT Always, whenever there is a cas …
Updated First Responder Kit and Consultant Toolkit for January 2020
A couple of times a year, I disconnect from the Internet to sit down with a planning book, my Epic Life Quest, and my future task list. I spend time making sure my day-to-day tasks are still prioritized right. When I do that, I often find out that I …
SQL SERVER Tools I Use and Recommend (Updated: January 2020)
One of the most popular questions I often receive during Comprehensive Database Performance Health Check is which are the third-party tools I use in my daily routine and I recommend them. Here is the updated list for January 2020 of all the tools which …
Monitoring SQL Server with Splunk and SQL Monitor
The post Monitoring SQL Server with Splunk and SQL Monitor appeared first on SQLServerCentral.