Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

Build an effiective Disaster Recovery solution for SQL Server Reporting Services

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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sat, Oct 24 2009
Filed under: Filed under: sql server, databases, high availability, solution, machine, best practices, disaster recovery, clustering, reporting services
Database diagram issues after SQL Server upgrade

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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Feb 18 2009
Filed under: Filed under: sql server, databases, dba, upgrade, best practices, tsql, administrator, diagram, FAQ
My session at SQLBits IV - Upgrading To SQL Server 2005 & 2008: Notes & Best Practices

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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Feb 9 2009
Filed under: Filed under: sql server, databases, dba, upgrade, best practices, sqlbits, conference, speakers, business intelligence
Help Microsoft BI Development team to Build next version of AdventureWorks databases

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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Feb 6 2009
Filed under: Filed under: sql server, databases, download, features, best practices, feedback, samples, northwind, msft, pubs, adventureworks
UK Government Helps You - Beware its a SPAM*

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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Nov 26 2008
Filed under: Filed under: sql server, databases, best practices, beginners, spam, phishing, email, uk, government
SQL Server BI - Managing Large Datawarehouse environment, guidelines

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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Sep 17 2008
Filed under: Filed under: sql server, performance, management, databases, reporting, business intelligence, data warehouse, readonly
SQL Server Expert Seminars in June: SQL Server and Virtualisation

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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Jun 5 2008
Filed under: Filed under: sql server, databases, seminar, consolidation, quest, events, sqlpass, virtualisation
EXECUTE permission denied on object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.

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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, May 27 2008
Filed under: Filed under: sql server, databases, security, permissions, sqlagent, reporting services, reportserver, reportservertempdb, rsexecrole
SQL Server 2005 Database Mirroring choosing optimum value for auto-failover timeout?

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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, May 12 2008
Filed under: Filed under: sql server, databases, best practices, database mirroring, 2005, principal, witness, mirror, timeout
SQL Server - Have you observed DBCC SHRINKFILE operation performance, on huge databases?

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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Apr 25 2008
Filed under: Filed under: sql server, indexes, memory, databases, cache, cpu, monitoring, operating system, huge, dbcc shrinkfile
Why Backup, Why Recovery? You need a good strategy to save your data!

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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Mar 12 2008
Filed under: Filed under: sql server, databases, backup, red-gate, recovery, toolkit, third party, strategy
Windows Server 2008 deploy within your environment securely!

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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Mar 6 2008
Filed under: Filed under: sql server, databases, microsoft, security, server, windows, 2008, environment
Warning: Autogrow of file 'DB File Name' in database 'DB Name' took <number> milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file.

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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Feb 21 2008
Filed under: Filed under: sql server, performance, databases, dba, disk space, error log, monitoring, configuration, alter database, auto grow
SQL Server 2005 BI evaluate and diagnose Analysis Services database performance

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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Feb 18 2008
Filed under: Filed under: sql server, profiler, performance, databases, security, process, sysmon, administrator, Analysis Services, diagnose
Another real world example - Why Do Many Software Vendors Provide Bad Software and Bad Support?

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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sun, Feb 3 2008
Filed under: Filed under: sql server, databases, blog, support, samples
How to monitor transaction activity between the databases?

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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Jan 10 2008
Filed under: Filed under: sql server, databases, dmv, i/o, tsql, statistics, activity
SQL Server TSQL to find complete CONSTRAINT information on a table catalog?

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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Jan 9 2008
Filed under: Filed under: sql server, databases, dba, function, requirement, tsql, tablename, constraint, values
TSQL to get default location of database data and log files?

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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Jan 8 2008
Filed under: Filed under: sql server, databases, location, tsql, data file, log file, default, program files
SQL Server SP_HELPINDEX - updated version that includes column names

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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Jan 3 2008
Filed under: Filed under: sql server, indexes, databases, sql queen, script, columns, kalen delaney, sp_help, included, sp_helpindex
How to be an Exceptional DBA - free ebook.

A new year gift to the SQL Server users!! As the title states every DBA wants to be exceptional within their environment . Within your demanding role there are more things that needs importance in continuing the fire-fighting techniques to keep up the...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Jan 2 2008
Filed under: Filed under: sql server, databases, red-gate, dba, download, ssp, sql-server-performance, ebook, beginners in sql serever

Page 1 of 3 (57 items) 1 2 3 Next >

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.

Recent Posts

Tags

Browse Blog Posts by Tags