Browse Blog Posts by Tags

All Tags » Best Practices » technet (RSS)

MVP WordPress Blogs

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

SQL Server - Service Broker and Messaging, take care of MSDB sizes

You may notice that from SQL Server 2005 version onwards MSDB system database has got more importance than any other system database, I believe. It is a fact that if any problem ocurrs on the system databases such as MODEL or TEMPDB or MSDB the SQL Server...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Feb 2 2009
Filed under: Filed under: sql server, technet, dba, best practices, service broker, msdb, messaging, beginner, system databases, free space
MSDN & Technet webcast for SQL Server 2008 and SQL Server Compact 3.5 versions

TechNet Webcast: SQL Server 2008 (Part 3 of 3): Integrate Growing Data Volumes (Level 300) Attend this session to learn how to integrate growing volumes of data with the new enhancements in Microsoft SQL Server 2008. We cover new technologies, like Change...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Sep 3 2008
Filed under: Filed under: sql server, msdn, webcast, microsoft, technet, community, version, best practices, comact
Technical Rollup email pertaining to SQL Server, documents & guidelines

Here is the list of information which is a Technical Rollup email we receive from TRM team. The list is ongoing and I have outlined the important ones that I feel and fits for 'generic' SQL Server environment. Make sure to review, download, test...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Sep 3 2008
Filed under: Filed under: sql server, technet, documentation, best practices, technical
SQL Server Technical Rollup July 2008 - Important & Interested links for you

As you may be aware all the Technical information roll-up on MSDN & Technet is sent out in email format, in this regard I wanted to share the important and interested links for you on SQL Server arena. Downloads Source Code Analyzer for SQL Injection...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Jul 7 2008
Filed under: Filed under: sql server, msdn, technet, download, best practices, information, beginners in sql serever
SQL Server 2005 and Disk drive allocation unit size to 64K - any benefit or performance?

You may be aware that or seen within your Database platform about slower disk performance than expect having multiple disks in Windows Server 2003 environment when you use a hardware-based redundant array of independent disks (RAID) or a software-based...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Apr 28 2008
Filed under: Filed under: sql server, performance, microsoft, technet, i/o, article, disk, best practices, monitoring, deployment, layout
SQL Server Database Mirroring and Sharepoint server - gotchas and problem solutions

You may be aware that Database Mirroring is an important High Availability [HA] option available within SQL Server 2005 version. Having this HA option within your Sharepoint farm where the databases are associated to failover, then you must note few issues...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Mar 18 2008
Filed under: Filed under: sql server, high availability, technet, database, best practices, sharepoint, database mirroring, failover, links
Rename a SQL Server instance, a little catch

Can I rename an instance of SQL Server after I have already installed it on the computer? Simple answer is Yes and you can change the name of an instance as long as the server is not clustered. There is a little catch between 2000 and 2005 version, by...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Dec 14 2007
Filed under: Filed under: sql server, msdn, technet, instance, read, best practices, installation, servers, rename, local
MSDN labs - Developing a SQL Mobile Application with Visual Studio 2005 and SQL Server 2005

Sometime ago I have blogged about MSDN labs- SQL Server Virtual Labs - fully featured virtual environment for testing! and I recommend and encourage all of my users to use Virtual labs and webcasts - use them for a better practice on product . Similar...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Dec 11 2007
Filed under: Filed under: sql server, msdn, technet, replication, best practices, virtual labs, merge, compact edition, mobile, developement
How to find whether that service pack file is a 32 bit or 64 bit?

Whenever a service pack is released it will be available for 32-bit and 64-bit that also includes for SQL Express 2005 edition too, as it was for MSDE earlier. Since last year (I think) Microsoft Development team has adopted a standard in naming schema...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Nov 1 2007
Filed under: Filed under: sql server, msdn, microsoft, blogs, technet, download, kba, best practices, x64, testing, begin
Setting database compatibility to SQL 2000 on a SQL Server 2005 instance?

No doubt that as compare to previous version the current SQL Server 2005 provides more new language constructs and primitives for the T-SQL language than can be utilized. Still there are many out there not entirely ready to upgrade from SQL Server 2000...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Aug 30 2007
Filed under: Filed under: sql server, performance, databases, technet, benchmark, upgrade, version, best practices, compatibility

Page 1 of 1 (10 items)

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

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.