All Articles - SQL Authority with Pinal Dave

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

January 23, 2014

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…

SQL SERVER – How to Validate Syntax and Not Execute Statement – An Unexplored Debugging Tip

January 20, 2014

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

In one of the recent interview I had asked questions of interviewees – If you are a SQL Server Developer there must be times when you want to validate syntax, but do not want to execute a query. What is the surest way to check that your syntax is valid…

SQL SERVER – Identify Oldest Active Transaction with DBCC OPENTRAN

January 19, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Transactions

I recently received a question on my Facebook page- “Pinal, How do I know if there is any open transaction in my database? I recently wanted to restart my server, but my manager asked me to first check if there is any open transaction in database before I restart the…

Personal Technology – Inserting Image in PDF File with Adobe Acrobat X Pro

January 18, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Personal Technology

Here is the one of the issues, I keep on facing every single time. Just like every DBA and Developers I keep on working with PDF. I use Adobe Acrobat X Pro to edit my PDFs. I am usually able to pretty much all the work related to text just…

SQL SERVER – Fix – Login failed for user ‘username’. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)

January 17, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Earlier this week, I was on vacation and did not check my emails for three days and when I returned, I found six different emails from 4 different people asking for the same problem. When they attempted to login using their application to SQL Server they faced following error: Login…

SQL SERVER – Check for Database Integrity – Notes from the Field #011

January 16, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore

[Notes from Pinal]: There is always scenario when we suddenly end up having an error in our database query which is related to database integrity. We see error where SQL Queries are not executed due to there is corruption in the database file. When we see this happening, in many…

SQL SERVER – View dependencies returning all results – The ApexSQL Search tool

January 15, 2014

Pinal Dave

SQL

ApexSQL

ApexSQL Search is a Free SSMS and VS add-in for SQL object and data text search, and it shows visual relationships between objects – in SSMS called “view dependencies” but here it is fully utilized and functional. A powerful feature indeed.

Big Data – Real-Time Analytics Performance with ClustrixDB

January 14, 2014

Pinal Dave

Big Data, SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Note: The product used in comparison is ClustrixDB. It is available to download for FREE. NewSQL databases provide scale-out of NoSQL without giving up on SQL or ACID transactions. While most NewSQL databases focus only on transactions, ClustrixDB also provides fast real-time analytics that are becoming increasing important to many…