SqlServerKudos - Stories tagged with SQL Server 2008 R2

SQL Server 2008 R2

atom rss
1
kudos
spam Kudos Remove

List of free resources and tools specific to SQL Server 2008 R2
published 4 hours, 36 minutes ago posted by sasa 1 day, 5 hours, 36 minutes ago
Saturday, July 31, 2010 3:23:24 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: 1 | 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 4 hours, 36 minutes ago posted by sasa 2 days, 5 hours ago
Saturday, July 31, 2010 3:23:24 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: 2 | 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 4 hours, 36 minutes ago posted by sasa 3 days, 1 hour, 21 minutes ago
Saturday, July 31, 2010 3:23:24 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 13 days, 5 hours, 31 minutes ago posted by sasa 22 days, 7 hours, 27 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_
1
kudos
spam Kudos Remove

SQL Server 2008 Service Pack 2 CTP available for testing
published 14 days, 5 hours, 36 minutes ago posted by sasa 23 days, 7 hours, 32 minutes ago
Saturday, July 17, 2010 2:22:37 PM GMT Thursday, July 08, 2010 12:27:06 PM GMT
SQL Server 2008 Service Pack 2 CTP available for testing
SQL Server Program team announced the CTP release of SQL Server 2008 Service Pack 2, as per the download page: The CTP version of SQL Server 2008 Service Pack 2 (SP2) is now available. You can use these packages to upgrade any of the following SQL Server 2008 editions: Enterprise Standard Evaluation Developer Workgroup This SP2 CTP contains all the cumulative updates that are released after SQL server 2008 SP1 which is CU 8. All the 3 platforms X86, IA64 & X64 releases are available, the next...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: ctp, Documentation, download, problems, report builder, SharePoint, sp2, SQL Server, SQL Server 2008 R2, support, Testing
1
kudos
spam Kudos Remove

SQL Server 2008 R2 BPA and MAXDOP rules - Database Engine - degree of parallelism is not set to recommended value
published 27 days, 6 hours, 32 minutes ago posted by sasa 36 days, 8 hours, 38 minutes ago
Sunday, July 04, 2010 1:26:33 PM GMT Friday, June 25, 2010 11:21:15 AM GMT
SQL Server 2008 R2 BPA and MAXDOP rules - Database Engine - degree of parallelism is not set to recommended value
In continuation to my Leverage Query and Index performance with MAXDOP/Max Degree of Parallelism option in SQL Server post on MAXDOP settings, I had an interesting rules to review when SQL Server 2008 R2 BPA ( download ) is executed. By default SQL 2008 R2 BPA has an embedded rule to detect the conditions of appropriate value for 'max degree of parallelism' option, and it is not configured in conjunction with the number of CPU's within a NUMA node as well as the Resource Governor (RG) workload configurat... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: bpa, configuration server, dbas, i/o, maxdop, rules, SQL Server, SQL Server 2008 R2, Tools
1
kudos
spam Kudos Remove

Developer training kits to download for your learning upgrade
published 31 days, 6 hours, 52 minutes ago posted by sasa 39 days, 7 hours, 48 minutes ago
Wednesday, June 30, 2010 1:06:43 PM GMT Tuesday, June 22, 2010 12:11:28 PM GMT
Developer training kits to download for your learning upgrade
Here is an impressive array of capabilities for developers that build upon key innovations introduced in SQL Server 2008, Visual Studio 2010, .NET framework 4, Windows Server 2008 R2 & Windows Azure platform. Microsoft's Developer & Platform Evangelism team has brought good resources for you to downlod the content and upgrade your knowledge at your own pace: Visual Studio 2010 and .NET Framework 4 Training Kit Windows Server 2008 R2 Developer Training Silverlight 4 Training Hands-On Labs...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: .net framework 4, Best Practices, kit, learning, microsoft, SQL Server, SQL Server 2008 R2, training course, Upgrade, visual studio 2010
1
kudos
spam Kudos Remove

StreamInsight is in all editions (except express)
published 41 days, 7 hours, 37 minutes ago posted by sasa 50 days, 10 hours, 18 minutes ago
Sunday, June 20, 2010 12:21:33 PM GMT Friday, June 11, 2010 9:40:39 AM GMT
StreamInsight is in all editions (except express)
Contrary to many posts and even press releases from Microsoft StreamInsight is not just for Data Center edition. It is available in all paid for editions. If you read the license terms http://go.microsoft.com/fwlink/?LinkID=186261&clcid=0x409 you...(read more) (more)
category: News | clicked: 4 | comment | | source: sqlblogcasts.com
tags: SQL Server 2008 R2, streaminsight
1
kudos
spam Kudos Remove

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 sasa 71 days, 11 hours, 34 minutes ago
Saturday, May 29, 2010 10:43:47 AM GMT Friday, May 21, 2010 8:25:27 AM GMT
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
spam Kudos Remove

