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

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)

Database diagram issues after SQL Server upgrade

Wed, 18 Feb 2009 07:50:00 GMT

Have you planned your databases upgrade from SQL Server 2000 version to 2005 or 2008? Have you tested the above upgrade plan? How many times you have been involved in the number of databases upgrade within your platform? Many questions to answer when...(read more)

My session at SQLBits IV - Upgrading To SQL Server 2005 & 2008: Notes & Best Practices

Mon, 09 Feb 2009 08:53:00 GMT

Thanks to the members/users who voted for my session in relate to the SQLBits IV conference submissions . Thanks very much for submitting a session for SQLBits IV, 28 th March 2009 in Manchester, I am very pleased to tell you that your session “ Upgrading...(read more)

Help Microsoft BI Development team to Build next version of AdventureWorks databases

Fri, 06 Feb 2009 13:12:00 GMT

Until SQL Server 2000 you may be familiar with pubs & northwind sample databases that were available along with SQL Server installation and since release of SQL 2005 the scenario has been changed for Sample databases.The version of AdventureWorks...(read more)

Business Intelligence - control what you want with your hands!

SqlServer-QA.net — Tue, 16 Dec 2008 15:48:00 GMT

How about you control what you want to see and get with your hands? A global view of information get a real-hands-on on business intelligence! Here is the newest invention from Microsoft about it, Business Intelligence Surface - View Video Format: flv...(read more)

UK Government Helps You - Beware its a SPAM*

SqlServer-QA.net — Wed, 26 Nov 2008 08:33:00 GMT

With reference to the subject line: [UK Government Helps You] as stated its a SPAM email that you might get in this Credit Crunch season that SPAMMERs are targeting the vulnerable users to obtain their personal details. Here I would like to present the...(read more)

SQL Server BI - Managing Large Datawarehouse environment, guidelines

SqlServer-QA.net — Wed, 17 Sep 2008 08:24:00 GMT

What will be the main challenge for a DBA/User to manage a large Data Warehouse (DW) environment, size does matter and also think about downtime you need to deploy whenever any patches are required. Before that you need to be perfect or well-versed with...(read more)

SQL Server Expert Seminars in June: SQL Server and Virtualisation

SSQA.net — Thu, 05 Jun 2008 09:47:00 GMT

Quest Software has lined up 2 events where you can learn more about consolidation and virtualisation for your SQL Server environment. SQL Server Technology Day Tuesday, 24 June 2008 9 a.m. - 5 p.m. (lunch included) Maidenhead, Berkshire Join Douglas Chrystall...(read more)

EXECUTE permission denied on object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.

SSQA.net — Tue, 27 May 2008 08:48:00 GMT

Granting permissions to relevant account is a required criteria within the SQL Server databases management, for this even Reporting Services is not exceptional. As per the configuration by default the users connect to the report server by using their...(read more)

SQL Server 2005 Database Mirroring choosing optimum value for auto-failover timeout?

SSQA.net — Mon, 12 May 2008 09:25:00 GMT

Choosing a better plan to reduce outage to your database application is a beginner to provide High Availability to your application, irrespective to database or server. You may be aware that SQL Server 2005 version provides the database mirroring which...(read more)

SQL Server - Have you observed DBCC SHRINKFILE operation performance, on huge databases?

SSQA.net — Fri, 25 Apr 2008 08:30:00 GMT

In general it is not a best practice to perform SHRINK database operation on a production server, atleast regularly! Sometimes it may be compulsory to keep them sized in order to ensure the disk storage is not compromised for any sudden changes to databases...(read more)

Why Backup, Why Recovery? You need a good strategy to save your data!

SSQA.net — Wed, 12 Mar 2008 08:02:00 GMT

The following context is the one I have received from SQL Server Magazine that talks about a good backup tool in the market, study on: Third-Party Tool Enhances SQL Server Backup and Recovery Microsoft SQL Server’s own backup and restore facilities are...(read more)

Windows Server 2008 deploy within your environment securely!

SSQA.net — Thu, 06 Mar 2008 08:50:00 GMT

Security - a major ingredient for every Enterprise to avoid the adversaries attempt to invade your customers’ networks and access their servers—to bring them down, infect them with viruses, or steal information about customers or employees, every day...(read more)

Warning: Autogrow of file 'DB File Name' in database 'DB Name' took milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file.

SSQA.net — Thu, 21 Feb 2008 12:22:00 GMT

The message on subject is self-explanatory where your disk subsystem is referring to SQL Server that it is unable to cope up the demand. Having AUTOGROW option enabled on a SQL Server database is a common setup that allows SQL Server automatically expands...(read more)

SQL Server 2005 BI evaluate and diagnose Analysis Services database performance

SSQA.net — Mon, 18 Feb 2008 09:57:00 GMT

Performance - one word does it all! You are aware that during the Performance Tuning exercise there are few quick wins within the SQL Server Relational Database Engine such as table statistics for data and indexes. When it comes to Analysis Services Read...(read more)

Another real world example - Why Do Many Software Vendors Provide Bad Software and Bad Support?

SSQA.net — Sun, 03 Feb 2008 12:29:00 GMT

Its a nightmare when you have got inefficient support person over phone or onsite for the problem you are facing with software or IT related problem. Here is RealWorld problem that how hard and furstating saga you can go with it!...( read more ) Read...(read more)

How to monitor transaction activity between the databases?

SSQA.net — Thu, 10 Jan 2008 10:23:00 GMT

Recently I have been through interesting forum post on SQL Server performance website that a user asking how to monitor transaction activity between the databases without using a third party tool. Until SQL 2000 version it is not that easy to get more...(read more)

SQL Server TSQL to find complete CONSTRAINT information on a table catalog?

SSQA.net — Wed, 09 Jan 2008 13:26:00 GMT

I have had a requirement to see a detailed information about a constraint on a table that includes table fields, type, rules, referenced table and fields for FOREIGN KEYs, etc. Found this useful TSQL to get such information: SELECT k.table_name, k.column_name...(read more)

TSQL to get default location of database data and log files?

SSQA.net — Tue, 08 Jan 2008 12:37:00 GMT

By default the SQL Server database data & log files are created on the default data directory which is Program Files or based on where SQL binary files are installed. In order to find what is the default location you can run following TSQL: declare...(read more)

SQL Server SP_HELPINDEX - updated version that includes column names

SSQA.net — Thu, 03 Jan 2008 19:46:00 GMT

Here is the incentive for the SQL Server users (this new year), you may be aware then using SP_HELPINDEX or SP_HELP could give some part of information on the indexes and database objects. But to know more about depedant columns you need to query INFORMATION_SCHEMA...(read more)