Microsoft SQL Server 2008 CTP, February 2008

SQL Server 2008 February CTP
hii installed SQL Server 2008 February CTP  but i cannot found SQL Server Management Studio for 2008 i also try to connect through SQL Server 2005  Management Studio Express but error message "You can only connect with 2000 or 2005". So if i want to learn 2008 How???????

View Replies !   View Related

---

Can I Run SQL Server 2008 - Reporting Services CTP Until Microsoft Sells SQL 2008
There are a few features in the new SQL Server - Reporting Services that I really need in production.   I have tested everything and it works great.  I am running the CTP version since Microsoft is saying they aren't releasing the release version until 3rd quarter 2008.
 
 
Since Microsoft won't sell SQL 2008 until 3rd quarter, can I run the CTP in production until the release and then purchase SQL 2008?
 
 
Jim
 

View Replies !   View Related

---

SQL Server Express 2008 February CTP Is Available
 

The main information page for the February CTP is at http://www.microsoft.com/sql/2008/prodinfo/download.mspx. You can download SQL Express 2008 directly from the download center at http://www.microsoft.com/downloads/details.aspx?FamilyID=749bd760-f404-4d45-9ac0-d7f1b3ed1053&DisplayLang=en.
 
Regards,
Mike Wachal
SQL Express team

View Replies !   View Related

---

Problem With Windows Server 2008 And SQL 2008 Express
Hello!
Recently, I set up server with Windows Web Server 2008 RC1, SQL 2008 Express beta, .NET 3.5, IIS 7.
I'm running ASP.NET web application with SQL database. Everything works fine until the first application state on the server expires. After that, any postback that starts a new application state on the server and connects to the database, results in the following error:
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
Is this a bug that will be fixed in release of Windows / SQL or am I doing something wrong?
Many thanks for help,
Jan

View Replies !   View Related

---

Microsoft OLE DB Provider For Oracle 64-Bit, SQL Server 2008: Does It Exist?
 

Does anyone know if the "Microsoft OLE DB Provider for Oracle" in 64-Bit Windows exists in SQL Server 2008 64-bit?  It only existed in 32-bit SQL 2005,  which was a big problem.    Needed for Linked Server creation.  We do not want to use OPENQUERY calls with the native Oracle 10G driver,  too many coding changes.
 
Thank You

View Replies !   View Related

---

Difference Between Microsoft Sql Server 2008 And Microsoft Sql Server 2005
 

Pls tell me about the adjact difference between sql server 2005 and sql server 2008.
Why to upgrade for Sql Server 2008

View Replies !   View Related

---

Seeking Advice: SQL Server On Win 2008 Virtual Server Or Just Win 2008?
 

Hello - does anyone have experience w/SQL Server 2005 in a virtual environment? I'm considering this for a production environment but not sure if performance will suffer. Our databases will have a lot of writing but not too much reading. A SSRS solution is currently the only app. connecting to the SQL db. Max users to server at any given time will be very low (~10 users max). But the databases are pulling in data from other, outside multiple data sources on a daily basis.
 
Any pointers to documentation or any advice?
 
Thanks,
 
A Brown

View Replies !   View Related

---

Installing Microsoft Dynamics 10.0 With Microsoft SQL Server 2008 &&"Katmai&&"
 

Hi,
 
I'm trying to install Microsoft Dynamics 10.0 with SQL 2008 Dev but when launching the utilities this returns the following error message:
 
******************************************************************
Your current SQL Server is not a supported version.
 
Req: Microsoft SQL Server 8.0
Act: Microsoft SQL Server code name "Katmai" (CTP) - 10
 
You need to upgrade to SQL Server 8.0 before continuing.

******************************************************************
 
Any ideas could help or has this if anyone knows been desinged not to work with GP10 currently?
 
Assad

View Replies !   View Related

---

Sqlserver 2008 Can't Work With Visual Studio 2008
when I try to make a sqldatasource with visual studio 2008 and SQLServer 2008 . I found that there are a message that the visual studio 2008 can support only SQLServer 2005 and SQLServer 2000how to make my visual studio 2008 support SQLServer 2008 

View Replies !   View Related

---

