MSMVPS.COM

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

Browse by Tags

Blogs

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

Syndication

News

Blog Archive List

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
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
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
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
SQL Server Peer-to-Peer replicaton - how to achieve scalability and availability

Replication will be very handy to distribute the load of application when you have large scale of data management, as it evolved from SQL Server 6.0 version the transactional replication is first baby that was primarily used to support reporting applications...

Published Tue, Jul 28 2009 2:39 by SqlServer-QA.net

Filed under: sql server, availability, replication, BOL, best practices, scalability, tablediff, replication monitor, peer-to-peer
SQL Server TEMPDB - A key factor in monitoring and keeping up the performance! (update)

You may think on the subject line why TEMPDB is a key factor, a simple term is the size and physical placement of the tempdb database can affect the performance of a system. Even a simple query requires the access/process to TEMPDB, which is a part of...

Published Tue, Jul 28 2009 2:05 by SqlServer-QA.net

Filed under: sql server, best practices, multiple, table, storage, tempdb, create, files, performance monitoring
SQL Server error: Msg 6101, Level 16, State 1, Line 1 Process ID -2 is not a valid process ID. Choose a number between 1 and 2048 - update

Here is the quirky error that has caused a resources crunch on a SQL instance, Error : Process ID -2 is not a valid process ID . The actual issue occurred during an update to a table that has been used by Online application to update the action log, intially...

Published Mon, Jul 27 2009 2:07 by SqlServer-QA.net

Filed under: sql server, dmv, error, best practices, spid, connections, code, msdtc, kill, rollback, orphan, distributed transactions
SQL Server performance problem, how bad it is or rather I ask how good are you to find the root cause?

I always trust how good your resources are to find out a root cause than how bad the problem is? It is one of the best point of disaster recovery position I wanted to be to get to work on solution on quicker basis than worrying about the impact, the business...

Published Mon, Jul 27 2009 1:53 by SqlServer-QA.net

Filed under: sql server, perfmon, performance, ssms, tools, best practices, encryption, locks, baseline, benchmarking, performance monitoring
Microsoft Security Bulletin Summary for May 2009 - Critical Security Bulletins

This bulletin summary lists security bulletins released for May 2009. The full version of the Microsoft Security Bulletin Summary for May 2009 can be found at http://www.microsoft.com/technet/security/bulletin/ms09-may.mspx . With the release of the bulletins...

Published Tue, Jun 2 2009 6:52 by SqlServer-QA.net

Filed under: microsoft, security, best practices, notification, technical, networking, monthly, webcasts, rollup
Do you know how many Monitoring Tools and Resources available in SQL Server?

Monitoring Tools and Resources are essential for performance tuning & better manageability in SQL Server. Many times the users think that collection and analysis of performance data is not a day-to-day job, also I feel that it is difficult at best...

Published Mon, Jun 1 2009 2:25 by SqlServer-QA.net

Filed under: sql server, performance, ssms, tools, best practices, bids, monitoring, resources, readtrace, profiller
Proactive caching for Analysis Services databases - performance techniques and better usage

By default SQL Server has a pool of memory that is used to store both execution plans and data buffers. This pool of memory is managed by default within Analysis Services for SQL Server and such percentage of the pool allocated to either execution plans...

Published Sun, May 31 2009 9:32 by SqlServer-QA.net

Filed under: sql server, performance, data, cache, best practices, cube, Analysis Services, rolap, molap, proactive, advantage
SQL Server Error Msg:911 Could not locate entry in sysdatabases for database 'mssqlsystemresource'.

The error on the subject line is not a good sign when you have the mammoth task of moving SQL Server system databases, I would agree that the task of system databases migration is not a day-to-day task and you must have practised the required steps. For...

Published Sat, May 23 2009 3:42 by SqlServer-QA.net

Filed under: sql server, restore, tech-ed, mvp, error, BOL, best practices, backups, corrupted, system databases, resource databases
SQL Server Edition - which is the best one to choose for your database needs?

