SqlServerKudos

Best Practices

1
kudos

Kudos

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

published 22 days, 21 hours ago posted by

sa 24 days, 21 hours, 30 minutes ago

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 set of support policy for service pack releases on every Microsoft product, which is nothing but support ends 12 months after next service pack releases or at the end of product's support lifecycle, whichever comes first. You can find more information... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: #sql2k8r2cookbook, administrator, Best Practices, DBA, lifecycle, sp_configure, sp3, SQL Server, support life cycle, Upgrade, upgrade advisor

1
kudos

Kudos

Master SQL Chef series: Implementing Security features #sql #sql2k8r2cookbook

posted by

sa 28 days, 21 hours, 50 minutes ago

Master SQL Chef series: Implementing Security features #sql #sql2k8r2cookbook

Security is key aspect to restrict access to your data, any platform or database that stores information needs a robuts infrastructure to control the access. The process to access the data will need a secure process or setup the system as 'secure-by-default'. Windows Server 2008 operating system has several configurable features such as platform, architecture and access layer. Similarly SQL Server 2008 also consist similar configurable features such as services, architecture, database objects and...(read... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

| flag as spam

tags: Best Practices, cookbook, feature, Master Data Management, operating system, policy based framework, Security, SQL Server, windows server

1
kudos

Kudos

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

published 28 days, 21 hours, 25 minutes ago posted by

sa 30 days, 22 hours ago

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 automate the routine tasks and develop proactive maintenance to ensure that data availability and integrity is maintained without any interruption. The management of automated processes is a different topic and in order to accomplish part of the task...(rea... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: automated administration, Best Practices, builtin, cookbook, Jobs, policy based framework, schedule, Security, SQL Server, system

1
kudos

Kudos

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

published 38 days, 22 hours, 6 minutes ago posted by

sa 45 days, 23 hours, 1 minute ago

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.50.1807.0. The list of issues are as follows with their KBA: VSTS bug number KB article number Description 834627 955850 (http://support.microsoft.com/kb/955850/ ) Error message when you try to use the binaries from the SQL Server System CLR Types package..... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: access, Best Practices, cumulative update, Documentation, downgrade, download, linked server, SQL Server

1
kudos

Kudos

Microsoft Assessment and Planning Toolkit 6.5 Now Available for Download

published 50 days, 23 hours, 1 minute ago posted by

sa 57 days, 23 hours, 56 minutes ago

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 to the cloud is now smoother than ever with the MAP Toolkit 6.5. The new features include securely assess the enviornment while enabling the workload evaluation for migration to private or public 'cloud' platforms. For me the most interesting part...(re... (more)

category: News | clicked: 1 | comment | | source: sqlserver-qa.net

tags: accleration, Azure, Best Practices, enterprise, map, planning, SQL Server, toolkit

1
kudos

Kudos

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

published 68 days, 12 minutes ago posted by

sa 71 days, 57 minutes ago

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 environments are managed. As you may be aware it was only available in Enterprise and Developer editions, since CU4 for SQL Server 2005 SP3 and CU2 for SQL Server 2008 SP1 it is enabled as a trace flag 845 for Standard Edition environment too. Lock Pages...(... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: benchmarking, Best Practices, configuration, cumulative update, lock down, lock pages in memory, performance monitoring, Security, SQL Server, Version

1
kudos

Kudos

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

published 69 days, 17 minutes ago posted by

sa 74 days, 1 hour, 13 minutes ago

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 SQL Server 2008 Service Pack 3 (SP3). KBA2633143 list the following article numbers about more information on the fixes: VSTS bug number KB article number Description 794387 2522893 (http://support.microsoft.com/kb/2522893/ ) FIX: A backup operation...(read ... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: access denied, access violation, Backup, Best Practices, CLR, cu2, cumulative update, downgrade, incremental service, sp3, SQL Server, stored procedure

1
kudos

Kudos

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

published 101 days, 4 hours, 6 minutes ago posted by

sa 110 days, 4 hours, 57 minutes ago

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 issue. The goal in performance monitoring and tuning includes the understanding of design patterns of the database with underlying data models. For me OLAP is always a mystery and whenever I get into OLAP or BI based performance issue I always go through...... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: analysis, benchmarking, Best Practices, Cube, Monitoring, Performance, performance guide, performance tuning, scalable, SQL Server

1
kudos

Kudos

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

published 106 days, 4 hours, 26 minutes ago posted by

sa 115 days, 5 hours, 22 minutes ago

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 not a big issue to perform the test and upgrade the existing instances of 2008 version. Once you apply the SP3 for SQL Server 2008 the version will be 10.00.5500.00 and also the download page clearly states the key enhancements out this SP3 release:...(read... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Best Practices, ctp, DBA, Documentation, download, Installation, service pack3, SQL Server

1
kudos

Kudos

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

published 108 days, 4 hours, 36 minutes ago posted by

sa 116 days, 4 hours, 38 minutes ago

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 use SSIS packages to perform the key maintenance activities. Though SSIS service is not imporant here but it is ideal to continue the key ETL activities using SSIS packages than TSQL methods. Just going back to basics running SSIS provides many capabilit... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: benchmarking, Best Practices, component services, error log, integration services, Security, SQL Server, SSIS

1
kudos

Kudos

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

published 111 days, 4 hours, 47 minutes ago posted by

sa 120 days, 5 hours, 38 minutes ago

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 of SQL Server platform. Having said that for any task or process you need a trusted and proven set of commands, statements and tools irrespective of hardware configuration or support arrangements (ISV or Managed Services). Whenever I engage with...(re... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: beginners, best practice analyzer, Best Practices, database, DBA, download, SQL Server, Tools, upgrade advisor, upgrade assistant

1
kudos

Kudos

SQL Relay - Cardiff Usergroup my presentation #sqlserverfaq #sqlrelay #upgrade #bpa

published 114 days, 5 hours, 2 minutes ago posted by

sa 121 days, 5 hours, 43 minutes ago

SQL Relay - Cardiff Usergroup my presentation #sqlserverfaq #sqlrelay #upgrade #bpa

It was a great opportunity to meet and greet the SQL professionals in Cradiff on 05th October 2011 as a part of SQL Relay Usergroup metings across UK. Thanks to Adam Morton for giving me chance to present, since last year and half we have been trying to get connected in Usergroup presentation. I must admit its a good attendance and presence of questions was good which keeps up the enthusiasm during the presentations. I presented two topics that surrounds on Best Practices for SQL Server users: SQL...(rea... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: beginners in sql serever, Best Practices, download, performance monitoring, SQL Server, SQLBits, sqlrelay, SSIS, Tools, Upgrade, usergroups

1
kudos

Kudos

Deal of The Day! Get 50% on MVP Deep Dives volume II book - SQL Server

published 116 days, 5 hours, 8 minutes ago posted by

sa 123 days, 5 hours, 8 minutes ago

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 practices written by 63 SQL Server MVPs. Get half off the MEAP eBook or MEAP pBook. Enter dotd1004cc in the Promotional Code box when you check out at manning.com. Use this same code to save 50% on SQL Server DMVs in Action and SQL Server MVP Deep Dives....(... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: beginners in sql serever, Best Practices, books, deep dives, discount, mvp, publisher, SQL Server

1
kudos

Kudos

Book Review: Microsoft SQL Server 2008 R2 Master Data Services from Packt Publishers

published 116 days, 5 hours, 8 minutes ago posted by

sa 125 days, 6 hours, 3 minutes ago

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 (MDS) is one of the new features that are introduced in SQL Server 2008 R2 version, and Master Data Management (MDM) concept which is also one of the new learning for me when I started working on data platform related projects. Whenever you start...(rea... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: beginners in sql serever, Best Practices, books, DBA, master data services, MDS, packt, review, SQL Server

2
kudos

Kudos

MVP Deep Dives Volume II - SQL Server. Release n October 2011, get yours if are attending SQLPASS 2011 conference

published 128 days, 6 hours, 2 minutes ago posted by

sa 131 days, 6 hours, 32 minutes ago

MVP Deep Dives Volume II - SQL Server. Release n October 2011, get yours if are attending SQLPASS 2011 conference

Before I jump into details about this book, I'm glad to be part of this book and thanks to lead authors. SQL Server has evolved into a technology that offers multiple features raning from small data solution to the mission-critical enterprise soluion, no limit ... no boundaries. Likewise the community is managed by world-class professionals who share (endless) the experience with thier efforts such as blogging, writing articles, managing local usergroups and speaking at conferences. Similarly on...(read ... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: beginners in sql serever, Best Practices, BI, books, concepts, Conference, DBA, deep dives, developers, ebook, effective, mvp, performance monitoring, performance tunning, SQL Server, volume

1
kudos

Kudos

Improve the community with your knowledge and experience, lets join the wagon - T-SQL Tuesday #22 – Data Presentation

published 140 days, 6 hours, 57 minutes ago posted by

sa 150 days, 6 hours, 7 minutes ago

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 a regular follower of T-SQL Tuesdays flow that lets you full range of tips, tweaks and learning on a specific topic. Not only that you can be part of the event by posting a relevant topic with a twitter hashtag. My fellow MVP Robert Pearl has got a sum-up...(read ... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: benefits, Best Practices, community, DBA, devloper, hashtag, mvp, SQL Server, TSQL2sDay, tsql-tuesdays, tweet

1
kudos

Kudos

Take the offer on SQL Server 2008 R2 Administration cookbook and SQL Server 2008 R2 Master Data Services

published 141 days, 7 hours, 2 minutes ago posted by

sa 150 days, 7 hours, 12 minutes ago

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 practical recipes for administering a high-performance SQL Server 2008 R2 system with this book and eBook. Author: Satya Shyam K Jayanty Microsoft SQL Server 2008 R2 Master Data Services Authors: Jeremy Kashel , Tim Kent , Martyn Bullerwell Manage and...(re... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: beginners in sql serever, Best Practices, books, DBA, disaster recovery, ebook, master data services, offer, packt, Performance, performance monitoring, publisher, SQL Server

1
kudos

Kudos

SQL Server BI Development practices: streamline the project deployment using tools

published 150 days, 8 hours, 17 minutes ago posted by

sa 158 days, 8 hours, 33 minutes ago

SQL Server BI Development practices: streamline the project deployment using tools

When you talk about Business Intelligence (BI) the key aspect of this arena is development, all the way you need to ensure that the design and development is thorougly following the aspects of the solution. In this scenario the deployment comes handy where you frequently deploy the project to a development server for unit testing in order to create AS databases defined by the project. Most of the coding can be handled using .NET technology, at the end you must ensure to data storage where the Analysis...... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Analysis Services, benchmarking, Best Practices, cpu, Hardware, Memory, parallel processing, Performance, profiler, SAN, SQL Server, ssd

2
kudos

Kudos

SQL Server Operational tactics: get to know about deprecated and discontinued features,

published 163 days, 9 hours, 14 minutes ago posted by

sa 166 days, 9 hours, 18 minutes ago

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 (my good old pal) post about What's old in SQLServer 11 , indeed a unique title to bookmark (triggered a thought to extend the information ... it is as follows). As a good practice whenever the new release of SQL Server is announced the first and foremost topic...(... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: backward compatibility, beginners, Best Practices, Denali, deprecated features, discontinued featuers, feature, fts, full-text, SQL Server, sql11, Tools

1
kudos

Kudos

Cast your vote for best SQL Server product in SQL Server Magazine Community choice awards - SQLCentric

published 166 days, 9 hours, 28 minutes ago posted by

sa 171 days, 9 hours, 39 minutes ago

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 and monitoring product. If we talk about DB performance monitoring then SQLCentric to cast your vote for Pearl Knowledge SQLCentric product. See more details about this SQLCentric from http://www.pearlknows.com/sqlcentric/ link, and soon new versiomn...(r... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Best Practices, choice, community, Monitoring, SQL Server, sql server magazine, vote

Welcome!

Best Practices

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

Master SQL Chef series: Implementing Security features #sql #sql2k8r2cookbook

Master SQL Chef series: Designing automated administration #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 #2 for SQL Server 2008 Service Pack 3 available for download

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

SQL Relay - Cardiff Usergroup my presentation #sqlserverfaq #sqlrelay #upgrade #bpa

Deal of The Day! Get 50% on MVP Deep Dives volume II book - SQL Server

Book Review: Microsoft SQL Server 2008 R2 Master Data Services from Packt Publishers

MVP Deep Dives Volume II - SQL Server. Release n October 2011, get yours if are attending SQLPASS 2011 conference

Improve the community with your knowledge and experience, lets join the wagon - T-SQL Tuesday #22 – Data Presentation

Take the offer on SQL Server 2008 R2 Administration cookbook and SQL Server 2008 R2 Master Data Services

SQL Server BI Development practices: streamline the project deployment using tools

SQL Server Operational tactics: get to know about deprecated and discontinued features,

Cast your vote for best SQL Server product in SQL Server Magazine Community choice awards - SQLCentric

Open ID Login

Standard Login

Forgot Password?

Sign up