MSMVPS.COM

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

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

Windows Azure platform and SQL Server 2008 R2 feature complete CTP is available for download

November is an important month for Microsoft world! Two big events are scheduled to go - SQLPASS Summit 2009 and PDC 2009 conferences. Another exciting news is about CTP releases of SQL Server 2008 R2 & Windows Azure platform. SQL Server 2008 R2 news...

Published Wed, Nov 4 2009 10:07 by SqlServer-QA.net

Filed under: sql server, pass, release, event, ctp, conference, pdc, azure, windows azure
SQL Server 2008 features that work only in Enterprise Edition

One of the new features available in SQL Server 2008 is compressed backup which takes backup of a database with mimimum possible size. The syntax is backup database db_name to disk = 'backup_path' with init , compression But this works only in...

Published Tue, Nov 3 2009 7:18 by SqlServer-QA.net

Filed under: sql server, 2008, T-SQL, enterprise edition
SQL Server Manageability series - shortcut for SSMS keyboard shortcuts!

For any user manage the work with short-cut is desirable, for better productivity in your work (with UI tools) I always suggest to manage it by keyboard not with the mouse. Here is another block of SQL manageability series I want to cover based on feedback...

Published Fri, Oct 30 2009 3:08 by SqlServer-QA.net

Filed under: sql server, server, best practices, management studio, tips, query plan, nodes, query editor, shortcut, keyboard
I am a forum spammer! Delete my account immediately!!

The subject may look confusing that 1 part of it confirms its a forum spammer and another part to delete that account!!! Here is the email text that I have received highlighting valueable advice on security: *********** This email address was created...

Published Mon, Oct 26 2009 18:17 by SqlServer-QA.net

Filed under: security, team, password, spam, forum, email, foundation
SQL Server upgrade practices - choose optimal upgrade options

SQL Server Upgrade task needs a thorough planning and testing before you deploy the process in production environment. In this regard when performing an upgrade to a replicated environment, DBAs must make sure that all changes have been applied to all...

Published Mon, Oct 26 2009 7:18 by SqlServer-QA.net

Filed under: sql server, upgrade, replication, version, access, jet, oledb, merge, transactional replication
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...

Published Sat, Oct 24 2009 14:15 by SqlServer-QA.net

Filed under: sql server, databases, high availability, solution, machine, best practices, disaster recovery, clustering, reporting services
Finding out problamatic data in Bulk Insert data truncation error

Suppose you want to import data from a text file to a table, one of the options is to use Bulk Insert command It allows to import data to the table, though one/more columns don't have enough size to get the maximum length of data from text file.It...

Published Mon, Oct 19 2009 5:32 by SqlServer-QA.net

Filed under: sql server, bulk insert, T-SQL, data truncation
How SQL Server 2008 can help to build fast track data warehouse?

Beginning of this year I have posted here about Build your BI skills in fast track data warehouse and based on that I have had few questions and feedback on how best we can take help of SQL Server 2008 features to build the fast track data warehouse....

Published Fri, Oct 9 2009 2:26 by SqlServer-QA.net

Filed under: sql server, performance, memory, attributes, access, disk, cpu, data warehouse, fast track
How do I monitor problems with replication?

When you setup a program or application then you have equal responsibility to monitor the process/problems too. Similar to this monitoring a replication topology is an important aspect of deploying SQL Server replication. As the process is distributed...

Published Thu, Sep 24 2009 15:11 by SqlServer-QA.net

Filed under: sql server, monitor, alerts, replication monitor, manage, notifications
SQL Server - Types of replication in simple terms that relates to architecture

I tend to get emails that relates to SQL Server questions from the user, by default I suggest them to post on the forums to get quicker response and do reply in simple terms. One of the them I got recently asking about how can I explain the replication...

Published Sun, Sep 20 2009 10:54 by SqlServer-QA.net

Filed under: sql server, data, replication, version, publisher, model, compatibility, subscriptions, new feature, peer-to-peer
Problems you face when you do not check features not supported in SQL Server

Few developers on a client's place raised a question that why they should really be concerned about deprecated features or commands in SQL Server? Until SQL Server 2000 version it used to be a workaround to get the old scripts executed in a way. It...

Published Fri, Sep 18 2009 6:06 by SqlServer-QA.net

Filed under: sql server, tools, query, best practices, deprecated, feature, disabled, upgrade advisor
Developing Sharepoint Applications - Guidance for building collaborative applications that extend your LOB systems

Here is the know-how and concentration on a comprehensive platform for application development combined with extensible customer ready applications. This is the email communication from Microsoft that i would share here. It is helpful if the users are...

Published Tue, Sep 8 2009 6:59 by SqlServer-QA.net

Filed under: community, best practices, applications, configuration, components, SharePoint 2007, patterns & practices, moss
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

1 2 3 4 5 Next > ... Last »

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

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

Windows Azure platform and SQL Server 2008 R2 feature complete CTP is available for download

SQL Server 2008 features that work only in Enterprise Edition

SQL Server Manageability series - shortcut for SSMS keyboard shortcuts!

I am a forum spammer! Delete my account immediately!!

SQL Server upgrade practices - choose optimal upgrade options

Build an effiective Disaster Recovery solution for SQL Server Reporting Services

Finding out problamatic data in Bulk Insert data truncation error

How SQL Server 2008 can help to build fast track data warehouse?

How do I monitor problems with replication?

SQL Server - Types of replication in simple terms that relates to architecture

Problems you face when you do not check features not supported in SQL Server

Developing Sharepoint Applications - Guidance for building collaborative applications that extend your LOB systems

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!