Geeks With Blogs
Frank Wang's inspirations on .NET
IEnumerable<Inspiration> inspirations = from i in DataContext.Inspirations where i.Sharable == true select i
SQL Server 2008
Experience SQL Server 2008 RC0
Microsoft last week rolled out the first Release Candidate of SQL Server 2008. The RC0 bits are available for public download here. I have been playing with SQL 2008 RC0 for a few days already, and I would like to share my experience in this quick blog post. First of all, I have to warn you that my RC0 installation experience was not pleasant at all. If you are an early adopter of new releases like me, you will very likely run into the same troubles I had. Previous CTP releases of SQL Server 2008 ......

Posted On Thursday, June 19, 2008 11:06 PM

Saving table changes is safer in SQL Server 2008
I have been playing with SQL Server 2008 "Katmai" for quite a while. Although the new management studio designer looks almost the same as that of SQL 2005, there're actually many new features under the hood, and some of them are quite thoughtful. I have just been discovering these goodies here and there everyday. What I found today is also pretty interesting. By default, SQL Server 2008's designer no longer allows saving changes that require table re-creation. You will need to turn off this safety ......

Posted On Thursday, May 29, 2008 3:36 PM

IntelliSense in SQL Server 2008 "Katmai"
Finally, the long awaited IntelliSense arrived with the SQL Server Katmai. Not sure if it is because SQL 2008 is still in CTP, but the IntelliSense is nowhere near the RedGate's SQL Prompt. But if your evaluation of SQL Prompt has run out and you don't have a license, the SQL 2008 IntelliSense should be good enough for your day to day work with the query analyzer. To see the IntelliSense and other cool IDE enhancements in action, download the SQL Server 2008 "Katmai" Feb 2008 CTP here. Here are a ......

Posted On Monday, April 14, 2008 7:53 PM

Enable the Visual Studio 2008 support for SQL Server 2008
The SQL Server 2008 CTPs came out after Visual Studio 2008 was released. There's a compatibility issue when you try to open a database connection to SQL 2008 from the VS 2008 designer tool. You may receive the following error message: “This server version is not supported. Only servers up to Microsoft SQL Server 2005 are supported.” This happens when you select the the server, the database, and then click on "Add" to create the database connection. Fortunately, Microsoft released a CTP to address ......

Posted On Sunday, April 6, 2008 10:26 PM

Copyright © Frank Wang | Powered by: