Database « SQL Server Journey with SQL Authority

Archive for the ‘Database’ Category

SQL SERVER – Convert Subquery to CTE – SQL in Sixty Seconds #001 – Video

Posted in Database, Pinal Dave, PostADay, SQL, SQL Authority, SQL in Sixty Seconds, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Video on February 8, 2012 | 9 Comments »

SQL Server is an ocean of information. I believe if one starts learning today, after 60 years he/she may still be learning the subject (there are always a few exceptions)! Recently, I published the SQL Server Questions and Answers video tutorial, and since the course came out, I have been receiving lots of request to [...]

Read Full Post »

SQLAuthority News – I am Speaking at SQL Saturday 116 – Bangalore, India on January 7, 2012 – First SQL Saturday in India

Posted in About Me, Best Practices, Database, Pinal Dave, PostADay, SQL, SQL Authority, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Author Visit, SQLAuthority News, SQLServer, T SQL, Technology, tagged SQL Saturday on January 5, 2012 | 1 Comment »

SQLSaturday 116 is now only 3 days away. SQL Saturday is FREE event all the attendees and 100% SQL community driven. This is very first SQL Saturday in India and I am very much excited that I will be speaking at this event on my favorite subject of SQL Server Performance Tuning. I have so [...]

Read Full Post »

SQLAuthority News – SQL Saturday 116 – SQL Saturday in Bangalore, India on January 7, 2012 – 4 Saturdays to Go

Posted in About Me, Database, Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, SQLServer, T SQL, Technology, tagged SQL Saturday on December 10, 2011 | Leave a Comment »

SQLSaturday 116 is now only 4 weeks away. SQL Saturday is FREE event all the attendees and 100% SQL community driven. Schedule and Venue Event Date: January 7, 2012 Event Time: 10 AM to 6 PM Event Venue: Microsoft Singature Building, Domlur, Bangalore , Bangalore, India Important Links: Register for the event – We are [...]

Read Full Post »

SQL SERVER – Error: Deleting Offline Database and Creating the Same Name

Posted in Database, Pinal Dave, PostADay, Readers Contribution, Readers Question, SQL, SQL Authority, SQL Query, SQL Server, SQL Server Management Studio, SQL Tips and Tricks, T SQL, Technology on December 8, 2011 | 7 Comments »

Offline database is very interesting subject, and there are a couple of interesting details associated with it, which one must know. There are two common queries related to offline database: 1) My hard drive is getting full and I deleted my ‘offline’ databases. After deleting my offline databases, my hard drive is still full and [...]

Read Full Post »

SQLAuthority News – SQL Saturday 116 – SQL Saturday in Bangalore, India on January 7, 2012

This is the biggest news for SQL Enthusiast in India. SQL Saturday is here in India. PASS SQLSaturday’s are free 1-day training events for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. We think you’ll find it’s a [...]

Read Full Post »

Older Posts »