Pinal Dave - SQL Server Performance Tuning Expert

SQLAuthority News – SQL Server Interview Questions and Answers Available on Kindle Format as eBook to Download

December 6, 2011

Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Reading the books on Kindle seems to be very popular. Since our new book released a month ago, we have received so many request from users regarding making it available on Kindle. Well, today we have acknowledge the request. Our new book is available to purchase on kindle. SQL Server…

SQLAuthority News – SQL Saturday 116 – SQL Saturday in Bangalore, India on January 7, 2012

December 5, 2011

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, SQL Saturday

This is the biggest news for SQL Enthusiast in India. SQL Saturday is here in India. PASS SQLSaturday’s are free 1-day training events for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. We…

SQLAuthority News – Microsoft SQL Server ODBC Driver for Linux Available Now

December 4, 2011

Pinal Dave

SQLAuthority News

SQL Download

We discussion pretty much everything that DBA do in their daily life. Microsoft SQL Server ODBC Driver for Linux Available Now.

SQLAuthority News – Download Whitepaper 5 Tips for a Smooth SSIS Upgrade to SQL Server 2012

December 3, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download

Microsoft SQL Server 2012 Integration Services (SSIS) provides significant improvements in both the developer and administration experience. This article provides tips that can help to make the upgrade to Microsoft SQL Server 2012 Integration Services successful. The tips address editing package configurations and specifically connection strings, converting configurations to parameters,…

SQL SERVER – Effect of SET NOCOUNT on @@ROWCOUNT

December 2, 2011

Pinal Dave

SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server

Today I had very interesting experience when I was presenting on SQL Server. While I was presenting the session when I ran query SQL Server Management Studio returned message like (8 row(s) affected) and (2 row(s) affected) etc. After a while at one point, I started to prove usage of @@ROWCOUNT function.

SQL SERVER – Where Can YOU Get My Books – SQL Server Interview Question and Answers

December 1, 2011

Pinal Dave

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

Best Practices, SQL Documentation, SQL Download, SQLAuthority Author Visit, SQLAuthority Book Review

Earlier month I released by third book SQL Server Interview Question and Answers. The focus of this book is ‘master the basics’. If you rate yourself 10 out of 10 in SQL Server – this book is not for you but if you want to learn fundamentals or want to…

SQL SERVER – Fix: Error: File Cannot be Loaded Because the Execution of Scripts is Disabled on This System

November 30, 2011

Pinal Dave

SQL

Powershell, SQL Error Messages, SQL Scripts, SQL Server

Yesterday I formatted my computer and did a fresh install as it was due from a long time. After the fresh install when I tried to install Semantic Search application using PowerShell, I was stopped by the following error. The error was related to an execution of scripts.