SQL Compact Edition 3.5 Vs. SQL Server Management Studio 2008, FileNotFoundException Microsoft.SqlServerCe.ManagementUI
Hi,I'm having an exception below when i tried to connect to SQL Server Compact Edition from SQL Server Management Studio (10.0.1075.23 ((SQL_PreRelease).071108-1357 )).I downloaded and installed the SQL Server Compact Edition 3.5 from this link below :http://www.microsoft.com/downloads/details.aspx?FamilyID=38ed2670-a70a-43b3-87f3-7ab67b56cbf2&displaylang=enAnd I downloaded and installed the SQL Server 2008 Development edition from this link below :http://go.microsoft.com/fwlink/?LinkId=104963It seems that the SQL Server 2008 Development edition comes with the these 2 SQL CE below :- Microsoft SQL Server Compact 3.5 SP1 Beta ENU. Product Version: 3.5.5608.0.- Microsoft SQL Server Compact 3.5 SP1 Beta Management Tools ENU. Product Version: 3.5.5608.0I tried to uninstalled these 2 and re-install the SQL Server Compact Edition 3.5 Files, but it didn't help.Currently I'm uninstalling SQL Server 2008 because the command prompt installation instruction page could not be found in the books online, so i'm trying my luck to uninstall SQL Server Compact Edition 3.5 and reinstall the whole SQL Server 2008. The main reason why I was trying to install SQL Server 2008 Developer Edition is only to manage SQL Server Compact 3.5 database file. Since i upgraded the database into 3.5, i was not able to open it anymore using SQL Express 2005 Query Designer in the VS 2008 is just like the sql view query designer which is not as good as sql management studio. I'm reminiscing the good old days with query analyzer Any advice to resolve this issue?
Thanks in advance Steps :1. Choose Database : SQL Server Compact Edition2. Choose Any of the Database file options (New Database or Browse for more)3. Below exception will pop up.See the end of this message for details on invokingjust-in-time (JIT) debugging instead of this dialog box.************** Exception Text **************System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServerCe.ManagementUI, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.File name: 'Microsoft.SqlServerCe.ManagementUI, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'   at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)   at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)   at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)   at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)   at System.Reflection.Assembly.Load(String assemblyString)   at Microsoft.SqlServer.Management.UI.ConnectionDlg.Utils.LoadAssembly(String assemblyFileName)   at Microsoft.SqlServer.Management.UI.ConnectionDlg.SqlServerCeType.Microsoft.SqlServer.Management.UI.ConnectionDlg.IServerType2.CustomNewDatabaseAction()   at Microsoft.SqlServer.Management.UI.ConnectionDlg.LoginControl.CheckForNewDatabase()   at Microsoft.SqlServer.Management.UI.ConnectionDlg.LoginControl.OnSIIndexChange(Object sender, EventArgs e)   at System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs e)   at System.Windows.Forms.ComboBox.WmReflectCommand(Message& m)   at System.Windows.Forms.ComboBox.WndProc(Message& m)   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

View Replies !   View Related

---

Windows Vista Business 64 And Microsoft Visual Basic 2008 Express Edition Bad Sqlceme35.dll
I watched and followed the Intro to VB 2008 Express, but in the final part of the video, when you add a database, i did everything as the video says, still i get:

An error occurred creating the form. See Exception.InnerException for details.  The error is: Unable to load DLL 'sqlceme35.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)

Ive tried the fix stated in another forum, the one about changing the "Target CPU" but the option doesn appear, what does appear its the "Platfrom" dropdown list, but its fixed to "Any CPU" and dont have any more options.

Ive also downloaded Microsoft SQL Server Compact 3.5 ENU and "re-installed" and selected repair, followed the steps, rebooted and still nothing.

The problem persists, any ideas, please?

View Replies !   View Related

---

MS SQL Server 2008 RC0
Hello all,
I just wanted to share my happiness with the Microsoft's release of the new version of SQL Server 2008, MS SQL Server 2008 RC0.
You can download and install the evaluation versions from Microsoft Downloads.
http://download.microsoft.com/download/2/0/c/20cf6e18-0448-4e7b-8d8c-60a3c4802671/Download_Instructions_ENU.htm
 
I liked the new logo very much! 
 
 
Eralper
MS SQL Server Articles
 

View Replies !   View Related

---

Sql Server 2008
I just downloaded the SQL Server 2008 CTP. Anyone here check it outyet? Thoughts?

View Replies !   View Related

---