When I look at the question, I feel that no direct answer to it! The reason being SQL Server has outgrown into an important enterprise RDBMS product from a simple desktop based database application, but still maintains the ease of installation and use...

Published Sun, May 17 2009 12:54 by SqlServer-QA.net

Filed under: sql server, performance, standard, best practices, edition, enterprise, statistics, monitoring, e-learning
SQL Server Performance patterns of a UDF with datetime parameters

There was an interesting discussion about User Defined Fuctions (UDF) performance and patterns, the actual phenomenon is that UDF has got parameters to pass on during the execution. Just to talk about introduction of such options in the SQL Server history...

Published Mon, May 11 2009 2:10 by SqlServer-QA.net

Filed under: sql server, performance, best practices, function, table-valued, testing, udf, user-defined
Troubleshooting blocking in SQL Server 2005 and 2008 - new tool

How do you monitor and catch the blocked process within your SQL environment? Using Query Editor in SQL Server Management Studio to find the blocked processes is a common approach and further to that you can use the advanced configuration (SP_CONFIGURE...

Published Fri, May 1 2009 2:47 by SqlServer-QA.net

Filed under: sql server, mvp, community, version, best practices, code-plex, blocked processes
Pattern and Practices - deprecate and discontinued Transact SQL features

Deprecate and Discontinued features, are not a words for Developers and DBAs which is a first point of option that they must be concentrated. What they mean is the defined features include a complete/partial change in supported compatibility levels, for...

Published Thu, Apr 23 2009 2:10 by SqlServer-QA.net

Filed under: sql server, version, features, best practices, deprecated, tsql, dependancies, discontinued
A big question in SQL Server - create a table with more than 1024 columns?

IT was an interesting question to ask/know about create a table with more than 1024 columns? If you try to do so then obvious error: CREATE TABLE failed because column '<ColName>' in table 'MaxSparseColumnTest' exceeds the maximum...

Published Mon, Apr 6 2009 2:46 by SqlServer-QA.net

Filed under: sql server, blog, best practices, tsql, 1024, sparse columns, limit, db engine, create table
Get a mixture of Technical content from MIX09 sessions

MIX & PDC, 2 popular and catchy conferences for Developers in IT world! I favour MIX conference more than PDC as you get to know in-depth knowledge & features about cloud computing, .NET services and other major exciting developing technologies...

Published Tue, Mar 24 2009 12:55 by SqlServer-QA.net

Filed under: sql server, microsoft, developer, best practices, conference, mix, pdc, sql server 2005

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

Browse by Tags

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 Manageability series - shortcut for SSMS keyboard shortcuts!

Build an effiective Disaster Recovery solution for SQL Server Reporting Services

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

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

SQL Server Peer-to-Peer replicaton - how to achieve scalability and availability

SQL Server TEMPDB - A key factor in monitoring and keeping up the performance! (update)

SQL Server error: Msg 6101, Level 16, State 1, Line 1 Process ID -2 is not a valid process ID. Choose a number between 1 and 2048 - update

SQL Server performance problem, how bad it is or rather I ask how good are you to find the root cause?

Microsoft Security Bulletin Summary for May 2009 - Critical Security Bulletins

Do you know how many Monitoring Tools and Resources available in SQL Server?

Proactive caching for Analysis Services databases - performance techniques and better usage

SQL Server Error Msg:911 Could not locate entry in sysdatabases for database 'mssqlsystemresource'.

SQL Server Edition - which is the best one to choose for your database needs?

SQL Server Performance patterns of a UDF with datetime parameters

Troubleshooting blocking in SQL Server 2005 and 2008 - new tool

Pattern and Practices - deprecate and discontinued Transact SQL features

A big question in SQL Server - create a table with more than 1024 columns?

Get a mixture of Technical content from MIX09 sessions