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

SQL Server 2012 releases RTM and Evaluation edition, don't missing virtual event launch 07th March 2012

SQL Server 2012 released – out there still organization in process to upgrade to SQL Server 2008 version the next release of product is ready now! In Microsoft's words: The world’s most widely deployed data platform, Microsoft SQL Server 2012, has...

Published Wed, Mar 7 2012 4:42 by SqlServer-Qa.net

Filed under: sql server, version, documentation, beginners, new features, sql server 2012, virtual launch, #sql2012, #sqlfamily
How to keep a track of list of SQL Server versions and builds releases?

I believe until SQL Server 2000 (or even SQL 2005) it was easy to remember the release version of your SQL Server instance. Since the changes affected from SQL Server Release Services and inception of Cumulative Update packages it is hard to keep a track...

Published Tue, Jan 17 2012 5:01 by SqlServer-Qa.net

Filed under: sql server, dba, release, version, service pack, cumulative update, Database Maintenance, blogger
Master SQL Chef series: Troubleshooting multi-server instances with #sql2k8r2cookbook

Managing multiple instances of SQL Servers and databases is a challenging task, having a third party tool is not a problem however it is always BEST to manage the show using SQL Server Management Studio (SSMS). SQL Server tools are easy to use and help...

Published Mon, Jan 16 2012 4:45 by SqlServer-Qa.net

Filed under: sql server, management, ssms, dba, best practice, beginners, cookbook, ucp, #sql2k8r2cookbook, data tier, utility control point
SQL Server Opertional practices: Support ended for SQL Server 2005 Service Pack 3 and its time to upgrade too!

As of today the support for SQL Server 2005 Service Pack 3 ends, though the mainstream support for SQL Server 2005 was ended on 12th April 2011. This means only extended support is available for this version until 12th April 2016. Though there is a differnt...

Published Tue, Jan 10 2012 7:20 by SqlServer-Qa.net

Filed under: sql server, dba, upgrade, best practices, lifecycle, administrator, sp_configure, sp3, upgrade advisor, #sql2k8r2cookbook, support life cycle
Master SQL Chef series: Implementing Availability feature #sql2k8r2cookbook

When we talk about availability the key step in providing the feature is to ensure such feature is available and easily implemented. High Availability is purely dependant on hardware and software that will activate the failover or failback whenever the...

Published Mon, Jan 9 2012 3:51 by SqlServer-Qa.net

Filed under: sql server, performance, high availability, database mirroring, key, solution accelerator, cookbook, #sql2k8r2cookbook
Master SQL Chef series: Designing automated administration #sql #sql2k8r2cookbook

The administrative tasks such as managing backups, jobs, alerts and database maintenance activites are essential for every DBA. The tasks will be more complex and larger when the data platform is spread across the Enterprise, key task is to be able to...

Published Wed, Jan 4 2012 7:44 by SqlServer-Qa.net

Filed under: sql server, security, jobs, best practices, system, schedule, policy based framework, cookbook, automated administration, builtin
Master SQL chef series: Designing a best practice approach - Upgrading SQL Server data platform #sql #sql2k8r2cookbook

There is no doubt that SQL Server users have been keeping up their knowledge up to the level since last few years (at least since 2008 version release). In this regard the Upgrade of SQL Server data platform has taken utmost priority that can offer advantage...

Published Mon, Jan 2 2012 6:27 by SqlServer-Qa.net

Filed under: sql server, database, best practice, platform, updates, deprecated features, upgrade advisor, cookbook, discontinued featuers, #sql2k8r2cookbook
Cumulative Update package 11 for SQL Server 2008 R2 is available for download

The latest instalment of Cumulative Update package for SQL Server 2008 R2 is available for download, before implement it on production make sure you test the installation. Build 10.50.1809.0 (cumulative update) and the parent build of this build is 10...

Published Tue, Dec 20 2011 9:05 by SqlServer-Qa.net

