August 2009 - Page 4 of 5 - SQL Authority with Pinal Dave

SQLAuthority News – A Quick Guide to Twitter

August 10, 2009

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

I am a very big fan of Twitter. I have been using it for quite sometime now and I think it is a very convenient way to stay connected with friends, families, and even the world. You can share or connect with them in real-time and tell them what you…

SQLAuthority News – Interview with SQL Server MVP Glenn Berry

August 9, 2009

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, MVP

Glenn Berry works as a Database Architect at NewsGator Technologies in Denver, CO. He is a SQL Server MVP, and has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS. He is also an Adjunct Faculty member at University College – University of Denver, where…

SQL Server – Multiple CTE in One SELECT Statement Query

August 8, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

CTE, SQL Joins, SQL Scripts

I have previously written many articles on CTE. One question I get often is how to use multiple CTE in one query or multiple CTE in SELECT statement. Let us see quickly two examples for the same. I had done my best to take simplest examples in this subject. Option…

SQLAuthority News – Humorous SQL Cake – Funny SQL Cake

August 7, 2009

Pinal Dave

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

SQL Humor

I received the following interesting images in email during the past 2 months. I think they are superbly hilarious! I received them from various people at different times, so their is unknown. Let me know which of the following images you find the most interesting. Hope you enjoyed watching them!…

SQL SERVER – Get Time in Hour:Minute Format from a Datetime – Get Date Part Only from Datetime

August 6, 2009

Pinal Dave

SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts, SQL Server

I have seen scores of expert developers getting perplexed with SQL Server in finding time only from datetime datatype. Let us have a quick glance look at the solution. Let us learn about how to get Time in Hour:Minute Format from a Datetime as well as to get Date Part Only from Datetime.

SQL SERVER – Get a List of Fixed Hard Drive and Free Space on Server

August 5, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Stored Procedure, undocumented SQL

When I am not blogging, I am typically working on SQL Server Optimization projects. Time and again, I only have access to SQL Server Management Studio that I can remotely connect to server but do not have access to Operating System, and it works just fine. At one point in…

SQL SERVER – Forgot the Password of Username SA

August 4, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server Management Studio, SQL Server Security

I just received a call from an old friend with whom I used to work in Las Vegas. He told me about a password-related issue he faced in his organization. They had changed the password of username SA and now they are not able to recall the new password. I…