SqlServerKudos - Stories tagged with SQL Server 2008 R2

SQL Server 2008 R2

atom rss
1
kudos
spam Kudos Remove

SQL Server 2008 R2 Service Pack 1 CTP - test and feedback #sql #sqltools #ctp
published 373 days, 18 hours, 41 minutes ago posted by sasa 378 days, 18 hours, 1 minute ago
Monday, May 16, 2011 11:36:18 AM GMT Wednesday, May 11, 2011 12:16:34 PM GMT
SQL Server 2008 R2 Service Pack 1 CTP - test and feedback #sql #sqltools #ctp
SQL Server 2008 R2 service pack 1 contains all the cumulative update pack releases since RTM release. This means SP1 CTP consist the CU Package releases from 1 to 6, as CU7 has released on April 18th 2011. So before you test the SQL2008R2SP1 CTP, I would encourage to go through the release notes that gives information about list of issues that are fixed and what's new with this release: The following features are new in Service Pack 1 (SP1). Dynamic Management Views for increased supportability....(read ... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: Best Practices, ctp, DBA, Documentation, downgrade, releases, service pack, SQL Server, SQL Server 2008 R2, Upgrade
1
kudos
spam Kudos Remove

Cannot resolve the collation conflict
published 440 days, 22 hours, 23 minutes ago posted by http://ghemant.myopenid.com/http://ghemant.myopenid.com/ 450 days, 19 hours, 37 minutes ago
Thursday, March 10, 2011 7:54:58 AM GMT Monday, February 28, 2011 10:40:28 AM GMT
Cannot resolve the collation conflict
Recently when I was referring to SQL Server Forums I saw a question that reads like: I get an error Cannot resolve the collation conflict between "Latin1GeneralCIAI" and "SQLLatin1GeneralCP1CIAS" in the equal to operation. (more)
category: News | clicked: 0 | comment | | source: www.sql-server-citation.com
tags: collate, collation settings, hemantgiri s goswami, SQL Server, SQL Server 2008 R2, sql server citation
2
kudos
spam Kudos Remove

Cumulative Update package 5 for SQL Server 2008 R2 :: to test & deploy
published 509 days, 3 hours, 12 minutes ago posted by sasa 518 days, 4 hours, 53 minutes ago
Saturday, January 01, 2011 3:05:38 AM GMT Thursday, December 23, 2010 1:24:37 AM GMT
Cumulative Update package 5 for SQL Server 2008 R2 :: to test & deploy
Another instalment of Cumulative Update package (which is 5 now) for SQL Server 2008 R2 is available to test and deploy on to your production systems. So the build number after you apply this CU5 will be 10.50.1753 (thats an easy number to remember).You have to restart the instance once the CU5 is applied on SQL2008 R2 instance, I didn't get the reboot notification but I was not able to restart SQL instance after the implentation so I have to go for a reboot of machine. Here are the list of builds...(rea... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: cu5, cumulative update, DBA, Deploy, download, SQL Server, SQL Server 2008 R2, Testing, Version, vs2008
1
kudos
spam Kudos Remove

Make huge space savings by using SPARSE columns
published 514 days, 3 hours, 32 minutes ago posted by sasa 523 days, 6 hours, 13 minutes ago
Monday, December 27, 2010 2:45:24 AM GMT Saturday, December 18, 2010 12:04:54 AM GMT
Make huge space savings by using SPARSE columns
I’ve blogged before about Getting more than 1024 columns on a table , this is done by using sparse columns. Whilst this is potentially useful for people with insane table designs, sparse columns aren’t just for this. My experience over the past few years...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: Performance, SQL Server 2008, SQL Server 2008 R2, storage
1
kudos
spam Kudos Remove