Filed under: sql server, download, documentation, access, best practices, cumulative update, linked server, downgrade
Microsoft Assessment and Planning Toolkit 6.5 Now Available for Download

Microsoft Assessment and Planning (MAP) toolkit helps the migration of your IT environment, in specific I use this product whenever a database and instance upgrade projct is planned. The MAP 6.5 adds the cloud migration planning too, that confirms journey...

Published Thu, Dec 8 2011 5:14 by SqlServer-Qa.net

Filed under: sql server, best practices, enterprise, planning, toolkit, map, azure, accleration
SQL Server Performance series: Trace Flag 845 and Lock Pages in Memory

A discussion about trace flags 845 lead to explain the information about the requirement and necessity in case of 32 bit and 64 bit environments. The Lock Pages in Memory has gained importance since version 2005 due to the fact that 32-bit and 64-bit...

Published Fri, Nov 25 2011 3:05 by SqlServer-Qa.net

Filed under: sql server, security, version, best practices, configuration, cumulative update, benchmarking, performance monitoring, lock down, lock pages in memory
Cumulative Update #7 for SQL Server 2008 Service Pack 2 is available for download

The next instalment of Cumulative Update package for SQL Server 2008 Service Pack 2 is availabel for download, the build number for this CU7 will be 10.00.4323. Further the cumulative update package includes updates for all the component packages. However...

Published Tue, Nov 22 2011 4:08 by SqlServer-Qa.net

Filed under: sql server, catalogs, sp2, oledb, full-text, access violation, cumulative update, packages, downgrade, .dll, downloadl
Cumulative Update #2 for SQL Server 2008 Service Pack 3 available for download

Another instalment of Cumulative Update package for SQL Server 2008 SP3 is available now, which is CU2 and the build number is known as 10.00.5768.00. As usual this CU2 for SQL2008 SP3 contains hotfixes for issues that were fixed after the release of...

Published Tue, Nov 22 2011 4:02 by SqlServer-Qa.net

Filed under: sql server, backup, clr, best practices, stored procedure, access denied, access violation, cumulative update, downgrade, sp3, incremental service, cu2
Microsoft SQL Server 2012 RC0 available for download

Well here it is the next version of SQL Server is getting out step by step, few months ago CTP3 and now Release Candidation 0 is available for download. The version number will be 11.0.1750.32, make a note of it. Microsoft SQL Server 2012 RC0 enables...

Published Thu, Nov 17 2011 12:09 by SqlServer-Qa.net

Filed under: sql server, ssis, download, documentation, release candidate, rc0, cloud, index hint, relationship, master data management, sql server 2012
SQL Server Days 2011 – Last Chance to Register

. SQL Server Days 2011 – Last Chance to Register One more week before the SQL Server Days. The team at SQLUG.be together with our partners and speakers are ready to deliver another spectacular edition. We have over 250 people registered so far, so don't...

Published Tue, Nov 8 2011 4:15 by SqlServer-Qa.net

Filed under: sql server, mvp, dba, learning, conference, new features, sqlug, 2012
SQL Server 2012 editions licensing overview - changes, good and great

SQL Server 2012 is a big release compared to what we have seen from 2005 to 2008, though R2 has been an additional release with BI capabilities. Now SQL 2012 equipped with much more enhancements and new features to manage your data platform. In specific...

Published Thu, Nov 3 2011 12:23 by SqlServer-Qa.net

Filed under: sql server, processor, licensing, FAQ, new features, editions, software assurance, sql server 2012, cal
SQL Server performance series: PAGELATCH_ and PAGEIOLATCH_ wait types: relates to concurrency, take steps in diagnosing and resolving latch contention issues.

Contention is the word that you need to concentrate in resolving the performance issue, page latches contention is common in multi-CPU systems due to the nature of w hen multiple threads concurrently attempt to acquire incompatible latches to the same...

