Blogs about: Sql Authority

Featured Blog

SQL Authority

I have been following the blog of SQL Authority, Pinal Dave, since I came to discover WordPress. Pinal’s focus on and dedication to his work comes through in his content. Although his specialty… more »

relationary

"Bits leaving out Time bill" Harvested My Sidereal year!

marthamaxine wrote 14 hours ago: This antiquated a just the same sunburned second and he seems exempli gratia granted gusto finished … more »

Tags: Molestation, Online Marketing, US attorney firings

SQLAuthority News - SQLAuthority T-Shirts, Mug, Hat and Other Product

pinaldave wrote 1 day ago: I frequently get request for SQLAuthority T-Shirts. After continuous requests from many of loyal rea … more »

Tags: SQL, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T-SQL, technology, SQL T-Shirt

SQL SERVER - 2005 -Track Down Active Transactions Using T-SQL — 8 comments

pinaldave wrote 2 days ago: Just a day ago, I was wondering how many active transaction are currently in my database. I found fo … more »

Tags: technology, SQL Server, SQL, SQL Query, SQL Tips and Tricks, Author Pinal, T-SQL, SQL Scripts, SQL Transactions

SQL SERVER - Introduction to Log Viewer — 2 comments

pinaldave wrote 3 days ago: SQL Server log data is very important for any DBA to troubleshoot SQL Server related problems. In SQ … more »

Tags: Author Pinal, SQL, SQL Query, SQL Security, SQL Server, SQL Tips and Tricks, T-SQL, technology, Log Viewer

SQL SERVER - FIX - ERROR : 9004 An error occurred while processing the log for database. If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log.

pinaldave wrote 5 days ago: ERROR : 9004 An error occurred while processing the log for database. If possible, restore from back … more »

Tags: SQL, SQL Backup and Restore, SQL Data Storage, SQL Error Messages, SQL Query, SQL Server, SQL Tips and Tricks, T-SQL, technology

SQLAuthority Author Visit - Ahmedabad SQL Server User Group Meeting - July 19 2008 — 3 comments

pinaldave wrote 5 days ago: Ahmedabad SQL Server User Group is just 2 months old chapter but it is getting extremely popular amo … more »

Tags: Best Practices, SQL, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQL User Group, SQLAuthority Visit, T-SQL

SQL Server - Fix - Error : 9692 The _MSG protocol transport cannot listen on port because it is in use by another process.

pinaldave wrote 1 week ago: If you face following error the solution of this is very simple. Error : 9692 The _MSG protocol tran … more »

Tags: SQL, SQL Error Messages, SQL Query, SQL Server, SQL Tips and Tricks, T-SQL, technology, Service Broker

SQL SERVER - Introduction to Service Broker — 2 comments

pinaldave wrote 1 week ago: Service Broker is message queuing for SQL Server. It is used for sending emails and through Database … more »

Tags: Author Pinal, SQL, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, T-SQL, technology, Service Broker

SQLAuthority News - Updated My Personal Book Mark Pages — 1 comment

pinaldave wrote 1 week ago: It has been long time since I have updated my personal book mark list. I have just refreshed it. You … more »

Tags: Database, dba, SQL, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T-SQL, technology

SQLAuthority News - Ahmedabad SQL Server Usergroup Meeting — 4 comments

pinaldave wrote 1 week ago: I will be attending Ahmedabad SQL Server Usergroup Meeting on July 19, 2008. I will be taking sessio … more »

Tags: SQL, SQL Query, SQL Server, SQL Tips and Tricks, SQL User Group, SQLAuthority Visit, T-SQL, technology

SQL SERVER - Readers Contribution to Site - Simple Example of Cursor — 1 comment

pinaldave wrote 1 week ago: eaders are very important to me. Without their active participation this site would not be the commu … more »

Tags: SQL, SQL Cursor, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T-SQL, technology

A store procedure for microsoft sql to check win

kostland wrote 1 week ago: This procedure use time… month and day CREATE procedure sp_update_WinHands @month as  nvarcha … more »

Tags: Script, Database, SQL DateTime, SQL Query, SQLAuthority News, T-SQL, SQL Data Storage, SQL Backup and Restore, SQL Documentation

SQL SERVER - Deferred Name Resolution — 4 comments

pinaldave wrote 1 week ago: One of my Jr. Developer always wondered when she creates any Stored Procedure (SP) and if there is i … more »

Tags: Author Pinal, SQL, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T-SQL, technology

SQL SERVER - 2008 - Introduction to SPARSE Columns - Part 2 — 1 comment

pinaldave wrote 1 week ago: Previously I wrote about SQL SERVER - 2008 - Introduction to SPARSE Columns. Let us understand the c … more »

Tags: Author Pinal, SQL, SQL Data Storage, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T-SQL

SQL SERVER - SP_CONFIGURE - Displays or Changes Global Configuration Settings

pinaldave wrote 1 week ago: It is very good to know our server and its feature which are available for configurations. SQL Serve … more »

Tags: Author Pinal, SQL, SQL Performance, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Tips and Tricks, T-SQL

SQL SERVER - 2005 - Two Important Security Update — 3 comments

pinaldave wrote 2 weeks ago: If you are using SQL Server 2005, following two are very important security updates not to be missed … more »

Tags: SQL, SQL Documentation, SQL Download, SQL Query, SQL Security, SQL Server, SQL Tips and Tricks, T-SQL, technology

SQL SERVER - 2008 - Introduction to SPARSE Columns — 3 comments

pinaldave wrote 2 weeks ago: I have been writing recently about how SQL Server 2008 is better in terms of Data Stage and Backup M … more »

Tags: Author Pinal, SQL, SQL Data Storage, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T-SQL

SQL SERVER - 2008 - Two Convenient Features Inline Assignment - Inline Operations — 5 comments

pinaldave wrote 2 weeks ago: Sometimes things just go very convenient and we wish that how come it was not available in earlier v … more »

Tags: Author Pinal, SQL, SQL Add-On, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, sqlcmd, T-SQL

SQLAuthority News - Thank You to Awarding Author SQL MVP — 6 comments

pinaldave wrote 2 weeks ago: I received award from Microsoft for SQL Server Most Valuable Professional a week ago. I have receive … more »

Tags: technology, SQL Server, SQL, SQL Query, dba, Database, SQL Tips and Tricks, SQLAuthority News, T-SQL