Are ITKE and MicrosoftExpert just shills for Microsoft?
They are questions from the chats that they have on the site. It is not intended to be marketing speak but if users feel that these types of messages arent appropriate for the community we can stop.
View Answer
| May 7, 2010 10:10 PM
Marketing, Microsoft, SQL Server
They are questions from the chats that they have on the site. It is not intended to be marketing speak but if users feel that these types of messages arent appropriate for the community we can stop.
View Answer
| May 7, 2010 10:10 PM
Marketing, Microsoft, SQL Server
SQL Server Log Shipping 2005 to 2008
You can move logs from 2005 to 2008, but you can’t fail over, because if you do you can’t fail back. Odds are the MS configuration utility won’t let you do it. You would need to write your own log shipping to make this happen.
View Answer
| May 7, 2010 10:01 PM
Backup and recovery software, SQL Server 2005, SQL Server 2005 log shipping, SQL Server 2008, SQL Server backup
You can move logs from 2005 to 2008, but you can’t fail over, because if you do you can’t fail back. Odds are the MS configuration utility won’t let you do it. You would need to write your own log shipping to make this happen.
View Answer
| May 7, 2010 10:01 PM
Backup and recovery software, SQL Server 2005, SQL Server 2005 log shipping, SQL Server 2008, SQL Server backup
What is the process to upgrade a database from SQL Server 2000 to SQL Server 2008 R2?
Great resources available for upgrading your databases from 2000 or 2005: http://www.microsoft.com/sqlserver/2008/en/us/upgrade.aspx As with all major upgrades an upgrade to SQL Server 2008 R2 should be fully tested before upgrading your production database. While it isn’t likely that there will be a problem, it is possible.
View Answer
| May 7, 2010 6:26 AM
SQL Server 2000, SQL Server 2000 to SQL Server 2008 R2, SQL Server 2008 R2, SQL Server Upgrade
Great resources available for upgrading your databases from 2000 or 2005: http://www.microsoft.com/sqlserver/2008/en/us/upgrade.aspx As with all major upgrades an upgrade to SQL Server 2008 R2 should be fully tested before upgrading your production database. While it isn’t likely that there will be a problem, it is possible.
View Answer
| May 7, 2010 6:26 AM
SQL Server 2000, SQL Server 2000 to SQL Server 2008 R2, SQL Server 2008 R2, SQL Server Upgrade
Do I need to remove SQL Server 2005 to install SQL Server 2008 R2?
No – you can do an in place upgrade directly from SQL Server 2005 to SQL Server 2008 As with any database server upgrade you should test your application against the new database version before upgrading to ensure that the application works correctly with the new version. While it isn’t likely that there will be [...]
View Answer
| May 7, 2010 6:15 AM
SQL Server 2005, SQL Server 2005 to SQL Server 2008 R2 Upgrade, SQL Server 2008 R2, SQL Server 2008 R2 installation
No – you can do an in place upgrade directly from SQL Server 2005 to SQL Server 2008 As with any database server upgrade you should test your application against the new database version before upgrading to ensure that the application works correctly with the new version. While it isn’t likely that there will be [...]
View Answer
| May 7, 2010 6:15 AM
SQL Server 2005, SQL Server 2005 to SQL Server 2008 R2 Upgrade, SQL Server 2008 R2, SQL Server 2008 R2 installation
Performance benchmarks for SQL Server 2008 R2
http://www.microsoft.com/sqlserver/2008/en/us/benchmarks.aspx
View Answer
| May 6, 2010 8:26 PM
SQL Server 2008 R2, SQL Server 2008 R2 Performance Monitoring, SQL Server Performance Monitoring
http://www.microsoft.com/sqlserver/2008/en/us/benchmarks.aspx
View Answer
| May 6, 2010 8:26 PM
SQL Server 2008 R2, SQL Server 2008 R2 Performance Monitoring, SQL Server Performance Monitoring
SQL Server 2008 R2 provides direct integration with Oracle Database
For SQL Server 2008 R2 Business Intelligence…we provide direct connections to a variety of datasources (Oracle, Teradata, SQL Azure, etc.) directly from PowerPivot for Excel and Report Builder 3.0.
View Answer
| May 6, 2010 8:21 PM
Oracle Database, SQL Server 2008 R2, SQL Server 2008 R2 and Oracle, SQL Server 2008 R2 Features, SQL Server 2008 R2 Integration
For SQL Server 2008 R2 Business Intelligence…we provide direct connections to a variety of datasources (Oracle, Teradata, SQL Azure, etc.) directly from PowerPivot for Excel and Report Builder 3.0.
View Answer
| May 6, 2010 8:21 PM
Oracle Database, SQL Server 2008 R2, SQL Server 2008 R2 and Oracle, SQL Server 2008 R2 Features, SQL Server 2008 R2 Integration
SQL Server 2008 R2 fully supported by Visual Studio Team Database 2008 or 2010?
In general yes – both are supported. But specific features like Data-Tier applications require VS2010.
View Answer
| May 6, 2010 8:18 PM
SQL Server 2008 R2, SQL Server 2008 R2 Benefits, Visual Studio 2010, visual studio team Database 2008
In general yes – both are supported. But specific features like Data-Tier applications require VS2010.
View Answer
| May 6, 2010 8:18 PM
SQL Server 2008 R2, SQL Server 2008 R2 Benefits, Visual Studio 2010, visual studio team Database 2008
Can you explain Master Data Services
Master Data Services (MDS) is a Master Data Management (MDM) application built from platform components which may be deployed as an application or extended by use of the platform components to consistently define and manage the critical data entities of an organization. MDS is an ‘any domain’ hub that supports (but is not limited to) [...]
View Answer
| May 6, 2010 8:14 PM
Master Data Services, SQL Server 2008 R2, SQL Server 2008 R2 Features
Master Data Services (MDS) is a Master Data Management (MDM) application built from platform components which may be deployed as an application or extended by use of the platform components to consistently define and manage the critical data entities of an organization. MDS is an ‘any domain’ hub that supports (but is not limited to) [...]
View Answer
| May 6, 2010 8:14 PM
Master Data Services, SQL Server 2008 R2, SQL Server 2008 R2 Features
BACKUP in SQL SERVER
Ah, test questions got to love them. A. Reducing the amount of time between log backups will reduce the size that the log grows. B. You always want the smallest transaction size (I’m assuming that is what you are talking about here) do reduce database locking. Reducing transaction size won’t reduce the size of the [...]
View Answer
| May 6, 2010 4:06 PM
SQL Server backup, SQL Server logs
Ah, test questions got to love them. A. Reducing the amount of time between log backups will reduce the size that the log grows. B. You always want the smallest transaction size (I’m assuming that is what you are talking about here) do reduce database locking. Reducing transaction size won’t reduce the size of the [...]
View Answer
| May 6, 2010 4:06 PM
SQL Server backup, SQL Server logs
SQL Server 2005 Express SP3 Memory Usage
That is the way SQL Server is designed to use. The SQL Server caches as much data from the disk into memory as the data is being used so that it has faster access to it. If you connect to the SQL Server with Management Studio (regular or Express) and use sp_configure you can set [...]
View Answer
| May 6, 2010 4:01 PM
SQL Server 2005, SQL Server 2005 Express, SQL Server memory, SQL writer
That is the way SQL Server is designed to use. The SQL Server caches as much data from the disk into memory as the data is being used so that it has faster access to it. If you connect to the SQL Server with Management Studio (regular or Express) and use sp_configure you can set [...]
View Answer
| May 6, 2010 4:01 PM
SQL Server 2005, SQL Server 2005 Express, SQL Server memory, SQL writer
How many processors can SQL Server 2008 R2 support?
SQL Server Datacenter Edition can support up to 256 logical processors when deployed on Windows Server 2008 R2. Standard Edition can support 4 physical CPUs, and Enterprise can support 8 Physical processors. Workgroup Edition can support 2 physical CPUs, and SQL Express can support 1 physical CPUs.
View Answer
| May 6, 2010 1:14 AM
SQL Server 2008 R2, SQL Server 2008 R2 Features, SQL Server 2008 R2 Processors
SQL Server Datacenter Edition can support up to 256 logical processors when deployed on Windows Server 2008 R2. Standard Edition can support 4 physical CPUs, and Enterprise can support 8 Physical processors. Workgroup Edition can support 2 physical CPUs, and SQL Express can support 1 physical CPUs.
View Answer
| May 6, 2010 1:14 AM
SQL Server 2008 R2, SQL Server 2008 R2 Features, SQL Server 2008 R2 Processors
What sort of connections are there to SharePoint in SQL Server 2008 R2?
Reporting Services integration to SharePoint has been enhanced with the SQL Server 2008 R2 release to provide more seamless interoperability with SharePoint for report access, collaboration and management…plus the use of SharePoint Lists as data sources for reporting. PowerPivot for SharePoint provides the ability to easily share PowerPivot for Excel Workbooks into a PowerPivot Gallery [...]
View Answer
| May 5, 2010 8:18 PM
SharePoint, SQL Server 2008 R2
Reporting Services integration to SharePoint has been enhanced with the SQL Server 2008 R2 release to provide more seamless interoperability with SharePoint for report access, collaboration and management…plus the use of SharePoint Lists as data sources for reporting. PowerPivot for SharePoint provides the ability to easily share PowerPivot for Excel Workbooks into a PowerPivot Gallery [...]
View Answer
| May 5, 2010 8:18 PM
SharePoint, SQL Server 2008 R2
Help with Data Quality
Microsoft recognizes Data Quality and authoritative data management as key components of an enterprise information management strategy. With the acquisition of Zoomix, Microsoft is actively pursuing a data quality strategy that will integrate across Integration Services, Master Data Services, and the recently announced project Dallas – an authoritative public data store in the cloud, compatible [...]
View Answer
| May 5, 2010 8:16 PM
Data quality, Data quality tools, SQL Server 2008 R2, SQL Server Data Quality
Microsoft recognizes Data Quality and authoritative data management as key components of an enterprise information management strategy. With the acquisition of Zoomix, Microsoft is actively pursuing a data quality strategy that will integrate across Integration Services, Master Data Services, and the recently announced project Dallas – an authoritative public data store in the cloud, compatible [...]
View Answer
| May 5, 2010 8:16 PM
Data quality, Data quality tools, SQL Server 2008 R2, SQL Server Data Quality
Hardware requirements for SQL Server 2008 R2
This is currently provided with the trial version: http://www.microsoft.com/downloads/details.aspx?FamilyID=54ad6107-c552-4d47-b1a1-3f66460f71a9&displaylang=en
View Answer
| May 5, 2010 8:14 PM
SQL Server 2008 R2, SQL Server 2008 R2 Hardware Requirements, SQL Server 2008 R2 Resource Kits
This is currently provided with the trial version: http://www.microsoft.com/downloads/details.aspx?FamilyID=54ad6107-c552-4d47-b1a1-3f66460f71a9&displaylang=en
View Answer
| May 5, 2010 8:14 PM
SQL Server 2008 R2, SQL Server 2008 R2 Hardware Requirements, SQL Server 2008 R2 Resource Kits
Advantage of SQl Server 2008 R2 vs Oracle
* Offers a unique approach to BI, connecting back-end database to front office through PowerPivot in a managed way. * The on premise to cloud offering is available today, and is not just a vision. * Offers the most comprehensive DBMS on the market (BI, manageability features, OLTP, in-memory analytics, etc.) and offers functionality out [...]
View Answer
| May 5, 2010 8:13 PM
Oracle, SQL Server 2008 R2, SQL Server 2008 R2 Benefits
* Offers a unique approach to BI, connecting back-end database to front office through PowerPivot in a managed way. * The on premise to cloud offering is available today, and is not just a vision. * Offers the most comprehensive DBMS on the market (BI, manageability features, OLTP, in-memory analytics, etc.) and offers functionality out [...]
View Answer
| May 5, 2010 8:13 PM
Oracle, SQL Server 2008 R2, SQL Server 2008 R2 Benefits
Desiging UCP Environments in SQL Server 2008 R2
* supports the 2008 platform only * With an EE license each UCP can support 25 instances, consider grouping instances by a common “theme” or type (i.e. web apps or finance apps) * Administrator privilege is needed to set up the UCPor access, vs. privilege MORE HERE: * With an EE license each UCP can [...]
View Answer
| May 5, 2010 8:11 PM
SQL Server 2008 R2, UCP Environment
* supports the 2008 platform only * With an EE license each UCP can support 25 instances, consider grouping instances by a common “theme” or type (i.e. web apps or finance apps) * Administrator privilege is needed to set up the UCPor access, vs. privilege MORE HERE: * With an EE license each UCP can [...]
View Answer
| May 5, 2010 8:11 PM
SQL Server 2008 R2, UCP Environment
Editions of SQL Server
New editions introduced with SQL Server 2008 R2 are the Datacenter Edition which delivers a high-performing data platform that provides the highest levels of scalability for large application workloads, virtualization and consolidation, and managing the infrastructure. (ex. Unlimited Virtualization, Multi-Server Management for more than 25 instances, CEP support for >5000 events/sec, up to 256 logical [...]
View Answer
| May 5, 2010 8:10 PM
SQL Server 2008 R2, SQL Server availability, SQL Server Version Comparison
New editions introduced with SQL Server 2008 R2 are the Datacenter Edition which delivers a high-performing data platform that provides the highest levels of scalability for large application workloads, virtualization and consolidation, and managing the infrastructure. (ex. Unlimited Virtualization, Multi-Server Management for more than 25 instances, CEP support for >5000 events/sec, up to 256 logical [...]
View Answer
| May 5, 2010 8:10 PM
SQL Server 2008 R2, SQL Server availability, SQL Server Version Comparison
What is PowerPivot?
Two technologies: PowerPivot for Excel= Free add-in to Microsoft Excel 2010. PowerPivot for SharePoint=allows for publishing, access and management of apps directly in SharePoint. PowerPivot for Excel is an free Excel Add-in that allows you to easily access data from diverse data sources, easily mashup data within Excel, process large volumes of data (millions to [...]
View Answer
| May 5, 2010 8:09 PM
Powerpivot, SQL Server 2008 R2, SQL Server 2008 R2 Features
Two technologies: PowerPivot for Excel= Free add-in to Microsoft Excel 2010. PowerPivot for SharePoint=allows for publishing, access and management of apps directly in SharePoint. PowerPivot for Excel is an free Excel Add-in that allows you to easily access data from diverse data sources, easily mashup data within Excel, process large volumes of data (millions to [...]
View Answer
| May 5, 2010 8:09 PM
Powerpivot, SQL Server 2008 R2, SQL Server 2008 R2 Features
Visual Studio 2010 to edit DAC Packs in SQL Server 2008 R2
Yes. You will need Visual Studio 2010 to edit DAC Packs. Data-Tier Applications is a new project type within Visual Studio 2010.
View Answer
| May 5, 2010 8:05 PM
DAC, Data Tier Applications, SQL Server 2008 R2, Visual Studio 2010
Yes. You will need Visual Studio 2010 to edit DAC Packs. Data-Tier Applications is a new project type within Visual Studio 2010.
View Answer
| May 5, 2010 8:05 PM
DAC, Data Tier Applications, SQL Server 2008 R2, Visual Studio 2010
Impact of Statature with Release of SQL Server
The acquisition of Stratature has enabled us to include Analytical Master Data Management capabilities in the SQL Server 2008 R2 release via the Master Data Services technology.
View Answer
| May 5, 2010 8:04 PM
Add new tag, SQL Server 2008 R2, Stratature
The acquisition of Stratature has enabled us to include Analytical Master Data Management capabilities in the SQL Server 2008 R2 release via the Master Data Services technology.
View Answer
| May 5, 2010 8:04 PM
Add new tag, SQL Server 2008 R2, Stratature
