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 is an advantage to avoid the costs and pre-requisite...
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 to used separate databases for various...
Wow, its almost one year for me to talk about SQL Server Open World! Last year I have given 2 presentations on Effective usage of Database Mirroring & Business Continuity mesaures & practices, blog posts here for a reference: http://sqlserver-qa.net/blogs/etc/archive/2007/03/17/sql-server-open...
Nuestro compañero Ron Talmage ha co-escrito el siguiente artículo que fue liberado la semana pasada: "Database Snapshot Performance Considerations under I/O-Intensive Workloads" http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/DBSnapshotPerf.docx Disfruta de...
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 are pre-defined list of SQL Server 2005 recommendations...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
01-25-2008
Filed under: sql server, microsoft, download, best practices, 2008, ctp, analyzer, 2005, Analysis Services, extent, rtm
You all know that it is a best practice to use the schema qualified tables or views for the better management and performance (sometimes). As the Best Practices Analyzer tool which will be a part of SQL engine from 2008 version onwards confirms that this rule doesn’t check schema qualification on temporary...
We have most of our database systems on 64-bit environment, but one of the application user asked the question what is the advantage of a 64-bit environment in relation to SQL Server application. I would say with the evolution of SQL Server 2005 it has opened many more differentiation between 32- and...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
12-19-2007
Filed under: sql server, package, management, microsoft, server, windows, best practices, 2008, consolidation, planning, x64, 2005, advantages, policies
I know it sounds easy to upgrade a SQL Server Cluster environment from 2000 to 2005 version, as easy it mentioned within the Books Online for SQL Server 2005. When I have performed for the first time, my first thought was (do we need that or take out the reasons). But one thing is sure that SQL Server...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
11-16-2007
Filed under: sql server, restore, high availability, backup, security, upgrade, best practices, cluster, 2000, 2005, detach, attach, data files, logins
If you are managing hundreds of SQL Server and you might have organised your Management Studio screen with relevant server groups under Server registration. In this case if a new starter has joined and required to assist you in monitoring all of the SQL Server you are taking care, you wouldn't attempt...
Ron Talmage ha estado trabajando en el SQL Server Customer Lab, buscando las cosquillas a Full-Text, y aquí puedes leer un resultado de las conclusiones obtenidas: http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/ftslesld.mspx ay Ron, que envidia!! J