Welcome to SSQA.net Sign in | Join | Help

SQL Server Storage Engine & Tools (SSQA.net)

SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.

Browse by Tags

All Tags » 2005   (RSS)
Cumulative Update 8 package for SQL Server 2005 Service Pack2
I felt like somehow I missed to post the availability of Cumulative Update package releases here and referring the last CU7_Update package blogpost now we have CU8 available for download if the specified problem occurs in your platform as per the KBA Read More...
SQL Server High Number of User Connections found on PERFMON, how to resolve it?
I was working with one of the user project to monitor the Performance Audit of their SQL Server estate. One SQL instance among the SQL farm is very important to their day-to-day business and cannot sustain even 5 minutes of downtime which is termed as Read More...
SQL Server 2005 unable to drop schema error: Cannot drop schema <> because it is being referenced by object
Recently I have received an email about unable to drop schemas that are adopted in the database design within an environment, here it goes. I'm setting up an automatic build process that also includes building one or more databases. Initially it was decided Read More...
SQL Server 2005: What percentage of changes happened within the database after the last successful backup?
No doubt that the blog subject will be a most wanted requirement on their databases, that is most responsible for a SQL Server database then arguably the most critical task that you absolutely MUST get right is your database backup procedures. Where the Read More...
SQL Server 2005 Service Pack 3 - work started
Ok here is the hot news for SQL 2005 users!!! From the Are you ready for SP3 post here, it has been officially announced the SP3 for SQL Server 2005 will be available in CY2008 (calender year 2008) that means before 31st December 2008! More from this Read More...
SQL Server 2005 logging providers - make best use for SSIS packages to diagnose the issues
Log or trace of activities will help you to get detailed information on what's going wrong, that too very useful for ETL based processes. In this regard within SQL Server 2005 using SSIS you can enable such logging within the package's runtime. This will Read More...
End of Mainstream support for SQL Server 2000 & 2005 (SP1) today, then how about SP2?
The subject say it all, as of today the mainstream support for SQL Server 2000 (SP4) and SQL Server 2005 (SP1) will be ended. That means for SQL Server 2005 service pack 1 there will not be any support and that can be obtained with a Custom Support agreement Read More...
Error while executing DMV - Msg 102, Level 15, State 1, Line 3 Incorrect syntax near '('.
DMV - has got very special place for DBAs since the inception of SQL Server 2005. In this case one of the thme is very important to find out the index statistics within your database, such as sys.dm_db_index_physical_stats statement. Recently one of the Read More...
The SQL server specified in SSIS service configuration is not present or is not available. This might occur where there is no default instance of SQL Server on the computer
Multiple versions of SQL Server installation is quite common when your enterprise is looking forward to upgrade to latest versions of SQL Server, in this regard recently one of the Application user reported a problem with regard to SSIS & DTS services Read More...
SQL Server license with multi-core CPU technology, confusing concepts?
How many SQL Server licenses you need to fix the number of CPUs on the server? The answer it depends on the number! Well having hyper-threading (i.e. multiple threads execute on a single physical CPU appearing as 2 logical CPUs) and dual-core technology Read More...
SQL Server consolidation and virtualization - hot topic in the industry
I have no doubt in stating that Virtualization has become hot topic in the industry now a days, that is leading to consolidate your Database platform using available technologies. The main interest in getting this up is that virtualization can lower overall Read More...
SQL Server 2005 debug a stored procedure, how-to?
If you are Developer then debugging your own code is an usual practice and when you got used to perform the same on SQL Server 2000 version, it is not an easy way in SQL Server 2005 version. As you may be aware that SQL Server 2000 engine includes a debugger Read More...
How to resolve SQL Server 2005 error: The read on the database failed. Reason: Failed to load Msxmlsql.dll
Database Mail, very flexible to setup and easily manageable as compared to its pre-decessor (SQLMail) in previous versions! Unlike other software application features when it goes wrong its hard to find the root cause, for instance if you see the following Read More...
Are you ready for SQL Server 2005 Service Pack 3?
Postponement of SQL Server 2008 release has become old news now and within the SQL Server community (especially MVPs) there has been a state of commotion in demanding Service Pack3 for SQL Server 2005 version, true its the time isn't it! Coming to SQL Read More...
SQL Server 2005 Best Practices Analyzer January 2008 update
Here is another new year gift from Microsoft for the SQL Server users, specifically for 2005 version - release of SQL Server 2005 Best Practices Analyzer (January 2008). BPA's job is to gather data from Windows and SQL Server configuration settings. There Read More...
More Posts Next page »