Browse by Tags
All Tags »
SQL Server 2008 (
RSS)
Download PDC 2008 Sessions and Watch Offline personally prefer watching sessions regardless of my Internet connection status, so I decided to download PDC08 sessions and watch offline . I collected the list of available sessions from PDC 08 , and they are easy to download. I personally use Free Download Manager for simultaneous efficient downloads - you can try it yourself. Just select all the text in this post, right click and select “Download Selected with Free Download Manager”. For a full list...
Training Kit for VS 2008 SP1 and .Net Framework 3.5 SP1 The ASP.Net 3. 5 Enhancement Training Kit was updated to VS 2008 SP1 and .Net Framework 3.5 SP1 and is available for download. This kit contains presentations, demos and labs for getting started with the new technologies that shipped as part of the service pack. Download here . Enjoy!
.Net Framework 3.5 SP1 and Visual Studio 2008 SP1 are Available! Read the announcement . Unlike other Service Packs from Microsoft, the SP1 of . Net Framework 3.5 and Visual Studio 2008 not only contains bug fixes and improvements, it also contains new technologies such as ADO.Net Entity Framework v1, ADO.Net Data Services v1, ASP.Net Dynamic Data and the framework and tools support for working with SQL Server 2008 that was RTM'ed last week . Here are some useful download links: VS 2008 Service...
If you haven't Installed VS 2008 SP1 Don't Install SQL Server 2008 Certain SQL Server 2008 features install components that are also part of the release version of Visual Studio 2008 SP1. So, if Visual Studio 2008 without the service pack is installed on your machine, you cannot install SQL Server 2008. If you try to install, you will ran into the following error: Rule "Previous releases of Microsoft Visual Studio 2008" failed. A previous release of Microsoft Visual Studio 2008...
SQL Server 2008 Resources After being announced on February 27th, SQL Server 2008 has been officially RTM'ed with a related press release . You can download it on MSDN Subscriber Downloads and TechNet Subscriber Downloads . Here are some additional resources you may want to check out: Download Microsoft® SQL Server® 2008 Enterprise Evaluation: Trial Experience for Developers Read about What's New in SQL Server 2008 Discuss it on SQL Server 2008 MSDN Forums Download SQL Server 2008 Jumpstart...
Visual Studio 2008 SP1: LINQ to SQL with SQL Server 2008 Date Time Types One of the pillars of Visual Studio 2008 and .Net Framework 3.5 Service Pack 1 is the support for SQL Server 2008 in Visual Studio 2008 tools and the related data access technologies. I decided to check out how LINQ to SQL works with SQL Server 2008 Date and Time types in Visual Studio 2008 and .Net Framework 3.5 Beta. I created a simple database with a single table called friends, that holds my friends names and birth dates...
Visual Studio 2008 SP1: LINQ to SQL and FILESTREAM In Visual Studio 2008 and .Net Framework 3.5 SP1, not only that LINQ to SQL supports the new date and time types of SQL Server 2008, but is also supports forking with FILESTREAM s. Using the File Management Schema from my SQL Server 2008 FILESTREAM post, I created a simple .net application that uses LINQ to SQL in order to access the file contents. Just a reminder of how the Files table looks like: CREATE TABLE [dbo].[Files] ( FileID uniqueidentifier...
Visual Studio 2008 SP1: Sync Services for ADO.Net with SQL Server 2008 Change Tracking One of the main pillars of Visual Studio 2008 and .Net Framework 3.5 Service Pack 1 if the better integration with SQL Server 2008. Service Pack 1 now uses the Change Tracking capabilities of SQL Server 2008 in order to identify the incremental changes. During the process of writing this post, I am building a simple application with both Visual Studio 2008 and Visual Studio 2008 + SP1 in order to spot the changes...
Visual Studio 2008 SP1: ADO.Net Entity Framework support for FILESTREAM In Visual Studio 2008 and .Net Framework 3.5 SP1 , not only that LINQ to SQL supports SQL Sever 2008 FILESTREAM , but also the ADO.Net Entity Framework supports FILESTREAM as well. Using the File Management Schema from my SQL Server 2008 FILESTREAM post, I created a simple .net application that uses Entity Framework in order to access the file contents. Just a reminder of how the Files table looks like: CREATE TABLE [dbo].[Files...
Links to all my posts about Visual Studio 2008 and .Net Framework 3.5 SP1 beta.
A Must Read!...
Download and Install Visual Studio 2008 and .Net Framework 3.5 SP1 Beta(KB945140) Visual Studio 2008 and .Net Framework 3.5 SP1 Beta was announced today after being kept as a secret for some time. Here is the list of available downloads as part of this release: Microsoft Visual Studio 2008 Service Pack 1 Beta Microsoft .NET Framework 3.5 Service pack 1 Beta - Full Installation Microsoft .NET Framework 3.5 Service pack 1 Beta - Web Installation Microsoft .NET Framework 3.5 Client Profile (Beta) Microsoft...
SQL Server 2008 FILESTREAM - Part 1 SQL Server 2008 has a lot of new cool features that I've talked about before: SQL Server 2008 IntelliSense SQL Server 2008 T-SQL: DECLARE and SET in the Same Statement SQL Server 2008 T-SQL: Insert Multiple Rows SQL Server 2008 T-SQL: MERGE Statement One of the great features in SQL 2008 is it's FILESTEAM support. To make things short, we can now not only store the path to the file in our database, but we can now store the whole file inside the SQL Server...
SQL Server 2008 February CTP and Visual Studio 2008 Support Although the official launch event for Visual Studio 2008 , Windows Server 2008 and SQL Server 2008 is next week, the release of SQL Server 2008 was postponed to later this year. A new CTP was released and is available for 180 days evaluation period. Go to the Microsoft SQL Server 2008 Evaluation Center , and choose the language and location of your evaluation experience. Download the SQL Server 2008 February CTP as a .iso file or as an...
SQL Server 2008 T-SQL: MERGE Statement I've seen many applications that needs to apply changes to the database from a list in the memory - we have a list of entities with ID's and other data (lets call it the source ), and we want to update a target table in the database to have the same data. In order to achieve this, we have to perform the following logic: If the source list has a record that matches a record in the target table, we want to update that record according to the changes in...
SQL Server 2008 T-SQL: Insert Multiple Rows In SQL Server 2005, in order to insert 3 rows to a table, you had to run 3 INSERT statements: insert into Customers ( Name , City, Phone) values ( 'Customer #1' , 'Jerusalem' , '2343245' ) insert into Customers ( Name , City, Phone) values ( 'Customer #2' , 'Tel Aviv' , '0987345' ) insert into Customers ( Name , City, Phone) values ( 'Customer #3' , 'Haifa' , '275466' ) In SQL Server...
More Posts
Next page »