cross join

Using Cross Join to insert millions of dummy/fake records

Sometimes we need fake or dummy data to test our queries or test performance or configuration of database server. There is a very neat way to generate millions of records…

Read more »

User does not have permission to RESTORE database

The error ‘User does not have permission to RESTORE database xx’ occurs when you try to restore a database from backup and you do not have sufficient permissions to perform…

Read more »
Disable Hardware Graphics Acceleration

How to fix SQL Server Management Studio graphics problem

When using SSMS, and switching between query tabs, sometimes the screen does not refresh/repaint and it continues to show the content of the previous tab. Some users also reported that…

Read more »
SSMS18-Preview4

Download SQL Server Management Studio 18.4

SSMS 18.4 is the latest generation of SQL Server Management Studio that has full support for SQL Server 2019 Preview. SSMS 18.4 was released on 04 November 2019 and it’s…

Read more »
SSMS18-Preview4

Download SQL Server Management Studio (SSMS) 18.0 (Preview 6)

SSMS 18.0 (Preview 6) is the latest generation of SQL Server Management Studio that has full support for SQL Server 2019 Preview. SSMS 18.0 (Preview 6) was released on 18…

Read more »

Microsoft SQL Server 2017 Downgrade Rights

Microsoft SQL Server’s licensing model is complex and so is its down grade rights mechanism. Several deployment options are available for customers of SQL Server 2017 to support a variety…

Read more »

Download SQL Server Management Studio 17.6

Microsoft recently released a new version of SQL Server Management Studio called version 17.6. SQL Server Management Studio 17.x is the latest generation of SQL Server Management Studio and provides…

Read more »

STUFF command in SQL Server

This command is used to replace a string with another string within a text. This command can sometimes be a savior. You can see the shape of this command along…

Read more »

dbcopytool – SQL Server Database Copy Tool

dbcopytool is a simple, light weight and easy to use program to copy a sql server database from one server to another by backing it up, copying the backup file…

Read more »
plan-explorer-deadlock

Plan Explorer – a free SQL query analysis and optimization tool

Plan Explorer by SentryOne is a free SQL query analysis and optimization tool that helps you quickly get to the root of the toughest SQL Server query problems. With Plan…

Read more »