Published Tue, Oct 18 2011 1:26 by SqlServer-Qa.net

Filed under: sql server, perfmon, performance, memory, tuning, dba, cpu, performance monitoring, buffers, wait stats, dmvs, pageiolatch
Analysis Services database and OLAP systems: building and tuning for the best possible performance

When it comes to performance tuning there is no magic wand or short cut to wipe out the issue. The process is a constant learning and primary step is to ensure no issues are occuring repeatedly, which means you are not utilizing the time to reduce the...

Published Mon, Oct 17 2011 5:43 by SqlServer-Qa.net

Filed under: sql server, performance, analysis, best practices, monitoring, cube, benchmarking, performance tuning, performance guide, scalable
SQL Server 2008 Service Pack 3 - SP3 is released, test and upgrade relevant instances

Well, its time now again for all DBAs and System Administrators out there to do some real-world testing on their SQL Server 2008 instance platform, service pack 3 for SQL Server 2008 is released now. If you are already testing the CTP version then its...

Published Wed, Oct 12 2011 16:40 by SqlServer-Qa.net

Filed under: sql server, dba, download, documentation, best practices, ctp, installation, service pack3
SSIS restart issues, message: application-specific permission settings do not grant Local Launch permission for the COM Server application with CLSID

SQL Server Integration Services (SSIS) is an important service that is required to continue the ETL (extract transform load) tasks on your data platform. You may notice that since SQL Server 2005 version onwards the database maintenance plans will always...

Published Tue, Oct 11 2011 7:03 by SqlServer-Qa.net

Filed under: sql server, ssis, security, best practices, error log, integration services, benchmarking, component services
Perform SQL Server Upgrade with the help of tools, best practices too #sqlbpa #upgrade

SQL Server upgrade is no small task, no big task either when you have perfectly planned and tested the process! Since last 2 years the most popular topic and talk that I presented in various conferences, usergroup meetings and consulting projects is upgrade...

Published Fri, Oct 7 2011 2:24 by SqlServer-Qa.net

Filed under: sql server, tools, database, dba, download, best practices, beginners, upgrade advisor, best practice analyzer, upgrade assistant

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

SQL Server 2012 releases RTM and Evaluation edition, don't missing virtual event launch 07th March 2012

How to keep a track of list of SQL Server versions and builds releases?

Master SQL Chef series: Troubleshooting multi-server instances with #sql2k8r2cookbook

SQL Server Opertional practices: Support ended for SQL Server 2005 Service Pack 3 and its time to upgrade too!

Master SQL Chef series: Implementing Availability feature #sql2k8r2cookbook

Master SQL Chef series: Designing automated administration #sql #sql2k8r2cookbook

Master SQL chef series: Designing a best practice approach - Upgrading SQL Server data platform #sql #sql2k8r2cookbook

Cumulative Update package 11 for SQL Server 2008 R2 is available for download

Microsoft Assessment and Planning Toolkit 6.5 Now Available for Download

SQL Server Performance series: Trace Flag 845 and Lock Pages in Memory

Cumulative Update #7 for SQL Server 2008 Service Pack 2 is available for download

Cumulative Update #2 for SQL Server 2008 Service Pack 3 available for download

Microsoft SQL Server 2012 RC0 available for download

SQL Server Days 2011 – Last Chance to Register

SQL Server 2012 editions licensing overview - changes, good and great

SQL Server performance series: PAGELATCH_ and PAGEIOLATCH_ wait types: relates to concurrency, take steps in diagnosing and resolving latch contention issues.

Analysis Services database and OLAP systems: building and tuning for the best possible performance

SQL Server 2008 Service Pack 3 - SP3 is released, test and upgrade relevant instances

SSIS restart issues, message: application-specific permission settings do not grant Local Launch permission for the COM Server application with CLSID

Perform SQL Server Upgrade with the help of tools, best practices too #sqlbpa #upgrade