-
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...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
01-22-2012
Filed under:
Filed under: Development, Administration, T-SQL, Tips, SQL Server, Denali, #SQLServer, #TSQL, Best Practices, Guidance, DBA, SSMS, Tools and Utilities, Community, Series, Debugging
-
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 that...
-
For those of us who spend time on the SQL Server Forums , you’ll probably agree that one of the most common calls for assistance relates to troubleshooting SQL Server connections. This is why Rick Byham’s TechNet Wiki article on “ How to Troubleshoot Connecting to the SQL Server Database Engine ” is...
-
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 of...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
01-15-2012
Filed under:
Filed under: Development, Administration, Tips, SQL Server, #SQLServer, #TSQL, Guidance, SSMS, Tools and Utilities, Community, Series
-
I don’t know about you guys, but I am really petrified of public speaking. So I always try to read about it and it really gives me some comfort to know that I am not alone. In fact, if your fear of public speaking is between mild anxiety and complete terror, you are said to be well within the normal...
-
I had many posts that share my experiences with using package configuration files to make my SSIS packages portable from my local development BIDS environment, to the test environment, and the production environment. In the next few blogs, I’ll share with you a few simple steps to create your own...
-
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 information...
-
Without running the following code , can you guess the datatype of the column t? select null+getdate()+772.67 as t into #t5
-
The following SQL Server exams are due to retire on 31 July 2012: Exam 70-453 - Upgrade: Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008 Exam 70-454 - Upgrade: Transition Your MCITP SQL Server 2005 DBD to MCITP SQL Server 2008 DBD Exam 70-455 - Upgrade: Transition Your MCITP SQL Server...
-
Everybody deserves a second chance in love, life, and in TSQL as well! Now that it's the beginning of a New Year, 2012, it's the perfect time to start over again, and make up for the things that you missed, should the opportunity present itself. That's why I am blogging right now, because...
-
The SYSIBM.SYSDBAUTH maintains user privileges on databases The SYSIBM.SYSPLANAUTH maintains user privileges on plans The SYSIBM.SYSUSERAUTH maintain user privileges on the system. This shell script collects and records these recordsets. Useful for regular DB2 security audits. working_dir=$PWD logfile...
-
The challenge is to wrap long text sequences to a specified overall width (wrap position) - similar to columns in a newspaper. http://beyondrelational.com/puzzles/challenges/107/implement-word-wrapping-in-tsql.aspx
-
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, we...
-
A reader asked me how to add grand totals a matrix ( A Sample of Matrix in SSRS ). It’s actually pretty easy to accomplish that in both SSRS 2005 and 2008. I am going to show a few screen shots here. Challenge Suppose you have a very simple table with sales data for products sold from each store...
-
Cross tab result is always required and it is bit complex in case of dynamic column. If column name has to be dynamic then this is the good idea to have the PIVOT Query, for example I have 3 Tables and data like this: First Table ----------------------------------------------------------- IF OBJECT_ID...