Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – Rename a Table Name Containing [ or ] Identifier in the Name – Part 2

January 26, 2014

Yesterday I posted article where we discussed how to rename a table name where identifier is part of the tablename. Read the blog post Rename a Table Name Containing [ or ] in the Name – Identifier in the Table Name. If the table name contains an identifier, it is…

SQL SERVER – Rename a Table Name Containing [ or ] in the Name – Identifier in the Table Name

January 25, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server Management Studio

Just a day ago, my old colleague sent me an email. “I accidently renamed my tablename as a [], and now I am not able to rename it back with the help of T-SQL to its original name which was ProjectA. Is there any way to fix it?” Very interesting…

SQL SERVER – Writing SQL Queries Made Easy with dbForget SQL Complete

January 24, 2014

Pinal Dave

SQL

Devart, SQL Download

Down with shackles of convention! dbForge SQL Complete 4.5 came in this world.

SQL SERVER – Query Plan Analysis of Pivot and Unpivot with Profiler of dbForge Studio for SQL Server

January 24, 2014

Pinal Dave

SQL

Devart

Probably, everyone who writes SQL code has used INSERT statement, which alongside SELECT, UPDATE and DELETE, is a part of a basic operations’ set for data manipulation. Let us learn about Query Plan Analysis.

SQL SERVER – Tools for Proactive DBAs – Policy Based Management – Notes from the Field #012

January 23, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore

[Note from Pinal]: This is a 12th episode of Notes from the Fields series. When taking a vacation the biggest worry any DBA has it that in their absence what will happen to their database. They are often worried that something will go wrong with their server or some users…

SQL SERVER – How to Survive on Free Tools for Month – Database Comparison Done Easily with ApexSQL Diff

January 22, 2014

Pinal Dave

SQL

ApexSQL, SQL Utility

ApexSQL Diff is a SQL Server database comparison software with a free Community version and Windows Azure SQL database support. To compare Windows Azure SQL databases in ApexSQL Diff selects “Database” as the data source type and a destination. Select the SQL Server Authentication and type the SQL Azure server name, user and password. Select databases from the list of available databases and click the Compare button.

SQL SERVER – SQLWays – Database and Application Migration Tool

January 21, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database and what is more application migration has always been time and money consuming task. In this article I’m going to tell you about one of the ways to make this task easier in all senses. I suppose that you might have already heard about SQLWays database migration tool, developed…