SQL Server Archives - Page 156 of 393 - SQL Authority with Pinal Dave

SQLAuthority News – TechED India 2012 – Bangalore – March 21-23, 2012

March 6, 2012

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

TechEd is one event which every developers and IT professionals are looking forward to attend. It is opportunity of life time and no matter how many time one gets chance to engage with it, it is never enough. I still remember every single moment of every TechEd I have attended…

SQL SERVER – Various Leap Year Logics

March 3, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime

Earlier I wrote one article on Leap Year and created one video about Leap Year. My point of view was to demonstrate how we can use SQL Server 2012 features to identify Leap year. How ever during the conversation I had some really good conversation. Here are updates for those…

SQLAuthority News – The Best Quotes of “Who Wrote This?” Contest

March 1, 2012

Pinal Dave

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

I am a frequent reader of Brent Ozar PLF, it is one of my favorite blogs. A recent post announced a “Who Wrote This?” contest to see if readers could tell their three contributors apart based on some writing samples. Here are my favorite lines from the sample paragraphs, from…

SQL SERVER – Function: Is Function – SQL in Sixty Seconds #004 – Video

February 29, 2012

Pinal Dave

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

Database, SQL in Sixty Seconds, SQL Scripts

Today is February 29th. An unique date which we only get to observe once every four year. Year 2012 is leap year and SQL Server 2012 is also releasing this year. Yesterday I wrote an article where we have seen observed how using four different function we can create another…

SQL SERVER – Detecting Leap Year in T-SQL using SQL Server 2012 – IIF, EOMONTH and CONCAT Function

February 28, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts

Note: Tomorrow is February 29th. This blog post is dedicated to coming tomorrow – a special day :) Subu: “How can I find leap year in using SQL Server 2012?“ Pinal: “Are you asking me how to year 2012 is leap year using T-SQL – search online and you will…

SQL SERVER – A Cool Trick – Restoring the Default SQL Server Management Studio – SSMS

February 25, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

“I do not know where my windows went!” “I just closed my object explorer and now I cannot find it.” “How do I get my original windows layout back in SQL Server Management Studio?” “How do I get the window which was there in left side back again?” Since last…

SQL SERVER – Detecting guest User Permissions – guest User Access Status

February 23, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Security

Earlier I wrote the blog post SQL SERVER – Disable Guest Account – Serious Security Issue, and I got many comments asking questions related to the guest user. Here are the comments of Manoj: 1) How do we know if the uest user is enabled or disabled? 2) What is the default for…