(Greg Robidoux) Sometimes there is a need to combine data from multiple tables or views into one comprehensive dataset. This may be for tables with similar data within the same database or maybe there is a need to combine similar data across databases or even across servers.

(Jason Brimhall) Does this sound at all familiar? A user submits a request stating they must have elevated access to a database. In your attempt to gather more information about the request, they must have access because so-and-so has elevated access and they are curious about the database.

(Kenneth Fisher) You are probably already aware that you can disable an index. This can be handy when you have a large load and the load + re-enabling the indexes (you have to completely rebuild them) is faster than leaving the indexes in place.

(Pinal Dave) What I enjoy the most while working on difficult and different challenges every single day with Comprehensive Database Performance Health Check. Recently I was asked a very interesting question by one of my clients on the topic of Database Scoped Configurations.

(Hannes Du Preez) The SQL language has a plethora of numeric and mathematic functions, and in this article, you’ll see how to make use of them.

(Daniel Farina) A patch was applied automatically to my instance of SQL Server by Windows Update. This could have gone unnoticed, as it often happens with Windows updates. When I tried to access my SQL Server instance, I found that the mssqlsystemresource database was absent from where it should be

(Pinal Dave) SQL Server is a great product and sometimes some “By Design” behaviors cause interesting unexpected issues which is hard to understand unless you are an expert! In this blog, I would share my knowledge and findings of a situation where there was a mismatch between sys.database_files and

(Fikrat Azizov) In the previous post, Foreach activity, we discussed the ForEach activity designed to handle iterative processing logic, based on a collection of items. Azure Data Factory (ADF) also has another type of iteration activity, the Until activity which is based on a dynamic expression. We

(Itzik Ben-Gan) NULL handling is one of the trickier aspects of data modeling and data manipulation with SQL. Let’s start with the fact that an attempt to explain exactly what a NULL is is not trivial in and of itself.

(Pinal Dave) It has been over 3 weeks since SQL Server 2019 launched and after reading my recent blog posts about the Memory Grant Feedback, I was approached by one of the leading banks in Europe to help them build an efficient architecture and performance-optimized system Comprehensive Database Per