(Pinal Dave) Indexes are the last option we consider when we do a Comprehensive Database Performance Health Check. 3 out of 4 clients, I work on the health check, we end up not creating new indexes. Most of the time we spend time looking at the indexes when removed we can get instant performance and

(Mohammed Moinudheen) I have a number of items on my Azure storage account. Is there any easy way by which we can manage the contents of my Azure storage account without having to use the Azure portal? Is there any kind of tool that can be used for this purpose?

(Pinal Dave) A few years ago, I had written a blog post Find the Growth Size for All files in All Databases. The original script had some error related to counting the size as pointed out by the SQL Server expert John Fowler, however, I never got around to correct the blog post as the first comment

(Pablo Echeverria) A database login or user (SQL Login, Oracle User, etc.) is actively being used and embedded in code, but the password is about to change. How can you find all of the places where it exists with SQL Server such as Jobs, Linked Servers and SSIS information stored on the server?

(Pinal Dave) Earlier last week SQL SERVER 2019 is Released. It has been an amazing experience to download and work with this new version. As I have been working for almost 20 years with SQL Server, I want SQL Server to be robust and stable, while performing better than the previous version of the SQ

(Fikrat Azizov) Data integration flows often involve execution of the same tasks on many similar objects. A typical example could be – copying multiple files from one folder into another or copying multiple tables from one database into another. Azure Data Factory’s (ADF) ForEach and Until activitie

(Pinal Dave) One of my existing clients contacted me to provide assistance in an issue where they were not able to install SQL Server 2014. In this blog, we would learn about fixing error “Unable to Initialize SSL Support.

(Koen Verbeeck) When you want to load data into your data warehouse, for example into one of your dimensions, you need to determine if an incoming row is either an update – a historical change – or an insert, which is a new occurrence of a record.

(Pinal Dave) I recently released a Pluralsight Course Analyzing SQL Server Query Plans, and it is really doing great in terms of viewership and I have received some really great comments and feedback about this course. This week, I will be discussing different aspects of Analyzing SQL Server Query P

(Hannes Du Preez) There are quite a few string functions in the SQL language, and today I will present most of them.