SQL Archives - Page 270 of 519 - SQL Authority with Pinal Dave

SQL SERVER – Various Leap Year Logics

March 3, 2012

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 – guest User and MSDB Database – Enable guest User on MSDB Database

February 24, 2012

Pinal Dave

SQL

SQL Scripts, SQL Server, SQL Server Security, System Database

I have written a few articles recently on the subject of guest account and MSDB Database. Here’s a quick list of these articles:

SQL SERVER – Disable Guest Account – Serious Security Issue
SQL SERVER – Force Removing User from Database – Fix: Error: Could not drop login ‘test’ as the user is currently logged in.
SQL SERVER – Detecting guest User Permissions – guest User Access Status

SQL SERVER – Various Leap Year Logics

SQL SERVER – Logon Trigger Feature for Managing Data Access

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

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

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

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

SQL SERVER – guest User and MSDB Database – Enable guest User on MSDB Database