SqlServerKudos

best practice

2
kudos

Kudos

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

published 9 days, 20 hours, 3 minutes ago posted by

sa 18 days, 21 hours, 4 minutes ago

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 to manage multi-server management through automated multi-server jobs, event forwarding and the ability to manage multiple instances from a single-machine console. Since SQL Server 2008 R2 version (and SQL Server 2008 SP2) onwards the SSMS tool has...(read... (more)

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

tags: #sql2k8r2cookbook, beginners, best practice, cookbook, data tier, DBA, management, SQL Server, SSMS, ucp, utility control point

1
kudos

Kudos

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

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

sa 32 days, 22 hours, 5 minutes ago

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 of new features and enhancements/automation to existing processes that will keep up the availability & scalability. The initial and important aspect of SQL Server platform upgrade is to manage the steps with a prior planning, to prepare for...(read m... (more)

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

tags: #sql2k8r2cookbook, best practice, cookbook, database, deprecated features, discontinued featuers, platform, SQL Server, Updates, upgrade advisor

1
kudos

Kudos

SQL Server Optimization series: Recompiles, query plans, cache - manage them efficiently

published 192 days, 11 hours, 28 minutes ago posted by

sa 200 days, 11 hours, 51 minutes ago

SQL Server Optimization series: Recompiles, query plans, cache - manage them efficiently

Query plan - an efficient way to guide the query execution, but how best you can help the query optimizer to prepare and compile the plan quickly for the better results. Whenever you are involved in the query performance exercise then ensure that the analysis must include the improvisation of query execution plans and monitor the cached query plans that are used by the application/ad hoc queries from users. There are plenty of resources available out there to talk about the query plan and plan cache,...(... (more)

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

tags: auto update, best practice, compiled, fixed plan, performance monitoring, SQL Server, stored procedure

1
kudos

Kudos

Microsoft SQL Server 2008 R2 Administration Cookbook - eBook and paperback Book - quick answers to common problems #sql #book

published 247 days, 15 hours, 22 minutes ago posted by

sa 255 days, 15 hours, 57 minutes ago

Microsoft SQL Server 2008 R2 Administration Cookbook - eBook and paperback Book - quick answers to common problems #sql #book

This is something big in my life to announce, it gives immensive pleasure and happiness to share about my first book (hard paper) and eBook release, titled : Microsoft SQL Server 2008 R2 Administration Cookbook is released and out now. share my experience and task based real-world best practices in a cookbook style. My thanks to the technical reviewers: Vinod Kumar from Microsoft India, Ravikanth Chaganti - SharePoint MVP and Venkatesan Prabu - SQL Server MVP for their efforts to shape up the book...(rea... (more)

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

tags: architects, availability, beginners, best practice, Book, DBA, ebooks, experience, Monitoring, mvp, packt, Performance, Programming, real-world, Scalability, SQL Server

1
kudos

Kudos

SQL Server service account permissions and gotchas #sql #bpa #sqlservice

published 260 days, 16 hours, 17 minutes ago posted by

sa 267 days, 14 hours, 38 minutes ago

SQL Server service account permissions and gotchas #sql #bpa #sqlservice

The number of services related to SQL Server has been doubled since SQL Server 2005 is released and 2008 R2 version has got few more to watch. The various services that are required/related to SQL Server are as follow and each of them will run as a seperate service that require relevant permissions to manage authentication of SQL Server operations with Windows operating system. The services and components will vary if you decide to install selective services, SQL Server seteup will allow the following...... (more)

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

tags: best practice, DBA, Monitoring, Security, server restart, service account, SQL Server, user right, windows nt

1
kudos

Kudos

SQL Server Performance series: Parametrized Index optimization to handle each fragmentation group

published 381 days, 23 hours, 51 minutes ago posted by

sa 391 days, 1 hour, 18 minutes ago

SQL Server Performance series: Parametrized Index optimization to handle each fragmentation group

As a DBA handling SQL Server platform performance issues is not an easy task in a multi-server and multi-database environment, in order to keep up the availability and scalability it is important to manage the database fragmentation on SQL Server in addition to operting system. If you are DBA then you don't need introduction about Ola Hallengren , who has done an excellent job in developing highly commendable & no-error scripts to handle the touch task of database fragmentation to keep up the...(read more) (more)

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

tags: best practice, DBA, index rebuild, Optimization, Performance, reorg, SQL Server, UPDATE STATISTICS

1
kudos

Kudos

Cumulative Update package 4 for SQL Server 2008 R2 released

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

sa 473 days, 8 hours, 22 minutes ago

Cumulative Update package 4 for SQL Server 2008 R2 released

SQL Server 2008 R2 has got another instalment of Cumulative Update 4 package release, that contains the hotfixes that have been packaged since the release of R2 RTM release. The build number for this release will be 10.50.1746.0, by default these builds are cumulative and release contains all the security fixes that were included in the previous CU release. So it is always better to download and test each of these CU packages seperately if you are facing such issues on SQL Server 2008 R2 instance....(rea... (more)

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

tags: best practice, cu4, cumulative update, download, encryption, Master Data Management, MDS, parallel data warehouse, SQL Server, SSMS, tde, Testing

2
kudos

Kudos

SQL Server magazine Community Choice Award - vote for Ola Hallengren SQL Server maintenance solution

published 510 days, 9 hours, 41 minutes ago posted by

sa 516 days, 11 hours, 26 minutes ago

SQL Server magazine Community Choice Award - vote for Ola Hallengren SQL Server maintenance solution

If you are a DBA then you will know the best results of Ola Hallengren's SQL Server maintenance solution. Ola has done excellent work helping the numerous DBAs with the excellence of maintaining the databases easily with a script. Refer to http://ola.hallengren.com site for more information and obtain the free scripts from his site. Further more here is your chance to payback, the maintenance tool has been nominated as Best Free Tool and your task is to vote with click on `this SQLMAG Community tool...(r... (more)

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

tags: award, best practice, community, database maintenance, mainstream, ola, SQL Server

1
kudos

Kudos

SQL Server performance bits - avoid compilations, help optimizer with better plans

published 519 days, 10 hours, 21 minutes ago posted by

sa 528 days, 12 hours, 20 minutes ago

SQL Server performance bits - avoid compilations, help optimizer with better plans

When you are dealing with SQL Server performance issues, not every issue can be classified as a problem for SQL Server. There are common characteristics within the issues, such as: Ad-hoc query execution typical taking longer time. Intermittent High CPU. Blocking irrespective of slow performance. Few times a memory pressure related errors on error log. So how can you help the SQL Server to fine tune the query performance using the internal optimizer techniques, which is called caching mechanisms....(read... (more)

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

tags: adhoc, auto grow, best practice, execute, parallel execution, Parameters, Performance, plan guide, query plan, SQL Server, stored procedure

1
kudos

Kudos

Cumulative Update #3 for SQL Server 2008 R2 RTM

published 527 days, 10 hours, 55 minutes ago posted by

sa 536 days, 12 hours, 55 minutes ago

Cumulative Update #3 for SQL Server 2008 R2 RTM

If you are following the patching of your SQL Server instances with Cumulative Updates then here is another instalment available for testing & deployment. KBA2261464 refers the release of CU3 hotfixes for the SQL Server 2008 R2 issues that have been fixed since the release of SQL Server 2008 R2 RTM, also the KBA refers the list of bugs fixed within this CU release (see below table). VSTS bug number KB article number Description 458389 979212 (http://support.microsoft.com/kb/979212/ ) FIX: A DateTime...(r... (more)

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

tags: best practice, cu3, cumulative update, download, rtm, SQL Server, SQL Server 2008 R2, Testing

1
kudos

Kudos

List of versions and bugs fixed on SQL Server 2008 Service Pack 2 (CTP)

published 553 days, 12 hours, 46 minutes ago posted by

sa 562 days, 13 hours, 17 minutes ago

List of versions and bugs fixed on SQL Server 2008 Service Pack 2 (CTP)

I had to answer bunch of questions around version number and fixes that are released for SQL Server 2005 & 2008, during a SQL Server platform health check for a client yesterday.. First one was, what is easy way to determine which version (service pack release) of SQL Server is running :As 2000 version is still operational (most of the places) I would say run the following TSQL against the registered SQL instances on your network: SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),.... (more)

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

tags: best practice, ctp, download, fix, service pack2, SQL Server, versions

1
kudos

Kudos

SQL Server 2008 R2 new features specific to OS related Dynamic Management Views - DMV

published 566 days, 13 hours, 42 minutes ago posted by

sa 575 days, 15 hours, 37 minutes ago

SQL Server 2008 R2 new features specific to OS related Dynamic Management Views - DMV

How many times have you taken help from SQL Server DMVs? How many of them are useful for your day-to-day data platform management? Well, they are closely attached to my day-to-day work. I'm excited to get my hands on upcoming client's project about their SQL Server platform review on the aspects of providing roadmap for the data-tier form a performance & scalability aspects with an additional flavour of high availability. In such scenarios I always keep my DBA-toolkit (scripts & references)...(read more) (more)

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

tags: best practice, cpu, database user, DBA, DMV, Memory, server scope, SQL Server, SQL Server 2008 R2, sys.dm_os_

1
kudos

Kudos

Loading Spatial Data the SSIS Way - SQL Server Standard magazine :: SQLPASS

published 574 days, 14 hours, 17 minutes ago posted by

sa 582 days, 15 hours, 48 minutes ago

Loading Spatial Data the SSIS Way - SQL Server Standard magazine :: SQLPASS

What am I thinking about the subject line - SSIS & Spatial data, how can both of the features fit in and how to accomplish? Here is the excellent magazine article by fellow MVP MIchael Coles on SQLPASS SQL Server Standard magazine, with a deep-dive information about Spatial features & SSIS way to accomplish the task. See this month's publication....bit of background about SQL Server Standard magazine: The SQL Server Standard is the flagship publication of PASS. It was produced in print from...(read more) (more)

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

tags: best practice, magazine, Spatial, SQL Server, sqlpass, SSIS, standard

1
kudos

Kudos

Leverage Query and Index performance with MAXDOP/Max Degree of Parallelism option in SQL Server

published 581 days, 14 hours, 48 minutes ago posted by

sa 590 days, 14 hours, 13 minutes ago

Leverage Query and Index performance with MAXDOP/Max Degree of Parallelism option in SQL Server

No matter how best you adopt the indexing practices, few times you have to tweak the resources to obtain optimized performance. This is where a degree of parallelism needs to be applied for your complex/large resulted queries on your SQL Server, having a multiple CPU based server is a quite common criteria. By design SQL database engine with more than CPU detects the best degree of parallelism, that is number of processors employed to run a single statement, for each parallel plan execution. Unless...(re... (more)

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

tags: benchmarking, best practice, DBA, latches, max worker threads, maxdop, numa, parallel execution, Performance, performance monitoring, Query, SQL Server, threads

1
kudos

Kudos

SQL Server 2008 R2 Update for Developers Training Kit get June 2010 Update

published 584 days, 15 hours, 3 minutes ago posted by

sa 592 days, 14 hours, 53 minutes ago

SQL Server 2008 R2 Update for Developers Training Kit get June 2010 Update

Are you interested to obtain a training kit to update your SQL Server 2008 R2 knowledge? Then here is the elegant way to obtain such resources from Developer & Platform Evangelism team, there are array of capabilities for developers that build upon key innovations introduced in SQL Server 2008. The SQL Server 2008 R2 Update for Developers Training Kit is ideal for developers who want to understand how to take advantage of the key improvements introduced in SQL Server 2008 and SQL Server 2008...(read more) (more)

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

tags: beginners, best practice, demos, developer training kit, hands-on, learning, presentation, SQL Server, Training, version 2008, Video

1
kudos

Kudos

Cumulative Update packages for SQL Server 2008 R2 RTM & SQL Server 2008 SP1

published 600 days, 16 hours, 14 minutes ago posted by

sa 609 days, 18 hours, 35 minutes ago

Cumulative Update packages for SQL Server 2008 R2 RTM & SQL Server 2008 SP1

Here is the news on Cumulative Update release news on SQL Server 2008 R2 RTM & SQL Server 2008 Service Pack 1. First let us go through SQL Server 2008 R2 RTM cumulative update, release consist the only hotfixes that were released in Cumulative Update 5, 6, & 7 for SQL Server 2008 SP1. Cumulative Update 1 for SQL 2008 R2 RTM is only intended as a post-RTM rollup for Cumulative Update 5-7 for the release version of SQL Server 2008 SP1 customers who plan to upgrade to SQL Server 2008 R2 and...(read more) (more)

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

tags: best practice, cumulative update, download, rtm, service pack1, slipstream, SQL Server

1
kudos

Kudos

SQL Server 2008 R2 Deprecated Features : will be removed from future version of SQL Server

published 603 days, 16 hours, 29 minutes ago posted by

sa 612 days, 18 hours, 50 minutes ago

SQL Server 2008 R2 Deprecated Features : will be removed from future version of SQL Server

It is always a best practice to read about or know more on DEPRECATED features whenever a new version of SQL Server is released, as I did for recent 2008 R2 version here are few important ones that I would like to present. Since the release of SQL Server 2005 Microsoft has been promoting the topic of Deprecated & Discontinued features of product, which describes the deprecated database engine features that are still available in current version and a caution on these features are scheduled to...(read more) (more)

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

tags: best practice, samples, SQL Server, unable

1
kudos

Kudos

SQL Server Setup Portal - a preview and planning of what you are about to setup?

published 616 days, 17 hours, 26 minutes ago posted by

sa 624 days, 19 hours, 44 minutes ago

SQL Server Setup Portal - a preview and planning of what you are about to setup?

There is a myth (rather a wrong impression) in database world that SQL Server setup is pretty easy, what you do is insert setup-media into drive and click next....next.....next, well it is not!!! Here is the opportunity to see the SQL Server 2008 R2 setup process, along with prepare & install/upgrade. There needs lot of consideration such as installation pre-requisites, features/editions, security considerations etc. and also the upgrade advisor, very useful tool to simulate the upgrade process...(read m... (more)

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

tags: best practice, DBA, Installation, Process, setup, SQL Server, SQL Server 2008 R2, step by step, upgrade advisor

1
kudos

Kudos

SQL Server 2008 R2 is here now, MSDN and Technet subscribers get ready to download

published 632 days, 18 hours, 38 minutes ago posted by

sa 641 days, 21 hours, 4 minutes ago

SQL Server 2008 R2 is here now, MSDN and Technet subscribers get ready to download

IN contintuation to SQL Server 2008 R2 announcement here is the good news for MSDN & Technet subscribers, see SQL Server 2008 R2 is now available to MSDN and TechNet subscribers go to your relevant subscriptions to download. Don't forget to uninstall the previous & current SQL Server 2008 R2 CTP releases (by taking database backups) and install afresh for further testing. Good luck.... more to come on R2 here!...(read more) (more)

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

tags: backups, best practice, Blocking, database, Installation, r2, SQL Server

1
kudos

Kudos

SQL Server 2005 Standard Edition, Enterprise Edition & X64 based Knowledge Base Article changes

published 651 days, 20 hours, 4 minutes ago posted by

sa 655 days, 22 hours, 15 minutes ago

SQL Server 2005 Standard Edition, Enterprise Edition & X64 based Knowledge Base Article changes

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New FIX: You receive a "Provider Load Failure" error message or the WMIPRVSE.EXE process stops responding when you use a SQL Server 2005 WMI provider to obtain information about SQL Server 2005 services http://support.microsoft.com/kb/980142/en-US FIX: Proactive caching starts unexpectedly when you insert data in SQL Server 2005 http://support.microsoft.com/kb/98... (more)

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

tags: best practice, database mail, dbcc checkdb, enterprise edition, kba, Performance, SQL Server, SSAS, ssiss, SSRS, standard edition, x64

Welcome!

best practice

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

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

SQL Server Optimization series: Recompiles, query plans, cache - manage them efficiently

Microsoft SQL Server 2008 R2 Administration Cookbook - eBook and paperback Book - quick answers to common problems #sql #book

SQL Server service account permissions and gotchas #sql #bpa #sqlservice

SQL Server Performance series: Parametrized Index optimization to handle each fragmentation group

Cumulative Update package 4 for SQL Server 2008 R2 released

SQL Server magazine Community Choice Award - vote for Ola Hallengren SQL Server maintenance solution

SQL Server performance bits - avoid compilations, help optimizer with better plans

Cumulative Update #3 for SQL Server 2008 R2 RTM

List of versions and bugs fixed on SQL Server 2008 Service Pack 2 (CTP)

SQL Server 2008 R2 new features specific to OS related Dynamic Management Views - DMV

Loading Spatial Data the SSIS Way - SQL Server Standard magazine :: SQLPASS

Leverage Query and Index performance with MAXDOP/Max Degree of Parallelism option in SQL Server

SQL Server 2008 R2 Update for Developers Training Kit get June 2010 Update

Cumulative Update packages for SQL Server 2008 R2 RTM & SQL Server 2008 SP1

SQL Server 2008 R2 Deprecated Features : will be removed from future version of SQL Server

SQL Server Setup Portal - a preview and planning of what you are about to setup?

SQL Server 2008 R2 is here now, MSDN and Technet subscribers get ready to download

SQL Server 2005 Standard Edition, Enterprise Edition & X64 based Knowledge Base Article changes

Open ID Login

Standard Login

Forgot Password?

Sign up