Browse Blog Posts by Tags

All Tags » Best Practices » sql server (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 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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Jan 10 2012
Filed under: Filed under: sql server, dba, upgrade, best practices, lifecycle, administrator, sp_configure, sp3, upgrade advisor, #sql2k8r2cookbook, support life cycle
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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Jan 4 2012
Filed under: Filed under: sql server, security, jobs, best practices, system, schedule, policy based framework, cookbook, automated administration, builtin
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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Dec 20 2011
Filed under: 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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Dec 8 2011
Filed under: 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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Nov 25 2011
Filed under: Filed under: sql server, security, version, best practices, configuration, cumulative update, benchmarking, performance monitoring, lock down, lock pages in memory
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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Nov 22 2011
Filed under: Filed under: sql server, backup, clr, best practices, stored procedure, access denied, access violation, cumulative update, downgrade, sp3, incremental service, cu2
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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Oct 17 2011
Filed under: 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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Oct 12 2011
Filed under: 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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Oct 11 2011
Filed under: 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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Oct 7 2011
Filed under: Filed under: sql server, tools, database, dba, download, best practices, beginners, upgrade advisor, best practice analyzer, upgrade assistant
Deal of The Day! Get 50% on MVP Deep Dives volume II book - SQL Server

As the SQLPASS summit 2011 is getting near the release of MVP Deep Dives Volume II too, SQL Server MVP Deep Dives, Volume 2 We are happy to announce the launch of SQL Server MVP Deep Dives Volume Two, a unique collection of techniques, tips, and best...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Oct 4 2011
Filed under: Filed under: sql server, mvp, best practices, publisher, books, beginners in sql serever, deep dives, discount
Book Review: Microsoft SQL Server 2008 R2 Master Data Services from Packt Publishers

This is my first book review in this year, though it is a good experience in writing my first book on SQL Server technologies and here it goes: Book Title: Microsoft SQL Server 2008 R2 Master Data Services Publishers: Packt Publishers Master Data Services...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sun, Oct 2 2011
Filed under: Filed under: sql server, dba, best practices, books, beginners in sql serever, mds, master data services, packt, review
Improve the community with your knowledge and experience, lets join the wagon - T-SQL Tuesday #22 – Data Presentation

Ok, the holiday season is over and we can see the community is back in the track, no doubt that big conferences are lined-up across the globe. However the SQL Server community has become a global village with the help fo Twitter & blogging. I'm...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Sep 7 2011
Filed under: Filed under: sql server, mvp, dba, community, best practices, benefits, devloper, TSQL2sDay, tweet, hashtag, tsql-tuesdays
Take the offer on SQL Server 2008 R2 Administration cookbook and SQL Server 2008 R2 Master Data Services

In continuation to the Packt Publishers September offer on Microsoft books I would like to promote two essential books to upgrade your knowledge in Microsoft SQL Server 2008 R2 technologies. Microsoft SQL Server 2008 R2 Administration Cookbook Over 70...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Sep 7 2011
Filed under: Filed under: sql server, performance, dba, best practices, disaster recovery, publisher, books, performance monitoring, ebook, beginners in sql serever, offer, master data services, packt
SQL Server Operational tactics: get to know about deprecated and discontinued features,

When we talk about new versions of a product, the information about what's new is highlighted in the product documentation and now with latest trend flurry of blogs are flooding around. Within my LinkedIn updates I was amused by Robert Pearl's...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Aug 22 2011
Filed under: Filed under: sql server, tools, best practices, feature, full-text, beginners, backward compatibility, deprecated features, denali, fts, discontinued featuers, sql11
Cast your vote for best SQL Server product in SQL Server Magazine Community choice awards - SQLCentric

Our flagship product SQLCentric is up again for Best Database Performance and Monitoring product in the 2011 SQL Server Magazine's Community Choice Awards. Here is the time again to cast your choice of product to be selected as best database performance...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Aug 17 2011
Filed under: Filed under: sql server, community, best practices, monitoring, vote, sql server magazine, choice
Scottish Area SQL Server User Group: Reporting Services and Sharepoint Integration and BI features in Denali #sql #usergroup #sqlfaq

Here is another usergroup event scheduled for Scottish Area SQL Server usergroup, this time its all high-up and concentration on BI specific. The topics are: Reporting Services and SharePoint Integration & BI features in Denali The SSRS & Sharepoint...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Aug 11 2011
Filed under: Filed under: sql server, bi, mvp, ssrs, best practices, sharepoint, usergroup, sassug, sql server reporting services
SQLBits 9 - Query across the Mersey, Backup North! - High Availability and Disaster Recovery for the Novice DBA

I believe by this time most of you might have registered/noted your diaries with the dates about upcoming SQLBits 9 conference. If you haven't registered yet then, hurry-up - Registration is Now Open , like the previous events this is also a 3 day...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Aug 11 2011
Filed under: Filed under: sql server, high availability, dba, best practices, sqlbits, conference, usergroup, benefits, HA
SQL Server Manageability series: Log files and Setup Bootstrap folder, the key elements to manage the data platform

There a different types of log files available when you start to install the SQL Server and manage the instance. Whenever you talk about log file then immediate option is SQL Server error log file, which can be viewed from SQL Server Management Studio...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Aug 11 2011
Filed under: Filed under: sql server, management, dba, best practices, beginners, configuration, setup, practices, bootstrap
SQL Server Managebility Series: Management Studio download with SQL 2008 R2 SP1 and few notes? #sql #tools

In continuation to the SQL2K8R2 Service Pack1 post I got few emails asking why there are 2 additional files ( SQLManagementStudio_x64_ENU.exe & SQLManagementStudio_x86_ENU.exe) included in the SP1 download page. Few notes and gotchas about this SQL...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Jul 27 2011
Filed under: Filed under: sql server, tools, dba, download, documentation, best practices, management studio, downgrade

Page 1 of 10 (194 items) 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

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