MSMVPS.COM

The Ultimate Destination for Blogs by Current and Former Microsoft Most Valuable Professionals.

August 2009 - SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)

Blogs

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

Syndication

News

Blog Archive List

Sort by: Most Recent | Most Viewed | Most Commented

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

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

Published Thu, Aug 27 2009 4:43 by SqlServer-QA.net

Filed under: sql server, tools, upgrade, version, best practices, media, uninstall, upgrade advisor, in-place, side-by-side
1 Week Until Free ‘24 Hours of PASS’

Here is the SQLPASS email circulation note: The countdown is on to Sept. 2’s 24 Hours of PASS , the most value-packed 24 hours of SQL Server and Business Intelligence training available—absolutely FREE! Register today for your favorite of 24 back-to-back...

Published Thu, Aug 27 2009 4:41 by SqlServer-QA.net

Filed under: sql server, webcast, free, conference, sqlpass, registration
FIX: You receive error messages or data is damaged after you run an SSIS package that contains a data flow task in a low memory situation in SQL Server 2005 or in SQL Server 2008

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Standard Notification Contents: New and Major Modifications FIX: You receive error messages or data is damaged after you run an SSIS package that contains...

Published Fri, Aug 21 2009 9:23 by SqlServer-QA.net

Filed under: sql server, package, ssis, error, kba, agent, data flow, fix, low memory
How to Generate Script along with Data?

One of the new features available in SQL Server 2008 is scripting the tables along with data (in the form of INSERT statements). Here are the useful links that can help you generating script with data SQL Server 2008 http://www.kodyaz.com/articles/sql...

Published Fri, Aug 21 2009 7:49 by SqlServer-QA.net

Filed under: sql server, script, T-SQL
SQL Server database design goals: Memory, Disk and I/O - maximize the scalability with monitoring

Do you consider the I/O whenever a database design project is assigned? It is one of the primary design goals of all database software is to minimize disk I/O because disk reads and writes are among the most resource-intensive operations. Over the time...

Published Fri, Aug 21 2009 6:47 by SqlServer-QA.net

Filed under: sql server, performance, memory, tools, i/o, disk, statistics, monitoring, capacity, input
SQL Server 2005 and SQL Server 2008 reports 701 errors with large batch sizes

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Standard Edition and SQL Server 2008 Enterprise Edition Notification Contents: New and Major Modifications SQL Server 2005 and SQL Server 2008 reports...

Published Thu, Aug 20 2009 9:21 by SqlServer-QA.net

Filed under: sql server, performance, error, 2008, 2005, reports, 701, batch size
Microsoft Advisory Services Engagement Scenario - SQL Server Performance

Attaining SQL Server performance is not a black magic, you need to asses and implement the scenarios effectively. The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Enterprise Edition & SQL Server...

Published Thu, Aug 20 2009 9:19 by SqlServer-QA.net

Filed under: sql server, performance, kba, maintenance, best practice, advice
Removal of SQL DMO in future release of SQL Server - take action now!

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

Published Tue, Aug 18 2009 2:52 by SqlServer-QA.net

Filed under: sql server, msdn, replication, features, best practices, smo, dmo, backward compatibility
Happy first anniversary for SQL Server 2008 RTM

It is over 1 year and first anniversary for SQL Server 2008 RTM, last year the RTM is released on August 06th 2008 re. http://sqlserver-qa.net/blogs/sql2008/archive/2008/08/06/4727.aspx post. HAPPY first anniversary.... and kudos to SQL Server Development...

Published Mon, Aug 17 2009 8:47 by SqlServer-QA.net

Filed under: sql server, microsoft, 2008, feature, developement, rtm
SQL Server 2008 R2 CTP - refer to documentation to know what's new!

In response to the SQL Server 2008 R2 CTP post I have had flurry of emails asking what more they can learn on 'What's New' compared to the existing SQL Server 2008 RTM which has celebrated its first birtday! As a general recommendation I always...

Published Mon, Aug 17 2009 8:32 by SqlServer-QA.net

Filed under: sql server, download, BOL, documentation, virtual, ctp, environment, best practice, r2, 2008 version
SQL Server Standard Edition: List of Knowledge Base Articles (KBA) that are updated

