SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) : best practices

SQL Server Manageability series - shortcut for SSMS keyboard shortcuts!

Fri, 30 Oct 2009 08:08:00 GMT

For any user manage the work with short-cut is desirable, for better productivity in your work (with UI tools) I always suggest to manage it by keyboard not with the mouse. Here is another block of SQL manageability series I want to cover based on feedback...(read more)

Build an effiective Disaster Recovery solution for SQL Server Reporting Services

Sat, 24 Oct 2009 19:15:00 GMT

As a Systems Administrator/DBA or even as an user have you ever realised "What is your data worth to you?" If so then an important aspect of data recovery solution is a required step, whatever is the application or system you use data access...(read more)

Problems you face when you do not check features not supported in SQL Server

Fri, 18 Sep 2009 11:06:00 GMT

Few developers on a client's place raised a question that why they should really be concerned about deprecated features or commands in SQL Server? Until SQL Server 2000 version it used to be a workaround to get the old scripts executed in a way. It...(read more)

Developing Sharepoint Applications - Guidance for building collaborative applications that extend your LOB systems

Tue, 08 Sep 2009 11:59:00 GMT

Here is the know-how and concentration on a comprehensive platform for application development combined with extensible customer ready applications. This is the email communication from Microsoft that i would share here. It is helpful if the users are...(read more)

SQL Server Upgrade from 2005 to 2008 - Notes and Best Practices from field :session from SQLBits conference

Thu, 27 Aug 2009 09:43:00 GMT

During the SQLBits IV conference I had presented a session on the topic: " Upgrading To SQL Server 2005 & 2008: Notes & Best Practices " with an excellent feedback from users. In this session the areas are covered such as SQL Server...(read more)

Removal of SQL DMO in future release of SQL Server - take action now!

Tue, 18 Aug 2009 07:52:00 GMT

If you remember about SQL Server 2005 installation & feature documentation SQL-DMO has been referred as backward compatibility, and that feature will be removed in a future version of SQL Server. So the documentation has been heavy on users to avoid...(read more)

SQL Server Peer-to-Peer replicaton - how to achieve scalability and availability

Tue, 28 Jul 2009 07:39:00 GMT

Replication will be very handy to distribute the load of application when you have large scale of data management, as it evolved from SQL Server 6.0 version the transactional replication is first baby that was primarily used to support reporting applications...(read more)

SQL Server TEMPDB - A key factor in monitoring and keeping up the performance! (update)

Tue, 28 Jul 2009 07:05:00 GMT

You may think on the subject line why TEMPDB is a key factor, a simple term is the size and physical placement of the tempdb database can affect the performance of a system. Even a simple query requires the access/process to TEMPDB, which is a part of...(read more)

SQL Server error: Msg 6101, Level 16, State 1, Line 1 Process ID -2 is not a valid process ID. Choose a number between 1 and 2048 - update

Mon, 27 Jul 2009 07:07:00 GMT

Here is the quirky error that has caused a resources crunch on a SQL instance, Error : Process ID -2 is not a valid process ID . The actual issue occurred during an update to a table that has been used by Online application to update the action log, intially...(read more)

SQL Server performance problem, how bad it is or rather I ask how good are you to find the root cause?

Mon, 27 Jul 2009 06:53:00 GMT

I always trust how good your resources are to find out a root cause than how bad the problem is? It is one of the best point of disaster recovery position I wanted to be to get to work on solution on quicker basis than worrying about the impact, the business...(read more)

Microsoft Security Bulletin Summary for May 2009 - Critical Security Bulletins

Tue, 02 Jun 2009 11:52:00 GMT

This bulletin summary lists security bulletins released for May 2009. The full version of the Microsoft Security Bulletin Summary for May 2009 can be found at http://www.microsoft.com/technet/security/bulletin/ms09-may.mspx . With the release of the bulletins...(read more)

Do you know how many Monitoring Tools and Resources available in SQL Server?

Mon, 01 Jun 2009 07:25:00 GMT

Monitoring Tools and Resources are essential for performance tuning & better manageability in SQL Server. Many times the users think that collection and analysis of performance data is not a day-to-day job, also I feel that it is difficult at best...(read more)

Proactive caching for Analysis Services databases - performance techniques and better usage

Sun, 31 May 2009 14:32:00 GMT

By default SQL Server has a pool of memory that is used to store both execution plans and data buffers. This pool of memory is managed by default within Analysis Services for SQL Server and such percentage of the pool allocated to either execution plans...(read more)

SQL Server Error Msg:911 Could not locate entry in sysdatabases for database 'mssqlsystemresource'.

Sat, 23 May 2009 08:42:00 GMT

The error on the subject line is not a good sign when you have the mammoth task of moving SQL Server system databases, I would agree that the task of system databases migration is not a day-to-day task and you must have practised the required steps. For...(read more)

SQL Server Edition - which is the best one to choose for your database needs?

Sun, 17 May 2009 17:54:00 GMT

When I look at the question, I feel that no direct answer to it! The reason being SQL Server has outgrown into an important enterprise RDBMS product from a simple desktop based database application, but still maintains the ease of installation and use...(read more)

SQL Server Performance patterns of a UDF with datetime parameters

Mon, 11 May 2009 07:10:00 GMT

There was an interesting discussion about User Defined Fuctions (UDF) performance and patterns, the actual phenomenon is that UDF has got parameters to pass on during the execution. Just to talk about introduction of such options in the SQL Server history...(read more)

Troubleshooting blocking in SQL Server 2005 and 2008 - new tool

Fri, 01 May 2009 07:47:00 GMT

How do you monitor and catch the blocked process within your SQL environment? Using Query Editor in SQL Server Management Studio to find the blocked processes is a common approach and further to that you can use the advanced configuration (SP_CONFIGURE...(read more)

Pattern and Practices - deprecate and discontinued Transact SQL features

Thu, 23 Apr 2009 07:10:00 GMT

Deprecate and Discontinued features, are not a words for Developers and DBAs which is a first point of option that they must be concentrated. What they mean is the defined features include a complete/partial change in supported compatibility levels, for...(read more)

A big question in SQL Server - create a table with more than 1024 columns?

Mon, 06 Apr 2009 07:46:00 GMT

IT was an interesting question to ask/know about create a table with more than 1024 columns? If you try to do so then obvious error: CREATE TABLE failed because column '<ColName>' in table 'MaxSparseColumnTest' exceeds the maximum...(read more)

Get a mixture of Technical content from MIX09 sessions

Tue, 24 Mar 2009 17:55:00 GMT

MIX & PDC, 2 popular and catchy conferences for Developers in IT world! I favour MIX conference more than PDC as you get to know in-depth knowledge & features about cloud computing, .NET services and other major exciting developing technologies...(read more)