SqlServerKudos

best practice

1
kudos

Kudos

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

published 4 hours, 36 minutes ago posted by

sa 9 days, 5 hours, 6 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 13 days, 5 hours, 32 minutes ago posted by

sa 22 days, 7 hours, 27 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 21 days, 6 hours, 7 minutes ago posted by

sa 29 days, 7 hours, 38 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 28 days, 6 hours, 38 minutes ago posted by

sa 37 days, 6 hours, 3 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 31 days, 6 hours, 53 minutes ago posted by

sa 39 days, 6 hours, 43 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 47 days, 8 hours, 4 minutes ago posted by

sa 56 days, 10 hours, 25 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 50 days, 8 hours, 19 minutes ago posted by

sa 59 days, 10 hours, 40 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 63 days, 9 hours, 15 minutes ago posted by

sa 71 days, 11 hours, 34 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 79 days, 10 hours, 27 minutes ago posted by

sa 88 days, 12 hours, 54 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 98 days, 11 hours, 54 minutes ago posted by

sa 102 days, 14 hours, 4 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

1
kudos

Kudos

Avoid SQL Injection with Parameters

published 106 days, 12 hours, 29 minutes ago posted by

sa 116 days, 12 hours, 4 minutes ago

The best way to avoid SQL Injection is with parameters. With parameters you can’t get SQL Injection. You only get SQL Injection where you are building a SQL statement by concatenating your parameter values in with your SQL statement. Annoyingly many TSQL...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlblogcasts.com

tags: best practice, Security, Tips and Tricks, TSQL

1
kudos

Kudos

Cumulative Update Package 10 for SQL Server 2008 - have a look at list of bug fixes

published 126 days, 13 hours, 58 minutes ago posted by

sa 135 days, 15 hours, 34 minutes ago

Cumulative Update Package 10 for SQL Server 2008 - have a look at list of bug fixes

In the recent times Microsoft Release Services adopted the 935897 Incremental Servicing Model (ISM) for SQL Server team to deliver hotfixes for reported problems, also the new 822499 naming schema for Microsoft SQL Server software update packages. In this regard here is the 10th instalment of Cumulative Update package for SQL Server 2008, so when you apply the fixes the build of the cumulative update package is also known as build 10.00.1835.00. A note of caution on backout plan if there is any problem..... (more)

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

tags: best practice, build, cumulative update, database mirroring, kba, package, service pack, SQL Server

1
kudos

Kudos

SQL Server Memory Cache - take help of DMV for optimal query plans

published 149 days, 14 hours, 33 minutes ago posted by

sa 156 days, 17 hours, 9 minutes ago

SQL Server Memory Cache - take help of DMV for optimal query plans

