[Notes from Pinal]: SSIS is very well explored subject, however, there are so many interesting elements when we read, we learn something new. A similar concept has been Using Project Connections in SSIS.
SQL SERVER – 2016 FIX: Install – Rule “Oracle JRE 7 Update 51 (64-bit) or higher is required” failed
I enjoy spending time with my daughter almost every single day. It keeps me busy at home and most importantly, some quality time with her allows me to relax after a long day at work. But there one thing that has caught my attention every single day I have been…
Read MoreSQL SERVER – Identifying Blocking Chain Using SQL Scripts
There are a number of blog posts that have been written on this very topic. This can be from basics to almost advanced in many ways. I am outlining some of them here below: SQL SERVER – Quickest Way to Identify Blocking Query and Resolution – Dirty Solution SQL SERVER…
Read MoreSQL SERVER – Creating Dataset Using VALUES Clause Without Creating A Table
You know that you can add data to a table using VALUES clause. But did you know that you can create a dataset using VALUES clause like a table without adding into another table? Suppose you want to create a data set with two columns named a and b SELECT…
Read MoreInterview Question of the Week #027 – Move TempDB from One Drive to Another Drive When Low Disk Space
Here is one of the important interview question which is related to TempDB and how to Move TempDB from One Drive to Another Drive When Low Disk Space.
SQL SERVER – Secure by Default – The Mantra
Generally the talks I give at conferences revolve around performance and tuning. These are always the most sought after topic and I don’t disappoint the requests because they give me an opportunity to learn something new too. Last month when I visited Sri Lanka for the first ever SQLSaturday event,…
Read MoreSQL SERVER – Difference Between Read Committed Snapshot and Snapshot Isolation Level
It is quite common that when a new feature gets introduced, there is a lot of talk about them. Sometimes even the old capabilities are lesser known because they can be used interchangeably in conversations. I have seen many DBAs getting confused between these two terms because both of them…
Read More
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.