SQL Server 2008 Available In CTP
The best mail today was, witout doubt, the one from Grant Dickinson at Microsoft telling that SQL Server 2008 June CTP is available from the SQL Server (http://www.microsoft.com/sql/prodinfo/futureversion/default.mspx) pages at Microsoft. :)

It's time to play. :cool:

View Replies !   View Related

---

SQL Server 2008
Hello,

I just installed SQL Server 2008, i'm not certain if I am missing a step or theory...

just ran a simple command:
USE master
GO

For some reason, the process simply keeps on running.
Correct or incorrect statement, the results shouldnt appear any longer than a few seconds...

Does anyone know why this is taking a lot longer than it should?

View Replies !   View Related

---

Sql Server 2008
I pray I am in the right forum.
 
I went to MSDN Products Keys and Downloads and found that they offer Sql Server 2008 as a free download for MSDN Pro subscribers. At least this is my inpression as to what is going on. I think it comes on 4 or 5 DVDs.
 
I am using Sql Server Express Edition with Advanced Features. I want to be honest and say that I most likely do not use these "advanced features" because of the nature of my work. I do not have this customer/product canonical setup. I store numerical data as well as stocks info. It is all for myself. I understand that the "advanced features" include reporting services but so far I have never used them.
 
This is my dilemma. I want to stay abreast with the progress and use the most current software. If I download the full SqlServer it will kill my machine with the enormous surface area. I do not need even systems databases, let alone Nowthwind. I create my onw DBs.
 
Do they have an equivalent of Sql Server Express for 2008?
 
What would you advice me to do?
 
Thanks.

View Replies !   View Related

---

SQL Server 2008 CTP
Katmai becomes "Microsoft SQL Server 2008 I dont know dose people know about it? Never mind, I hope

this cool link will make you hapy:

https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5395

 

The name for the next release of SQL Server becomes "Microsoft SQL Server 2008" which has been

code-named as SQL Server "Katmai". The first public CTP of Katmai will be available for download from

 http://connect.microsoft.com/sqlserver. Download link will be live on 2007.06.04 Monday morning at

8:30am EST.

 

PS: Becuse I did not find any SQL Katmai forum group I post it here. Hope you dont mind.

View Replies !   View Related

---

Sql Server 2008
 Anyone here aware of  Sql Server 2008 RTM availability date.

View Replies !   View Related

---

SQL Server 2008
I would like to buy SQL server 2008 book. I need it badly. would you please tell me where I can find it? thanks. and I look forward to hearing from you as soon as possible.

thanh

View Replies !   View Related

---

VS 2008 And SQL Server Express
I was wondering if this is normal. I am creating a website in VS 2008. I created a SQL db and am using SQL server express.
I can go into SQL server managment studio express and open the DB when I start my PC. I can still access the DB when I start VS 2008 and my project but when I run the project I can not access the DB any longer even when the project is not longer running and I'm in design mode. Even if I close VS 2008 I still cannot access DB through SQL server managment. The only way I can access the DB again is if I restart my PC.
Is this normal?
I am running Vista Ultimate.
Thanks,
Ty

View Replies !   View Related

---

Has SQL Server 2008 Been Released?
Has SQL Server 2008 been released already? If not, what is the expected date?

View Replies !   View Related

---

DTS.Pipeline.1 In SQL Server 2008
Hi
 
I have an existing application that programmatically builds SSIS 2005 packages.
 
I'm trying to get to working with the February CTP of SQL Server 2008. Having changed all the 2005 references to 2008 references and things like IDTSComponentMetaData90 to IDTSComponentMetaData100, my application compiles okay now, but hits a problem when it tries to create a Data Flow task.
 
The code which worked fine before (and seems to still be the recommended way in Books Online is):
 



Code Snippet
 
Dts.TaskHost myMainPipe = (Dts.TaskHost)container.Add("DTS.Pipeline.1");
 
 



However, this now produces the exception:
 

Cannot create a task with the name "DTS.Pipeline.1". Verify that the name is correct.
 
Should I be using a different moniker now? I took a stab at "DTS.Pipeline.2", but that didn't make a difference.
 
Thanks,
Andrew

View Replies !   View Related

---

SSIS In SQL Server 2008...
 
 Does anyone know if the SSIS packages developed in SQL Server 2005 is compatible with SQL Server 2008? What are the new features in SQL Server 2008 ETL layer? Thanks in Advance.

View Replies !   View Related

---

SSIS In Sql Server 2008
Have noticed some issues in Sql Sever 2005 SSIS configuration, as documented in the forums here.
Does Sq; Server 2008's SSIS config still have these problems, or is it more stable? : ) 

View Replies !   View Related

---

When Will SQL Server 2008 Be Released?
EOM

View Replies !   View Related

---

Sql Server 2008 Katmai
hi..
 
am trying the new sql server 2008 katmai and i have an existing sql server 2005 express edition on my other pc..
 
my problem is sql server 2008 can register  a new server to sql server express cannot register to the sql 2008
 
any inputs?
 
thanks

View Replies !   View Related

---

SQL Server 2008 Documentation
Hi,

    Can you please tell me links to SQL Server 2008 documentation on MSDN? I read SQL Server 2008 CTP is released today. I'm very much interested to know more about it. Thanks in advance.

 

Cheers,

Gopi

mgopinath.blogspot.com

View Replies !   View Related

---

Sql Server 2008 Report
Hi all,
 
I installed the Microsoft Report Viewer Redistributable 2008 and the microsoft.reportviewer.winforms.dll  does not apperas anywhere on my computer, do you know where the dll is located, I've been searched for it and nothing yet!
 
Would you please send a copy of dll file to me?
 
Thanks,
Ashok
 
 

View Replies !   View Related

---

Sql Server 2008 Report
Hi all,
 
How can I get this file ?
Microsoft.ReportViewer.ProcessingObjectModel.dll
Microsoft.ReportViewer.Common.dll
Microsoft.ReportViewer.WinForms.dll

I read many articles which say to run the ReportViewer.exe redistributable 2008. That does not install the DLL on my PC.

Anyone has a link or could email me the file ..
 
Thanks,
Ashok
 

View Replies !   View Related

---

What’s New In SQL Server 2008
What’s new in SQL Server 2008

SQL Server 2008 will be released in 2nd quarter of 2008. SQL Server 2008 will also be part of a joint launch with Windows Server 2008 and Visual Studio 2008 on February 27, 2008 in Los Angeles, CA. If you are interested in SQL Server 2008, you can download the latest CTP today.Here is a list of some of the new features available (excerpts from Microsoft’s white paper)

Transparent Data Encryption

SQL Server 2008 enables encryption of entire databases, data files, and log files, without the need for application changes. Encryption enables organizations to meet the demands of regulatory compliance and overall concern for data privacy. Some of the benefits of transparent data encryption include searching encrypted data using either range or fuzzy searches, more secure data from unauthorized users, and data encryption. These can be enabled without changing existing applications.

External Key Management

SQL Server 2008 provides a comprehensive solution for encryption and key management. To meet the growing need for greater security of information within data centers, organizations have invested in vendors to manage security keys within the enterprise. SQL Server 2008 provides excellent support for this need by supporting third-party key management and hardware security module (HSM) products.

Enhanced Auditing

SQL Server 2008 improves compliance and security by allowing you to audit activity on your data. Auditing can include information about when data has been read, in addition to any data modifications. SQL Server 2008 has features such as enhanced configuration and management of audits in the server, which enable organizations to meet varied compliance needs. SQL Server 2008 can also define audit specifications in each database, so audit configuration can be ported with databases. Filtering of audits to specific objects allows better performance in audit generation and flexibility in configuration.

Enhanced Database Mirroring

Automatic page repair. SQL Server 2008 enables the principal and mirror computers to transparently recover from 823 and 824 errors on data pages by requesting a fresh copy of the corrupted page from the mirroring partner.
Improved performance. SQL Server 2008 compresses the outgoing log stream in order to minimize the network bandwidth required by database mirroring.
Enhanced supportability
SQL Server 2008 includes additional performance counters to enable more granular accounting of the time spent across the different stages of Database Management System (DBMS) log processing.
SQL Server 2008 includes new Dynamic Management Views and extensions of existing views to expose additional information about mirroring sessions.
Hot Add CPU

Extending existing support in SQL Server for adding memory resources online, Hot Add CPU allows a database to be scaled on demand. In fact, CPU resources can be added to SQL Server 2008 on supported hardware platforms without requiring application downtime.

Performance data collection

Performance tuning and troubleshooting are time-consuming tasks for the administrator. To provide actionable performance insights to administrators, SQL Server 2008 delivers more extensive performance data collection, a new centralized data repository for storing performance data, and new reporting and monitoring tools.

Extended Events

SQL Server Extended Events is a general event-handling system for server systems. The Extended Events infrastructure is a lightweight mechanism that supports capturing, filtering, and acting upon events generated by the server process. This ability to act upon events allows users to quickly diagnose run time problems by adding contextual data, such as Transact SQL call stacks or query plan handles, to any event. Events can be captured into several different output types, including Event Tracing for Windows (ETW). When Extended Events are output to ETW, correlation with operating system and database applications is possible, allowing for more holistic system tracing.

Backup compression

Keeping disk-based backups online is expensive and time consuming. With SQL Server 2008 backup compression, less disk I/O is required, less storage is required to keep backups online, and backups run significantly faster.

Data compression

Improved data compression enables data to be stored more effectively and reduces the storage requirements for your data. Data compression also provides significant performance improvements for large input/output-bound workloads such as data warehousing.

Resource Governor

SQL Server 2008 enables organizations to provide a consistent and predictable response to end users with the introduction of Resource Governor. Resource Governor enables database administrators to define resource limits and priorities for different workloads, which enables concurrent workloads to provide consistent performance to end users.

Plan Freezing

SQL Server 2008 enables greater query performance stability and predictability by providing new functionality to lock down query plans, enabling organizations to promote stable query plans across hardware server replacements, server upgrades, and production deployments.

[url=http://blog.360.yahoo.com/blog-U6QwcZ0gavd_Vlnx6XULPcA1?p=75]Msdes[/url]
[url=http://www.bloglines.com/blog/Asia-Registration?id=8]Fexon[/url]
[url=http://journals.aol.com/mamaliya/AsiaDomainNameRegistrationLi/]Asia[/url]

View Replies !   View Related

---

SQL Server Express 2008
Hello,

Does anyone knows if SQL Server Express 2008 is already available for download? Where can I get it?

Thanks,
Miguel

View Replies !   View Related

---

Sql Server 2008 Download
Dear All,
is there any free download of sql server 2008 download avialable in the net?

i've googled a lot.....it is taking to the download of sql server 2008 CTP.....even after downloading finished, i'm getting error while installing error...
the error is kernel32.dll

please provide me links


Vinod
Even you learn 1%, Learn it with 100% confidence.

View Replies !   View Related

---

Dumping The Transaction Log In SQL Server 2008
In SQL Server 2005 I used to
dump tran MyDatabaseName with no_logDBCC SHRINKDATABASE ('MyDatabaseName')
This syntax is not valid in SQL server 2008.What is the correct syntax or is there a better way to dump the transaction immediately?
Thanks

View Replies !   View Related

---

SQL Manager 2008 For SQL Server Released
Lots of new pain easing tools to work with SQL Server, Activity Monitor, Unicode support and much more…
http://www.sqlmanager.net/en/news/ems/1294

View Replies !   View Related

---

Query Plan SQL Server 2008
I have a person table with 1 billion rows on it, partitioned equally at 10 million rows per partition. The primary key constraint is a composite of an identity column and ssn( char(11) ) with the partitioning column built on the SSN.

 

This is built on my home grown workstation:

Microsoft 2008 Server 64 bit, Microsoft SQL server 2008 64 bit, Intel 2.66 quad core, 8 gb ram, Os/ raid 1, data on 6 drives hardware/software raid 50, transaction logs on 4 drive raid 10, all drives sata II/ 3gb burst.

 

I have updated statistics on the table and I have 2 queries that give clustered index seek , one never comes back before I get impatient, the other comes back instantly, and the showplan looks the same for both queries.

 

SELECT *

FROM Person

WHERE PersonKey > -1 and SSN = '219-09-3987'

 

AND

 

SELECT TOP 100 PERCENT *

FROM Person

WHERE PersonKey > -1 and SSN = '219-09-3987'

 

Incidentally the query with the top 100 percent is the one that returns instantly.

 

I am puzzled

1) Why the estimated plan looks the same

2) Why a top 100 Percent query is faster than one without it

 

Timothy A. Vanover
 
 

View Replies !   View Related

---

Announcing SQL Server 2008 CTP6
 

SQL Server 2008 CTP6 has been announced. You can download and evaluate it from here https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5395.
 
Also, check out here https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=7734 on how to win a x-box by participating in the SQL server bug bash.
 
thanks,
Jun

View Replies !   View Related

---

Windows Server 2008 - Firewall
 

Hello,
 
I have purchased 4 new boxes for SQL2005 and my var database product all running on the new Windows 2008 server. A lot of silly mind bender issues but I am up and live now. However, what should the firewall settings be on my SQL database box? I have ultimately turned off Windows Firewall so that I could connect and continue forward.
 
Thanks!
 
Chris

View Replies !   View Related

---

Closure On SQL Server 2008 CTP Issue
Thank you to everyone for suspending any SQL Server 2008 service restarts and install/upgrades during the 24 hour period of February 29 2008 (GMT).   We appreciate your patience during this time.
 
Summary:
·         The window of opportunity to experience this bug, February 29 2008 GMT, has passed.
·         We have confirmed that this bug no longer occurs on servers running to accurate local time.
·         There is no further need to apply the workarounds previously recommended to deal with this issue.
·         The SQL Server development team has identified the appropriate fix which has been checked in to the main SQL Server 2008 code.
 
Thank you again for your work and patience; we appreciate your partnership with us.

View Replies !   View Related

---

SQL Server Express 2008 Will Not Start
I have installed the November CTP of SQL Server Express 2008 but the service will not start.  The error log displays the following error which implies that it is trying to open a file on by CD/DVD drive.  I have checked the service properties and all the parameters point to c:
 
Any idea why it is looking at e:?  Where do I change this?

 
 
    Starting up database 'mssqlsystemresource'.
2007-12-16 09:46:43.82 spid7s      Error: 17204, Severity: 16, State: 1.
2007-12-16 09:46:43.82 spid7s      FCB:pen failed: Could not open file e:sql10_main_tsqlmkmastrobjfrei386mssqlsystemresource.mdf for file number 1.  OS error: 21(error not found).
2007-12-16 09:46:43.85 spid7s      Error: 5120, Severity: 16, State: 101.

View Replies !   View Related

---

What Are New In SQL Server 2008 Database Engine?
Hi, all here,

 

Just heard about the coming release of SQL Server 2008. Anyone here got some ideas on what are significant new features in SQL Server 2008 Database Engine compared to SQL Server 2005 Database Engine? Would be very interesting to know that.

 

Thanks.

 

With best regards,

 

Yours sincerely,

 

 

View Replies !   View Related

---

Cross-validation In SQL Server 2008
  Hi, can someone please explain some more how to use cross-validation in SQL Server 2008 (CTP)? I read here that it "is under Accuracy Charts in Business Intelligence Development Studio, in addition to being accessible programmatically via a stored procedure call". What is the stored procedure and input parameters?
  I'm actually interested in doing so inside an Integration Services package, in a data flow task.

Thanks,
Gustavo Frederico

View Replies !   View Related

---

SQL Manager 2008 For SQL Server Released
SQL Manager 2008 for SQL Server released
Lots of new pain easing tools to work with SQL Server, Activity Monitor, Unicode support and much more:
http://www.sqlmanager.net/en/news/ems/1294

View Replies !   View Related

---

Difference Between Sql Server 2005 And 2008
 

Hi,
 
do any body know the article that can give me berif idea about the difference between sql server 2005 and 2008, acutally i want to move over to 2008. but if the difference is not that much then i m might think about that.
 
 
Thanks and looking forward.
 

View Replies !   View Related

---

SQL Server 2008 CTP Feb With Compact 3.5 - Can't Connect
I need to be able to manage my Compact 3.5 database (script tables, edit columns etc).
 
As far as I understood, only way to do this is to install SQL Server 2008 CTP. So I did that, installed the February release. But when I try to connect to my Compact 3.5 database, I get this error:
Cannot connect to %path to my db%
Could not load file or assembly 'Microsoft.SqlServerCe.Client, Version 10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' ...'
 
Any ideas?
 
Or do anyone know an other way to handle Compact 3.5 databases?
 

View Replies !   View Related

---

Expres 2005 And VM In Server 2008
 

Hello,
I can't reach the SQL server 2005 Express installation in a VM of Windows Server 2008 from the PC's.
In the VM i can manage the instance with Management Studio Express.
Also I can reach directories on the VM from the PC's.
Where is my problem ?
Thank you for help.

View Replies !   View Related

---

SQL Server 2008 Product Overview
Overview






Your Data, Any Place, Any Time

SQL Server 2008 delivers on Microsoft€™s Data Platform vision by helping your organization manage any data, any place, any time. It enables you to store data from structured, semi-structured, and unstructured documents, such as images and music, directly within the database. SQL Server 2008 delivers a rich set of integrated services that enable you to do more with your data such as query, search, synchronize, report, and analyze. Your data can be stored and accessed in your largest servers within the data center all the way down to desktops and mobile devices, enabling you to have control over your data no matter where it is stored.

SQL Server 2008 enables you to consume your data within custom applications developed using Microsoft .NET and Visual Studio and within your service-oriented architecture (SOA) and business process through Microsoft BizTalk Server while information workers can access data directly in the tools they use every day, such as the 2007 Microsoft Office system. SQL Server 2008 delivers a trusted, productive, and intelligent data platform for all your data needs.

SQL Server 2008 New Features






 


TRUSTED

SQL Server provides the highest levels of security, reliability, and scalability for your business-critical applications.













 Protect valuable information




Transparent Data Encryption

Enable encryption of an entire database, data files, or log files, without the need for application changes. Benefits of this include: Search encrypted data using both range and fuzzy searches, search secure data from unauthorized users, and data encryption without any required changes in existing applications.

Extensible Key Management

SQL Server 2005 provides a comprehensive solution for encryption and key management. SQL Server 2008 delivers an excellent solution to this growing need by supporting third-party key management and HSM products.

Auditing

Create and manage auditing via DDL, while simplifying compliance by providing more comprehensive data auditing. This enables organizations to answer common questions, such as, "What data was retrieved?"

> Learn more about SQL Server 2008 Security





















 Ensure business continuity




Enhanced Database Mirroring

SQL Server 2008 builds on SQL Server 2005 by providing a more reliable platform that has enhanced database mirroring, including automatic page repair, improved performance, and enhanced supportability.

Automatic Recovery of Data Pages

SQL Server 2008 enables the principal and mirror machines to transparently recover from 823/824 types of data page errors by requesting a fresh copy of the suspect page from the mirroring partner transparently to end users and applications.

Log Stream Compression

Database mirroring requires data transmissions between the participants of the mirroring implementations. With SQL Server 2008, compression of the outgoing log stream between the participants delivers optimal performance and minimizes the network bandwidth used by database mirroring.

> Learn more about SQL Server 2008 High Availability





















 Enable predictable response




Resource Governor

Provide a consistent and predictable response to end users with the introduction of Resource Governor, allowing organizations to define resource limits and priorities for different workloads, which enable concurrent workloads to provide consistent performance to their end users.

Predictable Query Performance

Enable greater query performance stability and predictability by providing functionality to lock down query plans, enabling organizations to promote stable query plans across hardware server replacements, server upgrades, and production deployments.

Data Compression

Enable data to be stored more effectively, and reduce the storage requirements for your data. Data compression also provides significant performance improvements for large I/O bound workloads, like data warehousing.

Hot Add CPU

Dynamically scale a database on demand by allowing CPU resources to be added to SQL Server 2008 on supported hardware platforms without forcing any downtime on applications. Note that SQL Server already supports the ability to add memory resources online.

> Learn more about SQL Server 2008 Performance and Scale









PRODUCTIVE

To take advantage of new opportunities in today's fast-moving business world, companies need the ability to create and deploy data-driven solutions quickly. SQL Server 2008 reduces time and cost of management and development of applications.













 Manage by policies






Policy-Based Management

Policy-Based Management is a policy-based system for managing one or more instances of SQL Server 2008. Use this with SQL Server Management Studio to create policies that manage entities on the server, such as the instance of SQL Server, databases, and other SQL Server objects.

Streamlined Installation

SQL Server 2008 introduces significant improvements to the service life cycle for SQL Server through the re-engineering of the installation, setup, and configuration architecture. These improvements separate the installation of the physical bits on the hardware from the configuration of the SQL Server software, enabling organizations and software partners to provide recommended installation configurations.

Performance Data Collection

Performance tuning and troubleshooting are time-consuming tasks for the administrator. To provide actionable performance insights to administrators, SQL Server 2008 includes more extensive performance data collection, a new centralized data repository for storing performance data, and new tools for reporting and monitoring.

> Learn more about SQL Server 2008 Manageability





















 Simplify application development






Language Integrated Query (LINQ)

Enable developers to issue queries against data, using a managed programming language, such as C# or VB.NET, instead of SQL statements. Enable seamless, strongly typed, set-oriented queries written in .NET languages to run against ADO.NET (LINQ to SQL), ADO.NET DataSets (LINQ to DataSets), the ADO.NET Entity Framework (LINQ to Entities), and to the Entity Data Service Mapping provider. Use the new LINQ to SQL provider that enables developers to use LINQ directly on SQL Server 2008 tables and columns.

ADO.NET Object Services

The Object Services layer of ADO.NET enables the materialization, change tracking, and persistence of data as CLR objects. Developers using the ADO.NET framework can program against a database, using CLR objects that are managed by ADO.NET. SQL Server 2008 introduces more efficient, optimized support that improves performance and simplifies development.

> Learn about SQL Server 2008 ADO.NET Object Services and LINQ





















 Store any information




DATE/TIME

SQL Server 2008 introduces new date and time data types:




DATE€”A date-only type


TIME€”A time-only type


DATETIMEOFFSET€”A time-zone-aware datetime type


DATETIME2€”A datetime type with larger fractional seconds and year range than the existing DATETIME type

The new data types enable applications to have separate data and time types while providing large data ranges or user defined precision for time values.

HIERARCHY ID

Enable database applications to model tree structures in a more efficient way than currently possible. New system type HierarchyId can store values that represent nodes in a hierarchy tree. This new type will be implemented as a CLR UDT, and will expose several efficient and useful built-in methods for creating and operating on hierarchy nodes with a flexible programming model.

FILESTREAM Data

Allow large binary data to be stored directly in an NTFS file system, while preserving an integral part of the database and maintaining transactional consistency. Enable the scale-out of large binary data traditionally managed by the database to be stored outside the database on more cost-effective storage without compromise.

Integrated Full Text Search

Integrated Full Text Search makes the transition between Text Search and relational data seamless, while enabling users to use the Text Indexes to perform high-speed text searches on large text columns.

Sparse Columns

NULL data consumes no physical space, providing a highly efficient way of managing empty data in a database. For example, Sparse Columns allows object models that typically have numerous null values to be stored in a SQL Server 2005 database without experiencing large space costs.

Large User-Defined Types

SQL Server 2008 eliminates the 8-KB limit for User-Defined Types (UDTs), allowing users to dramatically expand the size of their UDTs.

Spatial Data Types

Build spatial capabilities into your applications by using the support for spatial data.




Implement Round Earth solutions with the geography data type. Use latitude and longitude coordinates to define areas on the Earth's surface.


Implement Flat Earth solutions with the geometry data type. Store polygons, points, and lines that are associated with projected planar surfaces and naturally planar data, such as interior spaces.

> Learn more about SQL Server 2008 Programmability and Spatial Data









INTELLIGENT

SQL Server 2008 provides a comprehensive platform, delivering intelligence where your users want it.













 Integrate any data






Backup Compression

Keeping disk-based backups online is expensive and time-consuming. With SQL Server 2008 backup compression, less storage is required to keep backups online, and backups run significantly faster since less disk I/O is required.

Partitioned Table Parallelism

Partitions enable organizations to manage large growing tables more effectively by transparently breaking them into manageable blocks of data. SQL Server 2008 builds on the advances of partitioning in SQL Server 2005 by improving the performance on large partitioned tables.

Star Join Query Optimizations

SQL Server 2008 provides improved query performance for common data warehouse scenarios. Star Join Query optimizations reduce query response time by recognizing data warehouse join patterns.

Grouping Sets

Grouping Sets is an extension to the GROUP BY clause that lets users define multiple groupings in the same query. Grouping Sets produces a single result set that is equivalent to a UNION ALL of differently grouped rows, making aggregation querying and reporting easier and faster.

Change Data Capture

With Change Data Capture, changes are captured and placed in change tables. It captures complete content of changes, maintains cross-table consistency, and even works across schema changes. This enables organizations to integrate the latest information into the data warehouse.

MERGE SQL Statement

With the introduction of the MERGE SQL Statement, developers can more effectively handle common data warehousing scenarios, like checking whether a row exists, and then executing an insert or update.

SQL Server Integration Services (SSIS) Pipeline Improvements

Data Integration packages can now scale more effectively, making use of available resources and managing the largest enterprise-scale workloads. The new design improves the scalability of runtime into multiple processors.

SQL Server Integration Services (SSIS) Persistent Lookups

The need to perform lookups is one of the most common ETL operations. This is especially prevalent in data warehousing, where fact records need to use lookups to transform business keys to their corresponding surrogates. SSIS increases the performance of lookups to support the largest tables.

> Learn more about SQL Server 2008 Integration Services and Data Warehousing





















 Deliver relevant information




Analysis Scale and Performance

SQL Server 2008 drives broader analysis with enhanced analytical capabilities and with more complex computations and aggregations. New cube design tools help users streamline the development of the analysis infrastructure enabling them to build solutions for optimized performance.

Block Computations

Block Computations provides a significant improvement in processing performance enabling users to increase the depth of their hierarchies and complexity of the computations.

Writeback

New MOLAP enabled writeback capabilities in SQL Server 2008 Analysis Services removes the need to query ROLAP partitions. This provides users with enhanced writeback scenarios from within analytical applications without sacrificing the traditional OLAP performance.

> Learn more about SQL Server 2008 Analysis Services





















 Drive actionable insights






Enterprise Reporting Engine

Reports can easily be delivered throughout the organization, both internally and externally, with simplified deployment and configuration. This enables users to easily create and share reports of any size and complexity.

Internet Report Deployment

Customers and suppliers can effortlessly be reached by deploying reports over the Internet.

Manage Reporting Infrastructure

Increase supportability and the ability to control server behavior with memory management, infrastructure consolidation, and easier configuration through a centralized store and API for all configuration settings.

Report Builder Enhancements

Easily build ad-hoc and author reports with any structure through Report Designer.

Built-In Forms Authentication

Built-in forms authentication enables users to easily switch between Windows and Forms.

Report Server Application Embedding

Report Server application embedding enables the URLs in reports and subscriptions to point back to front-end applications.

Microsoft Office Integration

SQL Server 2008 provides new Word rendering that enables users to consume reports directly from within Microsoft Office Word. In addition, the existing Excel renderer has been greatly enhanced to accommodate the support of features, like nested data regions, sub-reports, as well as merged cell improvements. This lets users maintain layout fidelity and improves the overall consumption of reports from Microsoft Office applications.

Predictive Analysis

SQL Server Analysis Services continues to deliver advanced data mining technologies. Better Time Series support extends forecasting capabilities. Enhanced Mining Structures deliver more flexibility to perform focused analysis through filtering as well as to deliver complete information in reports beyond the scope of the mining model. New cross-validation enables confirmation of both accuracy and stability for results that you can trust. Furthermore, the new features delivered with SQL Server 2008 Data Mining Add-ins for Office 2007 empower every user in the organization with even more actionable insight at the desktop.

> Learn more about SQL Server 2008 Reporting Services and Data Mining
For more info, please go to http://www.microsoft.com/sqlserver/2008/en/us/default.aspx

View Replies !   View Related

---