SQL Archives - Page 244 of 520 - SQL Authority with Pinal Dave

SQLAuthority News – Storing Data and Files in Cloud – Dropbox – Personal Technology Tip

October 19, 2012

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

I thought long and hard about doing a Personal Technology Tips series for this blog. I have so many tips I’d like to share. I am on my computer almost all day, every day, so I have a treasure trove of interesting tidbits I like to share if given the…

SQL SERVER – Finding Different ColumnName From Almost Identitical Tables

October 18, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL System Table

I have mentioned earlier on this blog that I love social media – Facebook and Twitter. I receive so many interesting questions that sometimes I wonder how come I never faced them in my real life scenario. Well, let us see one of the similar situation. Here is one of…

SQLAuthority News – Pluralsight Course Review – Practices for Software Startups – Part 2 of 2

October 17, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices

This is the second part of the two part series of Practices for Software Startup Pluralsight Course. Please read the first part of this series over here. The course is written by Stephen Forte (Blog | Twitter). Stephen Forte is the Chief Strategy Officer of the venture backed company, Telerik. Personal…

SQLAuthority News – Pluralsight Course Review – Practices for Software Startups – Part 1 of 2

October 16, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices

This is first part of the two part series of Practices for Software Startup Pluralsight Course. The course is written by Stephen Forte (Blog | Twitter). Stephen Forte is the Chief Strategy Officer of the venture backed company, Telerik, a leading vendor of developer and team productivity tools. Stephen is also…

SQL SERVER – Free Print Book on SQL Server Joes 2 Pros Kit

October 15, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Joes 2 Pros, SQLAuthority Book Review

Rick Morelan and I were discussing earlier this month that what we can give back to the community. We believe our books are very much successful and very well received by the community. The five books are a journey from novice to expert. The books have changed many lives and…

SQL SERVER – Find First Non-Numeric Character from String

October 14, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL String

It is fun when you have to deal with simple problems and there are no out of the box solution. I am sure there are many cases when we needed the first non-numeric character from the string but there is no function available to identify that right away. Here is…

SQL SERVER – 2012 – List All The Column With Specific Data Types in Database

October 13, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DMV, SQL System Table

5 years ago I wrote script SQL SERVER – 2005 – List All The Column With Specific Data Types, when I read it again, it is very much relevant and I liked it. This is one of the script which every developer would like to keep it handy. I have…