Get your free SQL Server 2008 R2 System Views Map
published 522 days, 4 hours, 8 minutes ago posted by sasa 531 days, 5 hours, 49 minutes ago
Sunday, December 19, 2010 2:09:48 AM GMT Friday, December 10, 2010 12:28:39 AM GMT
Get your free SQL Server 2008 R2 System Views Map
System views map is a good resource of information for every DBA to know internals of system catalogs of a product. In this case SQL Server 2008 R2 system views map is available for download in the form of PDF & XPS file. Download link refers: The Microsoft SQL Server 2008 R2 System Views Map shows the key system views included in Microsoft SQL Server 2008 and SQL Server 2008 R2, and the relationships between them. The map is similar to the Microsoft SQL Server 2008 version and includes updates...(read m... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: DBA, Documentation, map, SQL Server, SQL Server 2008 R2, system views
1
kudos
spam Kudos Remove

Restricting logons during certain hours for certain users
published 528 days, 4 hours, 29 minutes ago posted by sasa 537 days, 6 hours, 5 minutes ago
Monday, December 13, 2010 1:48:26 AM GMT Saturday, December 04, 2010 12:13:11 AM GMT
Restricting logons during certain hours for certain users
Following a an email in a DL I decided to look at implementing a logon restriction system to prevent users from logging on at certain ties of the day. The poster had a solution but wanted to add auditing. I immediately thought of the My post on logging...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: Logon Triggers, Security, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2011
1
kudos
spam Kudos Remove

Trace Flag 610 – When should you use it?
published 544 days, 5 hours, 40 minutes ago posted by sasa 553 days, 8 hours, 20 minutes ago
Saturday, November 27, 2010 12:37:46 AM GMT Wednesday, November 17, 2010 9:57:27 PM GMT
Trace Flag 610 – When should you use it?
Thanks to Marcel van der Holst for providing this great information on the use of Trace Flag 610. This trace flag can be used to have minimal logging into a b tree (i.e. clustered table or an index on a heap) that already has data. It is a trace flag...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: Performance, SQL Server 2008, SQL Server 2008 R2, storage, Trace flags
1
kudos
spam Kudos Remove

Product Documentation aka 'BOL' web links for SQL Server 2008, 2008 R2 & Denali (CTP) versions
published 545 days, 5 hours, 45 minutes ago posted by sasa 554 days, 7 hours, 30 minutes ago
Friday, November 26, 2010 12:32:47 AM GMT Tuesday, November 16, 2010 10:47:29 PM GMT
Product Documentation aka 'BOL' web links for SQL Server 2008, 2008 R2 & Denali (CTP) versions
BOL - Book OnLine is a primary resource to get to know about the product in addition to the numerous blogs & resources on the web. As a best practice I always update my local copies of SQL Server Books Online for versions 2008, 2008 R2 & Denali (CTP). Though I still maintain books online for 6.5, 7.0 and 2000 versions too for a reference. If you are 'lazy' or do not have capability to upgrade the SQL BOL on your office machine/laptop then here are the links that will open up a web page for...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: 100, 105, 110, Books Online, ctp, Denali, Documentation, download, preview, SQL Server, SQL Server 2008, SQL Server 2008 R2, update, versions
1
kudos
spam Kudos Remove

Upgrading from SQL 2005 to SQL 2008 R2 – Fails if default data folder doesn’t exist
published 553 days, 6 hours, 20 minutes ago posted by sasa 563 days, 3 hours, 36 minutes ago
Wednesday, November 17, 2010 11:57:23 PM GMT Monday, November 08, 2010 2:41:25 AM GMT
Upgrading from SQL 2005 to SQL 2008 R2 – Fails if default data folder doesn’t exist
This might apply to other upgrades as well but I would this today. If the default data and log directories don’t exist then the upgrade fails. The reason is that the upgrade tries to create a database in the default locations and that fails and so your...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: setup, SQL Server 2008 R2
1
kudos
spam Kudos Remove

SQL Server 2008 R2: SYSPREP - Rule Unsupported for SysPrep SQL Server Products failed
published 592 days, 10 hours ago posted by sasa 602 days, 8 hours, 46 minutes ago
Saturday, October 09, 2010 8:18:16 PM GMT Wednesday, September 29, 2010 9:31:21 PM GMT
SQL Server 2008 R2: SYSPREP - Rule Unsupported for SysPrep SQL Server Products failed
SysPrep is the new functionality for SQL Server 2008 R2 installation feature that has been added with R2 version. The installatino of SQL Server always pass-thru 2 actions, prepare and complete which is integrated from SQL Server 2008 version onwards. But now with SQL Server 2008 R2, in addition to the integrated one step installation of a stand-alone instance of SQL Server, a two step installation is also available. The steps include the following: Prepare Image - This step stops the installation...(rea... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: Best Practices, downgrade, installallation, sql express, SQL Server, SQL Server 2005, SQL Server 2008 R2, sysprep
1
kudos
spam Kudos Remove

SQL Server Configuration manager: The request failed or service did not respond in timely fashion
published 594 days, 10 hours, 9 minutes ago posted by sasa 603 days, 12 hours, 6 minutes ago
Thursday, October 07, 2010 8:08:22 PM GMT Tuesday, September 28, 2010 6:11:26 PM GMT
SQL Server Configuration manager: The request failed or service did not respond in timely fashion
This morning when I tried to connect to my local SQL Server 2008 R2 instance, it was failing constantly with the error on subject line when I'm trying to START the MSSQLServer service. I have around 4 SQL Server service running on this laptop and checked that all the other SQL instance are also stopped including this SQL2k8R2 instance. In general I install the CTP & RC0 versions on a VM to ensure it doesn't disturb any of my demo capabilities during the SQL conferences. If you have only 1 instance...(rea... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: editions, evaluation, Installation, retail, service account, SQL Server, SQL Server 2008 R2
2
kudos
spam Kudos Remove

SQL Server 2008 R2 Quiz - Participate and win cool prizes!
published 621 days, 11 hours, 59 minutes ago posted by sasa 628 days, 13 hours, 25 minutes ago
Friday, September 10, 2010 6:18:36 PM GMT Friday, September 03, 2010 4:53:15 PM GMT
SQL Server 2008 R2 Quiz - Participate and win cool prizes!
...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: code, community, msdn, prize, quiz, resources, SQL Server 2008 R2
2
kudos
spam Kudos Remove

StreamInsight Updates 1.0 - get from Cumulative Update package 2 for Microsoft SQL Server 2008 R2
published 623 days, 12 hours, 9 minutes ago posted by sasa 630 days, 13 hours, 34 minutes ago
Wednesday, September 08, 2010 6:08:42 PM GMT Wednesday, September 01, 2010 4:43:21 PM GMT
StreamInsight Updates 1.0 - get from Cumulative Update package 2 for Microsoft SQL Server 2008 R2
One of the newest additions from SQL Server 2008 R2 is StreamInsight, Its high-throughput stream processing architecture and the Microsoft .NET Framework-based development platform enable you to quickly implement robust and highly efficient event processing applications. This is helpful for the data sources and data-stream that include financial based applications such as stock exchange trading or organisation dealing with SEO & Web analytics applications. For more information on development...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: .net4, build, cumulative update, Developer, framework, package, SQL Server, SQL Server 2008 R2, streaminsight
1
kudos
spam Kudos Remove

SQL Server 2008 R2 Reporting Services configuration: ERROR: Missing or Invalid ExtendedProtectionLevel setting
published 623 days, 12 hours, 9 minutes ago posted by sasa 632 days, 14 hours, 5 minutes ago
Wednesday, September 08, 2010 6:08:42 PM GMT Monday, August 30, 2010 4:12:46 PM GMT
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
spam Kudos Remove

Cumulative Update #3 for SQL Server 2008 R2 RTM
published 636 days, 13 hours, 3 minutes ago posted by sasa 645 days, 15 hours, 4 minutes ago
Thursday, August 26, 2010 5:14:22 PM GMT Tuesday, August 17, 2010 3:14:08 PM GMT
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
spam Kudos Remove

Download MS SQL Server 2008 R2 Management Pack | SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP
published 643 days, 13 hours, 34 minutes ago posted by http://ghemant.myopenid.com/http://ghemant.myopenid.com/ 652 days, 23 hours, 47 minutes ago
Thursday, August 19, 2010 4:44:00 PM GMT Tuesday, August 10, 2010 6:30:42 AM GMT
Download MS SQL Server 2008 R2 Management Pack | SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP
Share Recently Microsoft has released MS SQL Server 2008 R2 Management Pack, it can monitor the Microsoft SQL Server components such as database engine, databases and SQL Server agents. MS SQL Server 2008 R2 Management Pack has few enhancements in this release including: Simplified and streamlined customer configuration and deploymentLower cost of operation due to improved health model and reduced false alarmsMeets low-privilege constraints needed for financial and medical industriesNew rules, monito... (more)
category: News | clicked: 1 | comment | | source: www.sql-server-citation.com
tags: download sql server 2008 r2 mangement pack, monitor sql server, MS SQL Server 2008 R2 Management Pack, operation manager, SQL Server 2008 R2, SQL Server Agent
2
kudos
spam Kudos Remove

List of free resources and tools specific to SQL Server 2008 R2
published 654 days, 14 hours, 16 minutes ago posted by sasa 663 days, 15 hours, 54 minutes ago
Sunday, August 08, 2010 4:02:08 PM GMT Friday, July 30, 2010 2:23:27 PM GMT
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
spam Kudos Remove

List of free downloads to enhance Visual Studio 2010 & SQL Server 2008 R2 knowledge
published 655 days, 14 hours, 21 minutes ago posted by sasa 664 days, 15 hours, 19 minutes ago
Saturday, August 07, 2010 3:57:09 PM GMT Thursday, July 29, 2010 2:58:30 PM GMT
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
spam Kudos Remove

SQL Bits 7 - Registrations now open
published 655 days, 14 hours, 21 minutes ago posted by sasa 665 days, 11 hours, 40 minutes ago
Saturday, August 07, 2010 3:57:09 PM GMT Wednesday, July 28, 2010 6:37:32 PM GMT
SQL Bits 7 - Registrations now open
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
spam Kudos Remove

SQL Server 2008 R2 new features specific to OS related Dynamic Management Views - DMV
published 675 days, 15 hours, 50 minutes ago posted by sasa 684 days, 17 hours, 46 minutes ago
Sunday, July 18, 2010 2:27:34 PM GMT Friday, July 09, 2010 12:32:07 PM GMT
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_
Previous 1 2 3 Next