You have seen the list of SQL Server 2008 Enterprise Edition: List of Microsoft Knowledge Base Articles (KBA) updated and now there are few additional KBAs that pertains to SQL Server Standard Edition has been updated recently with new and major modifications...

Published Mon, Aug 17 2009 1:20 by SqlServer-QA.net

Filed under: sql server, transaction log, update, kba, index, maintenance, smo, clustering, tempdb, service pack, backups, collation, knowledgebase, fulltext, device, cumulative update, clustered index, maxdop
Tools to enhance SQL Server security, analyze that!

There are various methods you could apply to secure SQL Server platform, that includes the areas of physical hardware and networking systems connecting clients to the database servers, and the binary files that are used to process database requests! It...

Published Fri, Aug 14 2009 6:15 by SqlServer-QA.net

Filed under: sql server, security, tools, audit, feature, lock down, verison, vulnerability, sql injection
Cumulative update package 3 for SQL Server 2008 Service Pack 1

It seems I'm missing to monitor the release of Cumulative Updates for SQL Server 2008 version, in the series of last one Cumulative Update Package 2 for SQL Server 2008 SP1 we have Cumulative Update package 3 in the list for testing. KBA971491 talks...

Published Fri, Aug 14 2009 5:57 by SqlServer-QA.net

Filed under: sql server, package, deploy, installation, best practice, cumulative update, problems
SQL Server 2008 installation issues: Access is denied

In general the installation of SQL Server is straight forward and should not be a problem unless the server is not under hardware/software configuration link here. As SQL Server 2008 version is designed secured by default and part of security measures...

Published Fri, Aug 14 2009 2:24 by SqlServer-QA.net

Filed under: sql server, security, upgrade, cluster, installation, privileges, service account, setup, operating system
Changes to SQL Server 2005 and 2008 clustering support policy on Hyper-V or SVVP

Microsoft's technical support policy for SQL Server 2005 and 2008 version has been changed when it comes to the environments that are using hardware virtualization, such as using Windows Server 2008 with HyperV or Microsoft's Hyper-V Server 2008...

Published Tue, Aug 4 2009 6:27 by SqlServer-QA.net

Filed under: sql server, windows, virtual, support, technical, policies, css, Hyper-V
Regular expression

One of the posters asked a question in the forums about finding a number in an expression consists of alphabets and number if a particular digit is provided Consider the following set of data this is test place located at no 123456 test foo 35234 bar...

Published Mon, Aug 3 2009 6:06 by SqlServer-QA.net

Filed under: sql server, T-SQL, regular expression
TSQL to find the name of unique index that refers full text index

Here is the useful script that I have workd out (part of it obtained from Technet) in order to find the name of unique index that refers full text index SELECT OBJECT_NAME ( fti . object_id ) AS 'Table Name' , i . name AS 'Index Name'...

Published Mon, Aug 3 2009 1:45 by SqlServer-QA.net

Filed under: sql server, index, table, full-text, tsql, object_name

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

zines:andrewbelon.com

August 2009 - SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)

Blogs

Syndication

Recent Posts

Tags

News

Archives

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

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

1 Week Until Free ‘24 Hours of PASS’

FIX: You receive error messages or data is damaged after you run an SSIS package that contains a data flow task in a low memory situation in SQL Server 2005 or in SQL Server 2008

How to Generate Script along with Data?

SQL Server database design goals: Memory, Disk and I/O - maximize the scalability with monitoring

SQL Server 2005 and SQL Server 2008 reports 701 errors with large batch sizes

Microsoft Advisory Services Engagement Scenario - SQL Server Performance

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

Happy first anniversary for SQL Server 2008 RTM

SQL Server 2008 R2 CTP - refer to documentation to know what's new!

SQL Server Standard Edition: List of Knowledge Base Articles (KBA) that are updated

Tools to enhance SQL Server security, analyze that!

Cumulative update package 3 for SQL Server 2008 Service Pack 1

SQL Server 2008 installation issues: Access is denied

Changes to SQL Server 2005 and 2008 clustering support policy on Hyper-V or SVVP

Regular expression

TSQL to find the name of unique index that refers full text index