SQLAuthority.com

Best Articles
Best Articles Of SQLAuthority
Favorite Articles
Pinal Dave's Preference
SQL Script Bank
Useful SQL Server Scripts
Top Downloads
Downloads
Search SQLAuthority
Hunt using SQLAuthority
Job SQLAuthority.com
Let your dream come true
All - Articles
All Articles at one instance
MVP Profile
Exceptional Technical Community Leader
IP Address
Find your IP Address
Sitemap
List of Links from the site

Tip of the Minute

Order By clause is used for sorting records in Ascending or Descending order.
--Pinal Dave

Latest Articles

SQL SERVER - Simple Use of Cursor to Print All Stored Procedures of Database ...
I love active participation from my readers. Just a day ago I wrote article about SQL SERVER - Simple Use of Cursor to Print All Stored Procedures of Database. I just received comment from Jerry Hung ...
SQLAuthority News - SQL Server White Paper: SQL Server 2008 Compliance
Organizations across the globe are being inundated with regulatory requirements. They also have a strong need to better manage their IT systems to ensure they are operating efficiently and staying secure. ...
SQL SERVER - Simple Use of Cursor to Print All Stored Procedures of Database
SQLAuthority Blog reader YordanGeorgiev has submitted very interesting SP, which uses cursor to generate text of all the Stored Procedure of current Database. This task can be done many ways, however, ...
SQLAuthority News - Author Visit - South Asia MVP Open Day 2008 - Goa
MVP Open day 2008 is one of the best event happened so far. I have previously written about this event in detail on this blog. SQLAuthority News - Author Visit - South Asia MVP Open Day 2008 - Goa - Link ...
SQLAuthority News - Author Visit - South Asia MVP Open Day 2008 - Goa
Yesterday was our last day at South Asia MVP Open Day. For three days continuously we are having great time along with fellow MVP. Every MVP was having great time because the way whole event was planned. ...
SQLAuthority News - Author Visit - South Asia MVP Open Day 2008 - Goa
At MVP Open Day we were promised that we will have 8 to 8 action packed day but we all observed much longer hours where we all MVP’s were busy with activity. I will say instead of 8 AM to 8 PM we actually ...
SQLAuthority News - Author Visit - South Asia MVP Open Day 2008 - Goa
It is great fun! Perfect Event and Great start. Yesterday I wrote about agenda of South Asia MVP Open Day 2008 which is at Hotel Kenilworth Resorts, Goa. November 15 - Day 1 of Open Day started with plain ...
SQLAuthority News - Author Visit - South Asia MVP Open Day 2008 - Goa
Today is very exciting day as I will start my trip to South Asia MVP Open Day 2008 - Goa. Yesterday I wrote about my visit. I will be attending South Asia MVP Open Day 2008 on November 15 - 17, 2008 at ...
SQLAuthority News - Author Visit - South Asia MVP Open Day 2008 - Goa
I will be attending South Asia MVP Open Day 2008 on November 15 - 17, 2008 at Hotel Kenilworth Resorts, Goa. I am very excited as this will be my first Open Day event after being MVP. Microsoft Most Valuable ...
SQLAuthority News - RML Utilities - Usage and Additional Help
Yesterday I wrote about SQLAuthority News - Download RML Utilities for SQL Server. I received many emails where different developers requested how to find additional help regarding RML Utilities. Few ...
SQLAuthority News - Download RML Utilities for SQL Server
The RML utilities allow you to process SQL Server trace files and view reports showing how SQL Server is performing. For example, you can quickly see: Which application, database or login is using the ...
SQL SERVER - Delete Backup History - Cleanup Backup History
SQL Server stores history of all the taken backup forever. History of all the backup is stored in msdb database. Many times older history is no more required. Following Stored Procedure can be executed ...
SQL SERVER - Check Database Integrity for All Databases of Server
Today we will see quick script which will check integrity of all the database of SQL Server. EXEC sp_msforeachdb ‘DBCC CHECKDB(”?”)’ Above script will return you lots of messages in resultset. If there ...
SQLAuthority News - SQL Server 2008 Book Online Updated in October 2008
SQL Server 2008 Books Online is updated on 31 October 2008. I always bookmark latest BOL for my easy reference. Getting Started: New and Updated Topics (31 October 2008) Analysis Services - Multidimensional ...
SQL SERVER 2008 - Connect Visual Studio 2005 Patch Download
It was not possible to connect SQL Server 2008 to Visual Studio 2005 so far. Microsoft has released Service Pack once it is installed SQL Server 2008 can be connected to Visual Studio 2005. Download Microsoft ...
SQL SERVER - Refresh Database Using T-SQL
Yesterday I received following questions on blog. Ashish Agarwal asked following question. Hi Pinal, Can we refresh a database (like we do by right clicking database node in object explorer and clicking ...
SQLAuthority News - 5 Millions Visitors - 2 Anniversary - Authors Note ...
I just received following screen shot from one of the regular reader of SQLAuthority.com blog. He pointed out important milestone for our blog. We have crossed 5 millions visitors. In less than 2 years ...
SQL SERVER - Clear Drop Down List of Recent Connection From SQL Server ...
Quite often it happens that SQL Server Management Studio’s Dropdown box is cluttered with many different SQL Server’s name. Sometime it contains the name of the server which does not exist or developer ...
SQL SERVER - Fix : Error: 4064 - Cannot open user default database. Login ...
I have received following question nearly 10 times in last week though emails. Many users have received following error while connecting to the database. This error happens when database is dropped for ...
SQLAuthority News - SQL Server Security Whitepapers
Microsoft has published following three security related white papers. I suggest to all my readers to read them. Read the summary know what is covered in those  white papers. Engine Separation of Duties ...

SQLAuthority.com - Frequently Used Scripts

SQL SERVER 2008 - Script Bank

SQLAuthority.com - Script Bank