|
|
-
|
|
More often than not, there is a myth in the developer community that Microsoft SQL Server does not provide the debugging abilities that other IDEs provide. Even SQL Server 2000 provided basic debugging ability. Starting Microsoft SQL Server 2005, the product now comes with it’s own Management Studio......
|
|
-
|
|
As you know, we are exploring the world of graphical tools & utilities that are available to us out of the box in a Microsoft SQL Server installation. In the previous part of the tutorial, I provided an introduction to the SQL Server Management Studio (SSMS) and the Query Editor window. I hope t......
|
|
-
|
|
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......
|
|