|
|
-
|
|
Per Books-On-Line, The Microsoft SQL Server is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions. The SQL Server Management Studio is an integrated environment for accessing, configuring, managing, administering, and developing all components ......
|
|
-
|
|
The properties and behaviour of each session to a SQL Server instance can be handled individually via use of various SET options. As we multi-task during the day, we tend to forget the exact SET options that we choose for a particular user session. The focus of the day is how to retrieve this inform......
|
|
-
|
|
Performance tuning & analysis during new development has it’s own unique challenge – on one hand as database developers, we need a clean procedure cache and on the other hand, we do not want to impact the performance of other databases on the same instance. To start from a cold procedure cache,......
|
|
-
|
|
Recently at the office, we ended up discussing the BIT data type (http://msdn.microsoft.com/en-us/library/ms177603.aspx). While we all understand that BIT is supposed to represents a Boolean value, we were not quite convinced. Boolean values are two-state – they can only be TRUE or FALSE (or 1 and 0......
|
|
-
|
|
I work with academia frequently, and therefore, get a chance to interact with students and experience the issues they face first hand. I recently had a very interesting experience during one of these visits. I will try to present the experience as a story. The Problem One of the students had devel......
|
|
-
|
|
Recently, someone in the team faced a fairly common requirement - to generate a comma-separated string from values stored in a table. This being the last post of the year, I thought of sharing the 2 most-commonly used methods I know of implementing this requirement. Do you know any other? If you s......
|
|
-
|
|
As 2011 comes to a close, I have expanded my participation in Social Media on the web. You can now follow me on the following: Twitter: Tweet to @nakulv_sql Google+: +Nakul Facebook: https://www.facebook.com/nakulvachhrajani For other options on how to stay in touch with me, please visit m......
|
|
-
|
|
Ever since I started working with Microsoft SQL Server, I have heard and read a lot about the coveted “Microsoft Certified Professional” status. I had yet to get my first certification even after working with SQL Server for the last 7 years. As the year 2011 dawned, I had made a resolution that no m......
|
|
-
|
|
I was playing around with my SQL 2012 (SQL 11/Denali) CTP03 instance the other day, and noticed a great usability enhancement to the Intellisense available in the Query editor. I was adding a reference to a particular web-page on a query that I was working on. Lo and behold, Intellisense was able t......
|
|
-
|
|
Today is the 1st birthday of this blog! It all began one year ago, during a Community Tech Days event on a cold winter day. Jacob Sebastian (blog) asked if I would be willing to share my experiences, thoughts and tips around Microsoft SQL Server via a blog. I had never blogged before, and therefore......
|
|