SQL Server Cheatsheet has been extremely popular download from my blog. There are plenty of request for me to update it with SQL Server 2012 features. I have finally upgraded the cheatsheet with SQL Server 2012 features. The new cheatsheet has following updates
SQLAuthority News – Reliving TechEd at Bangalore User Groups
TechEd India 2012 was held in Bangalore last March 21 to 23, 2012. Just like every year, this event is bigger, grander and inspiring. Here is my blog post reviewing the event SQLAuthority News – #TechEdIn – TechEd India 2012 Memories and Photos. For me this is a family event – I get to meet my friends who are dear as my family. I like to call User Groups as family too. Family shares life’s personal happiness and experience – the same way User Group shares professional experiences and quite often UG members become just like a family member.
SQL SERVER – Install Samples Database AdventureWorks for SQL Server
AdventureWorks is a Sample Database shipped with SQL Server and it can be downloaded from GitHub site. AdventureWorks has replaced Northwind and Pubs from the sample database in SQL Server 2005. The Microsoft team keeps updating the sample database as they release new versions.
SQL SERVER – Technical Reference Guides for Designing Mission-Critical Solutions
Yesterday I was reading architecture reference material helping my friend who was looking for material in this respect. While working together we were searching twitter, facebook and search engines to find relevant material.While searching online we end up on very interactive reference point. Once I send the same to him, he replied he may not need anything more after referencing this material. Let’s learn about Designing Mission-Critical Solutions in this blog post.
SQL SERVER – Logon Trigger Feature for Managing Data Access
This blog post is about SafePeak “Logon Trigger” Feature for Managing Data Access. Just a quick update the product is no longer available.
SQL SERVER – Identifying Guest User using Policy Based Management
If you are following my recent blog posts, you may have noticed that I’ve written a lot about Guest User in SQL Server. Here are all the blog posts which I have written on Policy Based Management subject. One of the requests I received was whether we could create a policy that would prevent users unable guest user in user databases. Well, here is a quick tutorial to answer this. Let us see how quickly we can do it.
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