July « 2010 « SQL Server Journey with SQL Authority

Archive for July, 2010

SQLAuthority News – Community TechDays, Ahmedabad – July 24, 2010

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Author Visit, SQLAuthority News, T SQL, Technology, tagged SQL Spatial on July 17, 2010 | 3 Comments »

Dive deep into the world of Microsoft technologies at the Community TechDays and get trained on the latest from Microsoft. Build real connections with Microsoft experts and community members, and gain the inspiration and skills needed to maximize your impact on your organization while enhancing your career. What more… you can watch some of these [...]

Read Full Post »

SQL SERVER – Datetime Function TODATETIMEOFFSET Example

Posted in Pinal Dave, SQL, SQL Authority, SQL DateTime, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on July 16, 2010 | 4 Comments »

Earlier I wrote about SQL SERVER – Datetime Function SWITCHOFFSET Example. After reading this blog post, I got another quick reply that if I can explain the usage of TODATETIMEOFFSET as well. Let us go over the definition of the TODATETIMEOFFSET from BOL: Returns a datetimeoffset value that is translated from a datetime2 expression. What [...]

Read Full Post »

SQL SERVER – Datetime Function SWITCHOFFSET Example

Posted in Pinal Dave, SQL, SQL Authority, SQL DateTime, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on July 15, 2010 | 2 Comments »

I was recently asked if I know how SWITCHOFFSET works. This feature only works in SQL Server 2008. Here is quick definition of the same from BOL: Returns a datetimeoffset value that is changed from the stored time zone offset to a specified new time zone offset. What essentially it does is that changes the [...]

Read Full Post »

SQLAuthority News – Two SQL Sessions at SQL Data Camp at Chennai – July 17, 2010

Posted in MVP, Pinal Dave, SQL, SQL Authority, SQL Index, SQL Query, SQL Server, SQL Tips and Tricks, SQL User Group, SQLAuthority Author Visit, SQLAuthority News, T SQL, Technology, tagged Spatial Database on July 14, 2010 | 15 Comments »

I will be presenting two SQL Server advance level sessions at SQL Data Camp @ Chennai. I am very excited for this event as I am going to meet my friends Sugesh, Deepak, Vidhya and Madhivanan at this event. All of them are SQL Server MVPs. I have come to know that there are two [...]

Read Full Post »

SQL SERVER – How do I Learn and How do I Teach

Posted in About Me, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on July 13, 2010 | 11 Comments »

This blog post is written in response to T-SQL Tuesday hosted by Robert L Davis (aka SQLSoldier). The blog post has raised three very interesting questions. How do you learn? How do you teach? What are you learning or teaching? Let me try to answer the same. How do I learn? This question is very [...]

Read Full Post »

« Newer Posts - Older Posts »