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

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

2009-11-04T16:07:00Z

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 Read More......(read more)

SQL Server 2008 features that work only in Enterprise Edition

2009-11-03T13:18:00Z

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 Read More......(read more)

SQL Server Manageability series - shortcut for SSMS keyboard shortcuts!

2009-10-30T08:08:00Z

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 Read More......(read more)

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

2009-10-26T23:17:00Z

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 Read More......(read more)

SQL Server upgrade practices - choose optimal upgrade options

2009-10-26T12:18:00Z

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 Read More......(read more)

Build an effiective Disaster Recovery solution for SQL Server Reporting Services

2009-10-24T19:15:00Z

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......(read more)

Finding out problamatic data in Bulk Insert data truncation error

2009-10-19T10:32:00Z

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 Read More......(read more)

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

2009-10-09T07:26:00Z

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. Read More......(read more)

How do I monitor problems with replication?

2009-09-24T20:11:00Z

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 Read More......(read more)

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

2009-09-20T15:54:00Z

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 Read More......(read more)

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

2009-09-18T11:06:00Z

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 Read More......(read more)

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

2009-09-08T11:59:00Z

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 Read More......(read more)

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

2009-08-27T09:43:00Z

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 Read More......(read more)

1 Week Until Free ‘24 Hours of PASS’

2009-08-27T09:41:00Z

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 Read More......(read more)

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

2009-08-21T14:23:00Z

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 Read More......(read more)

How to Generate Script along with Data?

2009-08-21T12:49:00Z

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 Read More......(read more)

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

2009-08-21T11:47:00Z

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 Read More......(read more)

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

2009-08-20T14:21:00Z

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 Read More......(read more)

Microsoft Advisory Services Engagement Scenario - SQL Server Performance

2009-08-20T14:19:00Z

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 Read More......(read more)

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

2009-08-18T07:52:00Z

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 Read More......(read more)