All Articles - SQL Authority with Pinal Dave

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

December 5, 2011

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

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.

SQL SERVER – Using expressor Composite Types to Enforce Business Rules

November 29, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation

One of the features that distinguish the expressor Data Integration Platform from other products in the data integration space is its concept of composite types, which provide an effective and easily reusable way to clearly define the structure and characteristics of data within your application. An important feature of the…

SQLAuthority News – SafePeak’s SQL Server Performance Contest – Winners

November 28, 2011

Pinal Dave

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

SafePeak, the unique automated SQL performance acceleration and performance tuning software vendor, announced the winners of their SQL Performance Contest 2011. The contest quite unique: the writer of the best / most interesting and most community liked “performance story” would win an expensive gadget. The judges were the community DBAs…

SQL SERVER – Powershell – Get a List of Fixed Hard Drive and Free Space on Server

November 27, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Powershell, SQL Scripts, SQL Stored Procedure

Earlier I have written this article SQL SERVER – Get a List of Fixed Hard Drive and Free Space on Server. I recently received excellent comment by MVP Ravikanth. He demonstrated that how the same can be done using Powershell. It is very sweet and quick solution. Here is the…

SQL SERVER – Get Directory Structure using Extended Stored Procedure xp_dirtree

November 26, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Stored Procedure

Many years ago I wrote article SQL SERVER – Get a List of Fixed Hard Drive and Free Space on Server where I demonstrated using undocumented Stored Procedure to find the drive letter in local system and available free space. I received question in email from reader asking if there any…