SQL Server query optimization and keepup of performance is not a black-art, it can be achieved in a fair manner if you treat your queries with plans with a are reused or recompiled plans that can help you design well-performing applications. There are ways to add a plan or data to the SQL Server cache or to remove a plan or data from SQL Server cache, but these techniques are only recommended for testing or troubleshooting purposes. The key point is more you understand about optimal query plans,...(read ... (more)

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

tags: benchmarking, best practice, BOL, cache, configuration, Memory, plan guide, Query, Security, SQL Server, technet

1
kudos

Kudos

Opportunity to contribute to Government of India - Unique Identification Project, a Developers initiative.

published 168 days, 15 hours, 59 minutes ago posted by

sa 175 days, 18 hours, 34 minutes ago

Opportunity to contribute to Government of India - Unique Identification Project, a Developers initiative.

Government of India has started the process & project of implementing the Unique Identification (UID) project for whole of India. For those who don’t know what it is find more about this initiative and see this PDF attachment too. Another face and lead of this project is Mr. Nandan Nilekani, CEO Infosys and the project has been regularly making public their progress (and it has been good hands). In order to take this further and flexible t he UID team has come up with a unique opportunity to...(read more) (more)

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

tags: .NET, best practice, c++, community, Developer, government, india, infosys, Java, microsoft, project, udi

1
kudos

Kudos

End of Support and lifecycle of Windows operating system

published 168 days, 15 hours, 59 minutes ago posted by

sa 176 days, 6 hours, 49 minutes ago

End of Support and lifecycle of Windows operating system

Here is the information about Windows Operating System support life cycle that you need to concentrate: With the end of support (EOS) coming for several products, moving to Windows 7 and utilizing the many features built into the product can help you achieve a more secure and compliant platform for your users, reduce your help desk costs, and increase performance and reliability for your end users. Here are some key dates to remember: March 1, 2010 – Windows 7 RC pre-expiration shut downs begin....(read ... (more)

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

tags: best practice, databases, environment, lifecycle, microsoft, operating system, server services, SQL Server, support, windows

1
kudos

Kudos

Customer Ready Guidelines for Security Advisory 979352 Updated (IE6 Vulnerability) - Get your IE6 browsers to upgrade to IE8

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

sa 191 days, 8 hours, 3 minutes ago

Customer Ready Guidelines for Security Advisory 979352 Updated (IE6 Vulnerability) - Get your IE6 browsers to upgrade to IE8

Here is the advisory guidelines email from Microsoft Security that I would like to share: Microsoft is aware of public exploit code released that impacts customers using Internet Explorer 6. Customers using Internet Explorer 8 are not affected by currently known attacks and exploits due to the improved security protections in IE8. To help protect our customers, we recommend that all customers immediately upgrade to Internet Explorer 8 . Customers should also consider applying the workarounds and...(read ... (more)

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

tags: best practice, blogs, guide, internet explorer, microsoft, msdn, Security, Upgrade

1
kudos

Kudos

SQL Server Management Studio - Obtain Misisng Indexes information and its limitations!

published 191 days, 20 hours, 53 minutes ago posted by

sa 198 days, 8 hours, 43 minutes ago

SQL Server Management Studio - Obtain Misisng Indexes information and its limitations!

It is a common criteria that using Dynamic Management Views (DMVs) you can easily obtain the system & database state on a SQL instance. It may not be easy for a starter DBA to ensure what kind of DMV is used to obtain information on Recent Expensive Queries, if so for you Activity Monitor is the tool to obtain information about SQL Server processes and how these processes affect the current instance of SQL Server. [This topic is pre-release documentation and is subject to change in future releases....(re... (more)

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

tags: best practice, database tuning advisor, execute plan, Management Studio, Performance, Query, SQL Server, SSMS

1
kudos

Kudos

Support for SQL Server 2008 RTM ends soon!

published 192 days, 20 hours, 58 minutes ago posted by

sa 199 days, 4 hours, 43 minutes ago

Support for SQL Server 2008 RTM ends soon!

Its the time again that you should re-visit your database platform to ensure none of the SQL instances fall within SQL Server 2005 Service Pack2 or SQL Server 2008 RTM editions! It is quite common scenario that few of Enterprises may not ...read more from Service-pack_Support policy blog post....(read more) (more)

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

tags: best practice, rtm, service pack, SQL Server, version 2008

1
kudos

Kudos

SQL Server Installation issues Rule "Long path names to files on SQL Server Installation media" failed

published 216 days, 22 hours, 41 minutes ago posted by

sa 226 days, 10 hours, 51 minutes ago

SQL Server Installation issues Rule "Long path names to files on SQL Server Installation media" failed

Whenever you plan or proceed for a SQL Server installation, it requires the following steps: Review installation requirements, installation options, system configuration checks, and security considerations. Run SQL Server Setup to install, upgrade, or migrate to SQL Server. Use SQL Server utilities to configure SQL Server. The above process & procedures are followed regardless of whether you chose to use SQL2008 Installation wizard or install from command prompt. Coming on when you choose from...(read more) (more)

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

tags: best practice, check, description, directory, disk, Installation, path, rules, Security, setup, SQL Server

1
kudos

Kudos

How fast you can obtain information about missing indexes? Its easy and quick!

published 241 days, 19 minutes ago posted by

sa 250 days, 8 hours, 42 minutes ago

How fast you can obtain information about missing indexes? Its easy and quick!

On the subject line the process to find the answer is not a short one! By design SQL Server engine takes care when the query optimizer generates a query plan, it analyzes what are the best indexes for a particular filter condition. If the best indexes do not exist, the query optimizer generates a suboptimal query plan, but still stores information about these indexes. The missing indexes feature from 2008 version (in specific) enables you to access information about these indexes so you can decide...(rea... (more)

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

tags: best practice, dbas, DMV, Execution Plan, index hint, Indexes, Monitoring, Performance, SQL Server, view server state

Welcome!

best practice

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

Avoid SQL Injection with Parameters

Cumulative Update Package 10 for SQL Server 2008 - have a look at list of bug fixes

SQL Server Memory Cache - take help of DMV for optimal query plans

Opportunity to contribute to Government of India - Unique Identification Project, a Developers initiative.

End of Support and lifecycle of Windows operating system

Customer Ready Guidelines for Security Advisory 979352 Updated (IE6 Vulnerability) - Get your IE6 browsers to upgrade to IE8

SQL Server Management Studio - Obtain Misisng Indexes information and its limitations!

Support for SQL Server 2008 RTM ends soon!

SQL Server Installation issues Rule "Long path names to files on SQL Server Installation media" failed

How fast you can obtain information about missing indexes? Its easy and quick!

Open ID Login

Standard Login

Forgot Password?

Sign up