October « 2010 « SQL Server Journey with SQL Authority

Archive for October, 2010

SQLAuthority News – Book Review – Beginning SQL Joes 2 Pros: The SQL Hands-On Guide for Beginners

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Book Review, SQLAuthority News, T SQL, Technology on October 21, 2010 | 6 Comments »

Beginning SQL Joes 2 Pros: The SQL Hands-On Guide for Beginners Rick A Morelan, Doug Fritz Link to Amazon Short Review: This is one book that provides a solid fundamental to the reader along with hands-on experience and in-depth learning. Right now, an error-free book that is closer to real world scenarios is very much [...]

Read Full Post »

SQL SERVER – Could not connect to TCP error code 10061: No connection could be made because the target machine actively refused it

Posted in SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on October 20, 2010 | 1 Comment »

I was recently getting following error in my StreamInsight Application. Could not connect to TCP error code 10061: No connection could be made because the target machine actively refused it. The solution was very simple, I had to enable exception of the my port in my windows firewall. The way I figured it out was [...]

Read Full Post »

SQLAuthority News – SQL Server Performance Optimizations Seminar – Grand Success – Colombo, Sri Lanka – Oct 4 – 5, 2010

Posted in MVP, SQL, SQL Authority, SQL Optimization, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQL Training, SQLAuthority Author Visit, SQLAuthority News, T SQL, Technology on October 19, 2010 | 7 Comments »

I have been on world tour on SQL Server Performance Optimizations Seminar. The latest seminar was conducted in Colombo, Sri Lanka on Oct 4 – Oct 5. I had previously written about this event over SQLAuthority News – SQL Server Seminar at Colombo Full. This event was oversubscribed and we could not accommodate the last [...]

Read Full Post »

SQL SERVER – Change Column DataTypes

Posted in SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on October 18, 2010 | 2 Comments »

There are times when I feel like writing that I am a day old in SQL Server. In fact, there are many who are looking for solution that is simple enough. Have you ever searched online for something very simple. I often do and enjoy doing things which are straight forward and easy for change. [...]

Read Full Post »

SQL SERVER – System Stored Procedure sys.sp_tables

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Stored Procedure, SQL System Table, SQL Tips and Tricks, T SQL, Technology on October 17, 2010 | 5 Comments »

I have seen people running the following script quite often, to know the list of the tables from the database: SELECT * FROM sys.tables GO The script above provides various information from create date to file stream, and many other important information. If you need all those information, that script is the one for you. [...]

Read Full Post »

« Newer Posts - Older Posts »