SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) : sql server

Webcasts related to SQLAzure and SQL Server 2008 R2 edition

Sat, 05 Dec 2009 15:41:00 GMT

List of upcoming MSDN webcasts on SQL Server 2008 R2 (StreamInsight) and SQLAzure platform.: MSDN Webcast: Overview of SQL Server StreamInsight (Level 200) Wednesday, December 02, 2009 1:00 PM Pacific Time (US & Canada) In this webcast, we explore...(read more)

SQL Server R2 and Azure related Technical rollup

Sat, 05 Dec 2009 15:38:00 GMT

Here are the few important links that you might be interested to get to know about SQL Server 2008 R2 (CTP) and SQLAzure platform. Sync Framework Power Pack for SQL Azure This release features the SQL Azure provider for Microsoft Sync Framework, a plug...(read more)

How fast you can obtain information about missing indexes? Its easy and quick!

Mon, 23 Nov 2009 00:26:00 GMT

On the subject line the process to find the answer is not a short one! By design SQL Server engine takes care when the query optimizer generates a query plan, it analyzes what are the best indexes for a particular filter condition. If the best indexes...(read more)

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

Wed, 04 Nov 2009 16:07:00 GMT

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)

SQL Server 2008 features that work only in Enterprise Edition

Tue, 03 Nov 2009 13:18:00 GMT

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)

SQL Server Manageability series - shortcut for SSMS keyboard shortcuts!

Fri, 30 Oct 2009 08:08:00 GMT

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)

SQL Server upgrade practices - choose optimal upgrade options

Mon, 26 Oct 2009 12:18:00 GMT

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)

Build an effiective Disaster Recovery solution for SQL Server Reporting Services

Sat, 24 Oct 2009 19:15:00 GMT

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)

Finding out problamatic data in Bulk Insert data truncation error

Mon, 19 Oct 2009 10:32:00 GMT

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)

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

Fri, 09 Oct 2009 07:26:00 GMT

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)

How do I monitor problems with replication?

Thu, 24 Sep 2009 20:11:00 GMT

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)

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

Sun, 20 Sep 2009 15:54:00 GMT

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)

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

Fri, 18 Sep 2009 11:06:00 GMT

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)

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

Thu, 27 Aug 2009 09:43:00 GMT

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)

1 Week Until Free ‘24 Hours of PASS’

Thu, 27 Aug 2009 09:41:00 GMT

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)

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

Fri, 21 Aug 2009 14:23:00 GMT

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)

How to Generate Script along with Data?

Fri, 21 Aug 2009 12:49:00 GMT

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)

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

Fri, 21 Aug 2009 11:47:00 GMT

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)

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

Thu, 20 Aug 2009 14:21:00 GMT

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)

Microsoft Advisory Services Engagement Scenario - SQL Server Performance

Thu, 20 Aug 2009 14:19:00 GMT

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)