SqlServerKudos

best practice

1
kudos

Kudos

Avoid SQL Injection with Parameters

published 767 days, 4 hours, 54 minutes ago posted by

sa 777 days, 4 hours, 29 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

2
kudos

Kudos

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

published 787 days, 6 hours, 23 minutes ago posted by

sa 796 days, 7 hours, 59 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 810 days, 6 hours, 58 minutes ago posted by

sa 817 days, 9 hours, 34 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 829 days, 8 hours, 24 minutes ago posted by

sa 836 days, 10 hours, 59 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 829 days, 8 hours, 24 minutes ago posted by

sa 836 days, 23 hours, 14 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 842 days, 12 hours, 34 minutes ago posted by

sa 852 days, 28 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 852 days, 13 hours, 18 minutes ago posted by

sa 859 days, 1 hour, 8 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 853 days, 13 hours, 23 minutes ago posted by

sa 859 days, 21 hours, 8 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 877 days, 15 hours, 6 minutes ago posted by

sa 887 days, 3 hours, 16 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: 6 | 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 901 days, 16 hours, 44 minutes ago posted by

sa 911 days, 1 hour, 7 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

1
kudos

Kudos

SQL Server 2008 - Unstructured Data Storage Solutions and Best practices, SQLBits

published 912 days, 17 hours, 37 minutes ago posted by

sa 921 days, 21 hours, 52 minutes ago

SQL Server 2008 - Unstructured Data Storage Solutions and Best practices, SQLBits

Data is most business-critical for any organization and no doubt that they invest heavily to make data management system more efficient, above all the storage is important piece in the puzzle. Now a days there are no limitation in terms of what kind or type of data you can store in the database, where SQL Server has no such limitation since version 2008. Storage of relational and beyond relational data is managable but think when such data (unstructured) needs to be managed on high volume in the...(read ... (more)

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

tags: best practice, Data, data storage, image, SQL Server, strategy, unstructured, XML

Welcome!

best practice

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!

SQL Server 2008 - Unstructured Data Storage Solutions and Best practices, SQLBits

Open ID Login

Standard Login

Forgot Password?

Sign up