Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – Iridium I/O – SQL Server Deduplication that Shrinks Databases and Improves Performance

June 2, 2014

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Database performance is a common problem for SQL Server DBA’s. It seems like we spend more time on performance than just about anything else. In many cases, we use scripts or tools that point out performance bottlenecks but we don’t have any way to fix them. For example, what do…

SQL SERVER – Faster SQL Server Databases and Applications – Power and Control with SafePeak Caching Options

June 2, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Safepeak

Update: This blog post is written based on the SafePeak, which is available for free download. Today, I’d like to examine more closely one of my preferred technologies for accelerating SQL Server databases, SafePeak. Safepeak’s software provides a variety of advanced data caching options, techniques and tools to accelerate the…

Developer’s Life – Every Developer is a Superman

June 1, 2014

Pinal Dave

Personal

Developer, SQL Server, Superhero

I enjoyed comparing developers to Spiderman so much, that I have decided to continue the trend and encourage some of my favorite people (developers) with another favorite superhero – Superman. Superman is probably the most famous superhero – and one of the most inspiring.

MySQL – Introduction to User Defined Variables

May 31, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL

MySQL supports user defined variables to have some data that can be used later part of your query. You can save a value to a variable using a SELECT statement and later you can access its value. Unlike other RDBMSs, you do not need to declare the data type for…

SQL SERVER – Merge Two Columns into a Single Column

May 30, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Here is a question which I have received from user yesterday. Hi Pinal, I want to build queries in SQL server that merge two columns of the table If I have two columns like, Column1 | Column2 1 5 2 6 3 7 4 8 I want to output like, Column1…

SQL SERVER – Parsing SSIS Catalog Messages – Notes from the Field #030

May 29, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore, SQL Scripts, SSIS

[Note from Pinal]: This is a new episode of Notes from the Field series. SQL Server Integration Service (SSIS) is one of the most key essential part of the entire Business Intelligence (BI) story. It is a platform for data integration and workflow applications. The tool may also be used…

SQL SERVER – Take the Quiz for a chance to win a Quadcopter Drone – Brain Teasers

May 28, 2014

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

It has been a long time since we ran quiz. So let us get ready for a quiz. The quiz has two parts. You have to get both the parts correct to win Quadcopter with Camera (we will call it drone). We will be giving away a total of 2…