SQL Server 2008 R2 PowerPivot for Excel and SharePoint is here; volume licensing downloads available
published 64 days, 9 hours, 20 minutes ago posted by sasa 72 days, 8 hours, 38 minutes ago
Friday, May 28, 2010 10:38:48 AM GMT Thursday, May 20, 2010 11:20:29 AM GMT
SQL Server 2008 R2 PowerPivot for Excel and SharePoint is here; volume licensing downloads available
Self-Service Business Intelligence is the new solution from SQL Server 2008 R2 that enables the end users to access, analyze and share data across the enterprise in an IT managed environment using Excel 2010 and SharePoint Sever 2010, no need for complex coding techniques. Data Platform Insider blog announces that volume licensing downloads for SQL Server 2008 R2 are available today in all languages, including the public availability of the much anticipated PowerPivot functionality, delivering on...(read... (more)
category: News | clicked: 1 | comment | | source: sqlserver-qa.net
tags: business intelligence, database, Excel, powerpivot, powerpoint, self-service, SQL Server, SQL Server 2008 R2, Tools
1
kudos
spam Kudos Remove

SQL Server 2008 R2 Feature Pack, get yours now
published 70 days, 9 hours, 44 minutes ago posted by sasa 78 days, 12 hours, 7 minutes ago
Saturday, May 22, 2010 10:15:22 AM GMT Friday, May 14, 2010 7:51:44 AM GMT
SQL Server 2008 R2 Feature Pack, get yours now
In continuation to the SQL Server 2008 R2 RTM release here is the another download the Feature Pack which consist the a collection of stand-alone packages which provide additional value to your R2 environment. Get the SQL Server 2008 R2 Feature pack and here is the notes from that link for more information: It includes the latest versions of: Redistributable components for Microsoft® SQL Server® 2008 R2. Add-on providers for Microsoft® SQL Server® 2008 R2. Note: Some components in the Microsoft®...(read ... (more)
category: News | clicked: 1 | comment | | source: sqlserver-qa.net
tags: backups, Documentation, downgrade, feature pack, object, SQL Server, SQL Server 2008 R2
1
kudos
spam Kudos Remove

SQL Server Certification - a database platform primer for your career path
published 72 days, 9 hours, 54 minutes ago posted by sasa 80 days, 12 hours, 13 minutes ago
Thursday, May 20, 2010 10:05:28 AM GMT Wednesday, May 12, 2010 7:46:08 AM GMT
SQL Server Certification - a database platform primer for your career path
When you need to upgrade your knowledge then training is required, at the same time certifications will help you to keep up on what you have learned! There is a big debate on the web about whether certifications are important in your career or not, the bottomline is if you do not know the stuff or unable to answer few basic technical questions, it does'nt matter how many certifications you have then you will not get the job, well I'm not starting the same discussion here. But in the recent times...(read ... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: Certification, path, real world, SQL Server, SQL Server 2008, SQL Server 2008 R2, study, technical
1
kudos
spam Kudos Remove

Free ebook: Introducing Microsoft SQL Server 2008 R2
published 75 days, 10 hours, 8 minutes ago posted by sasa 84 days, 11 hours, 43 minutes ago
Monday, May 17, 2010 9:50:33 AM GMT Saturday, May 08, 2010 8:16:15 AM GMT
Free ebook: Introducing Microsoft SQL Server 2008 R2
Well I'm glad to share the free eBook from Microsoft Press on Introducing Microsoft SQL Server 2008 R2 , by Ross Mistry (my fellow MVP & friend) and Stacia Misner! The book contains 10 chapters and 216 pages, like so: PART I Database Administration CHAPTER 1 SQL Server 2008 R2 Editions and Enhancements CHAPTER 2 Multi-Server Administration CHAPTER 3 Data-Tier Applications CHAPTER 4 High Availability and Virtualization Enhancements CHAPTER 5 Consolidation and Monitoring PART II Business Intelligence...(re... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: business intelligence, Documentation, download, ebooks, encryption, enhancement, new features, powerpivot, SQL Server, SQL Server 2008 R2, streaminsight
1
kudos
spam Kudos Remove

Mind the gap, the latest version number for SQL Server 2008 R2 is....
published 89 days, 11 hours, 9 minutes ago posted by sasa 98 days, 12 hours, 48 minutes ago
Monday, May 03, 2010 8:50:02 AM GMT Saturday, April 24, 2010 7:10:42 AM GMT
Mind the gap, the latest version number for SQL Server 2008 R2 is....
Since the news about SQL Server 2008 R2 RTM is publicised I have downloaded and installed the Evaluation edition and R2 Express edition. You can also download SQL Server 2008 R2 RTM - Management Studio Express (with pre-registration) The Microsoft® SQL Server® 2008 R2 RTM - Express is a powerful and reliable data management system that delivers a rich set of features, data protection, and performance for embedded applications, lightweight Web applications, and local data stores. Designed for easy...(read... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: BOL, Documentation, download, experience, express, SQL Engine, SQL Server, SQL Server 2008 R2, update
1
kudos
spam Kudos Remove

SQL Server 2008 R2 Developers Training Kit
published 164 days, 15 hours, 39 minutes ago posted by KodefuGuruKodefuGuru 172 days, 2 hours, 37 minutes ago
Wednesday, February 17, 2010 4:19:40 AM GMT Tuesday, February 09, 2010 5:21:41 PM GMT
SQL Server 2008 R2 Developers Training Kit
The SQL Server 2008 Developers Training Kit has been updated with new content for SQL Server 2008 R2. As given on the site: 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 R2 in their applications, as well as for developers who are new to SQL Server. The training kit is brought to you by Microsoft Developer and Platform Evangelism The training kit offe... (more)
category: News | clicked: 0 | comment | | source: www.sqlservercurry.com
tags: SQL Server 2008 R2, Training
1
kudos
spam Kudos Remove

SQLBits Videos available now available
published 172 days, 19 hours, 28 minutes ago posted by sasa 182 days, 6 hours, 53 minutes ago
Tuesday, February 09, 2010 12:30:58 AM GMT Saturday, January 30, 2010 1:05:33 PM GMT
SQLBits Videos available now available
You can watch all the sessions from SQLBits V now. They are available for download or for viewing online. If there is a delay then just wait, the videos are high quality and so are very large. These are the links to all the sessions (more)
category: News | clicked: 1 | comment | | source: sqlblogcasts.com
tags: free, SQL Server 2008, SQL Server 2008 R2, Training
1
kudos
spam Kudos Remove

How to get the most out of 96 cores
published 261 days, 1 hour, 52 minutes ago posted by sasa 270 days, 13 hours, 17 minutes ago
Thursday, November 12, 2009 6:06:57 PM GMT Tuesday, November 03, 2009 6:41:54 AM GMT
How to get the most out of 96 cores
Henk van der Valk is a consultant for Unisys. If you've never heard of him then he is one of the guys that worked on the ETL world record for loading a database last year. This was done with 64 cores. Now with support for 256 cores, Henk got his hands on a 96 core server and showed you what you could achieve with such a server. Have a look at this video to see what Henk could come up with http://www.youtube.com/watch?v=2qjrq8kpZUs If you are really interested in SQL Server performance t... (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: Performance, SQL Server 2008 R2, SQLBits
1
kudos
spam Kudos Remove

More testing of Unicode Compression in SQL Server 2008 R2
published 285 days, 4 hours, 36 minutes ago posted by sasa 294 days, 22 hours, 2 minutes ago
Monday, October 19, 2009 3:22:40 PM GMT Friday, October 09, 2009 9:56:42 PM GMT
More testing of Unicode Compression in SQL Server 2008 R2
Background Several weeks ago, I ran some tests on the new implementation of Unicode Compression in SQL Server 2008 R2 - both space-related and performance-related.  Of course it was pointed out that my performance tests were somewhat flawed, because I was using data from a very wide and atypical variety of characters sets.  I also didn't like that I was comparing too many different things in the same pass.  So, I thought I would run one more battery of tests, and right a couple of wrongs. So this time ... (more)
category: News | clicked: 2 | comment | | source: sqlblog.com
tags: Data Compression, SQL Server 2008, SQL Server 2008 R2, Unicode compression
1
kudos
spam Kudos Remove

SQL Server 2008 R2 bumps the database version
published 334 days, 19 hours, 39 minutes ago posted by sasa 339 days, 22 hours, 24 minutes ago
Monday, August 31, 2009 12:19:40 AM GMT Tuesday, August 25, 2009 9:35:07 PM GMT
SQL Server 2008 R2 bumps the database version
The first public CTP of 2008 R2 was just released (see http://www.microsoft.com/sqlserver/2008/en/us/R2.aspx) and many people are rushing to try it out. One word of caution: any database attached to a 2008 R2 server will have the database physical version number increased to 660. The database version number for 2008 RTM and SP1 is 655. This means that you won't be able to take that 2008 R2 database and attach it back (or backup/restore it back) to 2008 RTM or SP1. (more)
category: Management | clicked: 0 | comment | | source: www.sqlskills.com
tags: SQL Server 2008 R2
1
kudos
spam Kudos Remove

Peeking under the hood : what bits have changed in SQL Server 2008 R2?
published 334 days, 19 hours, 39 minutes ago posted by sasa 341 days, 2 hours, 24 minutes ago
Monday, August 31, 2009 12:19:40 AM GMT Monday, August 24, 2009 5:35:25 PM GMT
Peeking under the hood : what bits have changed in SQL Server 2008 R2?
We know what new features are available in SQL Server 2008 R2: data-tier applications (still with that unfortunate and poorly-chosen acronym, DAC), control point explorer, dashboard viewpoints, report builder 3.0, Unicode compression, StreamInsight, yada yada.  To me, at this early point in the release cycle, these features are, well, boring -- mostly because they are not yet fully implemented yet, or in a few cases, because I just haven't had the time to dig into them yet.  I do plan on doing some furth... (more)
category: News | clicked: 0 | comment | | source: sqlblog.com
tags: mssqlsystemresource, resource database, SQL Server 2008 R2
Previous 1 2 Next