All Articles - SQL Authority with Pinal Dave

SQL SERVER – Resolving SQL Server Connection Errors – SQL in Sixty Seconds #030 – Video

October 24, 2012

SQL, SQL Server, SQL Tips and Tricks, SQL Video

Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio

One of the most famous errors related to SQL Server is about connecting to SQL Server itself. Here is how it goes, most of the time developers have worked with SQL Server and knows pretty much every error which they face during development language. However, hardly they install fresh SQL…

SQL SERVER – Order By Numeric Values Formatted as String

October 23, 2012

Pinal Dave

SQL Tips and Tricks

SQL Server, SQL String

When I was writing this blog post I had a hard time to come up with the title of the blog post so I did my best to come up with one. Here is the reason why? I wrote a blog post earlier SQL SERVER – Find First Non-Numeric Character from String. One of the questions was that how that blog can be useful in real life scenario. This blog post is the answer to that question. Let us first see a problem.

SQL Authority News – Vacation, Travel and Study – A New Concept

October 22, 2012

Pinal Dave

SQLAuthority News

SQL Training, SQLAuthority Author Visit

Quite often when developers go to training sessions they either find it very boring because of study or great because they treat it as a vacation. There should be a perfect balance between study and extra activities.

SQLAuthority News – Windows Azure Training Kit Updated October 2012

October 21, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Azure, SQL Download

Microsoft has recently released the updated to Windows Azure Training Kit. Earlier this month they have updated the kit and included quite a lot of things. Now the training kit contains 47 hands-on labs, 24 demos and 38 presentations. The best part is that the kit is now available to download…

SQLAuthority News – Who I Am And How I Got Here – True Story as Blog Post

October 20, 2012

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

Best Practices

Here are few of the sample questions I get every day? “Give me shortcut to become superstar?” “How do I become like you?” “Which book I should read so I know everything?” “Can you share your secret to be successful? I want to know it but do not share with…

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

October 19, 2012

Pinal Dave

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

Personal Technology

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…