This blog post is about SafePeak “Logon Trigger” Feature for Managing Data Access. Just a quick update the product is no longer available.
SQLAuthority News – The Best Quotes of “Who Wrote This?” Contest
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…
Read MoreSQL SERVER – Function: Is Function – SQL in Sixty Seconds #004 – Video
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…
Read More
SQL SERVER – Detecting Leap Year in T-SQL using SQL Server 2012 – IIF, EOMONTH and CONCAT Function
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…
Read MoreSQL SERVER – A Cool Trick – Restoring the Default SQL Server Management Studio – SSMS
“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…
Read More
SQL SERVER – guest User and MSDB Database – Enable guest User on MSDB 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 – Detecting guest User Permissions – guest User Access Status
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…
Read More