SqlServerKudos

SQL Server

1
kudos

Kudos

SQL Server 2008 R2 Reporting Services configuration: ERROR: Missing or Invalid ExtendedProtectionLevel setting

published 621 days, 18 hours, 13 minutes ago posted by

sa 630 days, 20 hours, 9 minutes ago

SQL Server 2008 R2 Reporting Services configuration: ERROR: Missing or Invalid ExtendedProtectionLevel setting

The above error is presented on the instance which has got SQL Server 2008 R2 Reporting Services and used Windows Authentication to connect. The newest additon to SQL Server 2008 R2 architecture is Extended Protection authentication , which is a set of enhancements to Windows Authentication. A brief referral on Technet reveals that the main authentication enhancements that are part of extended protection are service binding and channel binding. Channel binding uses a channel binding token (CBT),...(read ... (more)

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

tags: config file, extended protection, report viewer, Security, SQL Server, SQL Server 2008 R2, SSRS, tags, web service

1
kudos

Kudos

SQL Server 2008 R2 Monitoring Management Pack - Operations Manager

published 625 days, 18 hours, 28 minutes ago posted by

sa 634 days, 18 hours, 57 minutes ago

SQL Server 2008 R2 Monitoring Management Pack - Operations Manager

If your corporate environment is monitored by System Center Operations Manager 2007 then here is the update to download the Monitoring Management Pack. This pack of SQL Server Management Pack provides the capabilities for Operations Manager 2007 SP1 and R2 to discover SQL Server 2005, 2008, and 2008 R2. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents. SQL Server Monitoring Management pack download page refers the summary as follows: Feature Summary:..... (more)

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

tags: DBA, download, management pack, Monitoring, operations manager, scom, SQL Server, versioncontrol

1
kudos

Kudos

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

published 626 days, 18 hours, 33 minutes ago posted by

sa 635 days, 20 hours, 32 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

Ozziemedes on SQL Server: Data Infrastructure Architecture [2/2]

published 628 days, 18 hours, 43 minutes ago posted by

http://ozziemedessql.blogspot.com/ 638 days, 4 hours, 11 minutes ago

Ozziemedes on SQL Server: Data Infrastructure Architecture [2/2]

Yesterday I wrote a fairly long blog post which started to delve into some of the questions addressed by data infrastructure architecture. After writing more than 2000 words I decided it was time to give you all a break and for me to have some time away from the keyboard. So here’s the second instalment in which I’ll outline the remaining concerns for the data infrastructure components of data architecture.Data platform performance management One of the key success factors for a stable DBMS is that it... (more)

category: Community | clicked: 0 | comment | | source: ozziemedessql.blogspot.com

tags: Data Architecture, Infrastructure, licensing, Performance, Security, SQL Server

1
kudos

Kudos

Ozziemedes on SQL Server: Data Architecture Defined

published 629 days, 18 hours, 48 minutes ago posted by

http://ozziemedessql.blogspot.com/ 639 days, 17 hours, 21 minutes ago

Ozziemedes on SQL Server: Data Architecture Defined

Over the last few weeks I’ve been working with the PASS organization to start up a SQL Server Data Architecture Virtual Chapter (or “DArcVC” as it is starting to be known). Data Architecture has basically been my job for the last 12 years. I may have been paid as a DBA, or SQL developer, or BI consultant, or Microsoft Application Solutions consultant, but at the end of the day, what I’ve DONE in all of those roles has really revolved around data architecture. For those of you not familiar with what da... (more)

category: Community | clicked: 0 | comment | | source: ozziemedessql.blogspot.com

tags: Data, Data Architecture, Information, Insight, knowledge, SQL Server

1
kudos

Kudos

Released: Cumulative Update #11 for SQL Server 2005 Service Pack 3

published 634 days, 19 hours, 7 minutes ago posted by

sa 643 days, 20 hours, 2 minutes ago

Released: Cumulative Update #11 for SQL Server 2005 Service Pack 3

If you are following the patching of your SQL Server instances with Cumulative Updates then here is another instalment available for testing & deployment. To obtain and apply this CU #11 hotfix release for SQL Server 2005 SP3 you must apply the Sp3 for SQL Serve 2005 instance. Here is the KBA913089 to get the latest service pack on SQL Server 2005. For more information on the list of files that are updated as a part of this CU11 release, see KBA2258854 link, also there is an information about...(read more) (more)

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

tags: cumulative update, downgrade, native client, sp3, SQL Server, SQL Server 2005, support, Testing, uninstall

1
kudos

Kudos

Cumulative Update #3 for SQL Server 2008 R2 RTM

published 634 days, 19 hours, 7 minutes ago posted by

sa 643 days, 21 hours, 7 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

Ozziemedes on SQL Server: Musings on Good Data Architecture

published 639 days, 19 hours, 28 minutes ago posted by

http://ozziemedessql.blogspot.com/ 649 days, 14 hours, 15 minutes ago

Ozziemedes on SQL Server: Musings on Good Data Architecture

I was at a user group meeting tonight where a couple of developers were presenting on Entity Spaces. It was interesting to see the tool in action, but I can’t help but feel a little cautious about the kind of strong typing that’s going on in the myriad of class files that are getting built by the code generation framework. To me, it seems risky from a complexity perspective. In my opinion, a good ORM should be able to abstract the schema from the object-level implementation and provide a software-fa... (more)

category: Community | clicked: 4 | comment | | source: ozziemedessql.blogspot.com

tags: Archtiecture, Data Architecture, Entity Spaces, ORM, SQL Server, sqlpass

1
kudos

Kudos

Passing a TABLE variable into dynamic SQL | AdaTheDev

published 640 days, 19 hours, 32 minutes ago posted by

AdaTheDev 650 days, 5 hours, 2 minutes ago

Passing a TABLE variable into dynamic SQL | AdaTheDev

A question popped up on StackOverflow today, asking how to pass a TABLE variable into a dynamic SQL statement in SQL Server 2008. I've previously blogged about table-valued parameters, comparing the approach of passing in a TABLE of values to a stored procedure to the techniques you'd have had to use in earlier versions of SQL Server (e.g. CSV or XML), but this specific question is worth a quick follow-up. (more)

category: Query | clicked: 1 | comment | | source: www.adathedev.co.uk

tags: SQL, SQL Server

1
kudos

Kudos

SQL Server do not use PROFILER, use Server side trace to upload to table!

published 645 days, 19 hours, 53 minutes ago posted by

sa 654 days, 20 hours, 44 minutes ago

SQL Server do not use PROFILER, use Server side trace to upload to table!

As a followup questions from the post SQL Server Profiler: System is low on disk space on drive 'C'? here I had a feedback of how to save the server-side trace to a table? Well there is no direct path to do so, rather a roundabout method of once you have collected the trace using server-side method, open up the collect trace file in Profiler and click on File --> Save As --> Trace Table (see below): The reason it was disabled that I was already performing the Save-To-Table operation, as you...(read more) (more)

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

tags: benchmarking, Best Practices, DBA, disk space, server side, SQL Server, table, trace, XML

1
kudos

Kudos

TSQL: How to find a frequently executed TSQL statements that causes blocking issues?

published 649 days, 20 hours, 13 minutes ago posted by

sa 658 days, 21 hours, 3 minutes ago

TSQL: How to find a frequently executed TSQL statements that causes blocking issues?

If you know about SP_WHO2 (undocumented) (DBA savior) statement from SQL Server 7/2000 days you need no introduction to find what SPID is blocking and which is getting blocked. Here is another incident that caused much of chaos on a SQL instance that has been upgraded from SQL 7 to 2000 and then to 2008 directly! All is well until 2 weeks on newly married 2008 platform and trouble started when the batch process has been executed for first time on this new instance. This has escalated as a serious...(read... (more)

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

tags: Blocking, DBA, deadlocks, DMV, locks, sp_who2, SQL Server, sys_dm, table, TSQL

2
kudos

Kudos

List of free resources and tools specific to SQL Server 2008 R2

published 652 days, 20 hours, 19 minutes ago posted by

sa 661 days, 21 hours, 58 minutes ago

List of free resources and tools specific to SQL Server 2008 R2

Whenever the new version of SQL Server is released the first thing I search for Books Online update to upgrade the local copy. In similar to that Microsoft have been releasing lot of free resources and tools that can enhance the learning experience for Developers, DBA and Architects. So here are few resources that I would like to refer about R2 product specific: SQL Server 2008 R2 Feature Pack This R2 Feature Pack is a collection of stand-alone packages which provide additional value for SQL Server...(re... (more)

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

tags: .net4, Developer, Documentation, download, feature pack, learning, SharePoint, SQL Server, SQL Server 2008 R2, Version

1
kudos

Kudos

List of free downloads to enhance Visual Studio 2010 & SQL Server 2008 R2 knowledge

published 653 days, 20 hours, 24 minutes ago posted by

sa 662 days, 21 hours, 23 minutes ago

List of free downloads to enhance Visual Studio 2010 & SQL Server 2008 R2 knowledge

Here are few free tools and references to download that can enhance the Visual Studio 2010 knowledge: Visual Studio 2010 and .NET Framework 4 Training Kit Brief Description June 2010 Release of the Visual Studio 2010 and .NET Framework 4 Training Kit Visual Studio 2010 Keybinding Posters Brief Description Reference posters for the default keybindings in Visual Studio 2010 for Visual Basic, Visual C#, Visual C++ and Visual F# .NET Framework 3.5 Common Namespaces and Types Poster Brief Description...(read ... (more)

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

tags: developer kit, dotnet 4.0, feature pack, free, learning, report builder, SQL Server, SQL Server 2008 R2, technical learning, Training, visual studio 2010

1
kudos

Kudos

SQL Server - What is Transaction log file? Can I delete it? Think about Database Recovery Model too!

published 653 days, 20 hours, 24 minutes ago posted by

sa 662 days, 22 hours, 28 minutes ago

SQL Server - What is Transaction log file? Can I delete it? Think about Database Recovery Model too!

This was the question asked by a developer, due to a particular process fills up the transaction log so quickly. I had to explain the reason and tricks that can reduce the transaction log bulge using best recovery methods on the database. Going back to basics there certain FAQ about Transaction log usage within SQL Server. Transaction Log - why it is required? A log is a seperate file that stores all kinds of information about the SQL Server instance and databases. Each database has its own log file...(r... (more)

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

tags: Best Practices, DBA, disk space, free space, log writer, size, SQL Server, transactionon log, vlf

1
kudos

Kudos

SQL Bits 7 - Registrations now open

published 653 days, 20 hours, 24 minutes ago posted by

sa 663 days, 17 hours, 44 minutes ago

While we talked about list of sessions and vote on interested ones: http://sqlserver-qa.net/blogs/etc/archive/2010/07/19/9329.aspx here is hte news for you to register for this SQLBits 7 - The 7 Wonders of SQL conference, even bigger and better. SQLBits 7 will take place over three days from Thursday September 30th to Saturday October 2nd. Day one will be a training day, featuring in-depth full day seminars by leading SQL Server professionals such as Brent Ozar and Buck Woody (see http://www.sqlbits.com/... (more)

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

tags: Best Practices, community, Conference, SQL Server, SQL Server 2008 R2, SQLBits, Training

1
kudos

Kudos

Backup of a FILESTREAM database may include garbage files as well

published 653 days, 20 hours, 24 minutes ago posted by

sa 663 days, 19 hours, 54 minutes ago

Backup of a FILESTREAM database may include garbage files as well

I have been playing with FILESTREAM backups for a book that I am writing and came across something that I did not really like. I observed that a FILESTREAM backup may include garbage files which gets restored along with the database. What are garbage Read More......(read more) (more)

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

tags: #FILESTREAM, filestream, SQL Server, TSQL

1
kudos

Kudos

Stored procedure hangs, how to tell which statement is currently running?

published 654 days, 20 hours, 29 minutes ago posted by

sa 663 days, 22 hours, 4 minutes ago

Stored procedure hangs, how to tell which statement is currently running?

It is a common question that a particular stored procedure is executing for a long time and sometimes looks like it is hanging for longer time. This will cause if you have a trigger looping for the stored procedure actions and using following TSQL you can find which statement is current running or rather you are assuming it is hanging for long time: -- For the best results see the results to Text (CTRL +T before execution) DECLARE @Handle binary(20), @start int, @end int, @SPID int SET @SPID = spid...(re... (more)

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

tags: current, execution, hang, SQL Server, stored procedure, TSQL

1
kudos

Kudos

List of KBA links updated specific to SQL Server 2008

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

sa 669 days, 19 hours, 19 minutes ago

List of KBA links updated specific to SQL Server 2008

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Enterprise Notification Contents: New and Major Modifications Error message when you try to install a SQL Server 2008 cumulative update or service pack: "The patch installer has failed to update the shared features" http://support.microsoft.com/kb/2216468/en-US New 7/8/2010 8:33:00 AM GMT Error message when you try to open a project in SQL Server 2008: "The located assembly's manifest definition...(read ... (more)

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

tags: configuration, cumulative update, fulltext, kba, service broker, SQL Server

1
kudos

Kudos

Cumulative update package 9 for SQL Server 2008 Service Pack 1

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

sa 669 days, 20 hours, 24 minutes ago

Cumulative update package 9 for SQL Server 2008 Service Pack 1

Download and test the latest instalment of cumulative Update 9 for SQL Server 2008 Service Pack 1 which consist the hotfix release related to SQL Server 2008 version and fix to the issues since the release of Service Pack 1. The build number for this CU9 package is 10.00.2789.00. and KBA970365 gets you the list of builds since SQL Server 2008 SP1 release: Build 10.00.2775 (cumulative update) - CU8 Build 10.00.2770 & Build 10.00.2769 - interim fixes Build 10.00.2766 (cumulative update) - CU7 Build...(read... (more)

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

tags: Best Practices, ctp, cumulative update, deadlock, package, Performance, release, SQL Server, Testing, trace flag

1
kudos

Kudos

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

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

sa 669 days, 21 hours, 29 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

Welcome!

SQL Server

SQL Server 2008 R2 Reporting Services configuration: ERROR: Missing or Invalid ExtendedProtectionLevel setting

SQL Server 2008 R2 Monitoring Management Pack - Operations Manager

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

Ozziemedes on SQL Server: Data Infrastructure Architecture [2/2]

Ozziemedes on SQL Server: Data Architecture Defined

Released: Cumulative Update #11 for SQL Server 2005 Service Pack 3

Cumulative Update #3 for SQL Server 2008 R2 RTM

Ozziemedes on SQL Server: Musings on Good Data Architecture

Passing a TABLE variable into dynamic SQL | AdaTheDev

SQL Server do not use PROFILER, use Server side trace to upload to table!

TSQL: How to find a frequently executed TSQL statements that causes blocking issues?

List of free resources and tools specific to SQL Server 2008 R2

List of free downloads to enhance Visual Studio 2010 & SQL Server 2008 R2 knowledge

SQL Server - What is Transaction log file? Can I delete it? Think about Database Recovery Model too!

SQL Bits 7 - Registrations now open

Backup of a FILESTREAM database may include garbage files as well

Stored procedure hangs, how to tell which statement is currently running?

List of KBA links updated specific to SQL Server 2008

Cumulative update package 9 for SQL Server 2008 Service Pack 1

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

Open ID Login

Standard Login

Forgot Password?

Sign up