expressor Studio is a new data integration platform that is being marketed as the most easy to use tools of its kind. But “easy to use” can be a relative term – an expert can find a very complex system easier, but a beginner might be stumped. A recent article online discussed exactly what makes expressor Studio so easy use, and here is my view on this subject.
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 – Various Leap Year Logics
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…
Read More
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.
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 More
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 – Standards Support, Protocol, Data Portability
Let us read more about Standards Support, Protocol, Data Portability. Sometimes I read easy things and sometimes not so easy.
SQL 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