Archive
Monthly
Go
|
|
DNN Blog
Sep
17
Posted by:
Erik van Ballegoij
9/17/2008 3:07 PM
Where it comes to using SQL Server features, I am a very late adopter. Not by choice, for all the DotNetNuke modules I create, I'd like to maintain backwards compatibility as much as possible, especially since DotNetNuke also fully supports MS SQL Server 2000.
Just slowly I am converting to use nvarchar(max), which is not available in SQL Server 2000. There is one tool I've become a great fan of though, and that is SQL Prompt, by Red-Gate. This is a great tool, adding intellisense to SQL Server, in management tools such as SQL Server Management Studio, Visual Studio and QueryAnalyzer. I can tell you it is a real time saver!
Just recently i did a complete new installation of Windows Vista, Visual Studio 2008 and SQL Server 2008. (read about my adventure with ASP.NET AJAX extensions for ASP.NET 2.0) I hadn't kept up really with all the new features in SQL Server 2008, so it came as big surprise to me that I had intellisense available in SQL Management Studio 2008, without installing SQL Prompt! See for yourself:
Another thing that seems to be a great tool voor developers: real time sql script debugging!. Check this out:
This will make it so much easier for developers to create their SPROCs.... Good Job Microsoft!
(this post is cross posted from my personal blog)
9 comment(s) so far...
Re: SQL Server 2008 Developer Goodies
Yeap, I am loving sql 2008 myself. The new data types are awesome, not to mention the heirarchy data structure available. :) And you are correct having the intellesense is very nice. With so many commands its hard to remember which one you want all the time, but if you can scan the list of commands / parameters you can typically make things out.
VS2008 and its sql components are nice as you point out. It does a great job of tracking things while in debug mode.
By keeperofstars on
9/17/2008 8:42 PM
|
Re: SQL Server 2008 Developer Goodies
From what I understand if you connect from SQL Server 2008 management console to an older SQL server version you don't get intellisense, I don't know if Red-Gate has some sort of advantage here.
I'm just wondering, do we know of any know of any issues running DNN with SQL Server 2008 (I have yet to take the leap, but I'm seriously considering it as my web hosting provider will be supporting it next month).
By NukeAlexS on
9/17/2008 8:42 PM
|
Re: SQL Server 2008 Developer Goodies
@Alex: i am running all DNN 4 versions from 4.0.3 to 4.9.0 on SQL2008.. no issues yet
By ErikVB on
9/17/2008 8:47 PM
|
Re: SQL Server 2008 Developer Goodies
No issues here on my 10. MS is pretty good about keeping backwards compatability. The only time you see them break this is when they just have no other choice. Also the core team for DNN are very good about supplying us updates to the core for new technology.
I suggest you google it a bit and make sure you understand everything. Typically if you are currently on 2005 making the jump to 2008 is pretty seamless. Just a few new data types, but all the old ones are there for compatability.
By keeperofstars on
9/18/2008 8:32 AM
|
Re: SQL Server 2008 Developer Goodies
Hi Erik,
Are the DNN 4.x installations you referenced running on MSSQL2008 with compatibility level = 100?
By BrandonHaynes on
9/18/2008 8:32 AM
|
Re: SQL Server 2008 Developer Goodies
@Brandon: yes, they are all running with compatibility level 100. These are new installs on a new vista environment, so they are not being used as live sites. I am using the installs as dev environments though. Installation of all instances went very smooth.
By ErikVB on
9/18/2008 8:42 AM
|
Re: SQL Server 2008 Developer Goodies
I have mine running on windows server 2008 64 bit with sql 2008 dbs, and IIS7 and not one bit of an issue. *knocks on wood* :) Been up with sql 2008 beta for about 3 months now. And been running on the release client for about a month now. I have moved my sites to a full production mode with this setup as it's quite fast. IIS7 really does a nice job with threads and worker processes. A key element to DNN speed.
So DNN is very compatiable with all the new goodies MS released in past few months. Just note that all of these goodies are visually and procedurally different. Not the DNN side but things like IIS7 is a whole new beast to learn. It's not bad and just takes a small learning curve but just note its there, before skipping up to the boss and inserting your foot in your mouth. :)
Just a note: I have ran 4.6 + versions on that setup. Haven't tried anything before that.
By keeperofstars on
10/4/2008 12:18 PM
|
Re: SQL Server 2008 Developer Goodies
I have Microsoft SQL Server Management Studio 2008 pointing to a SQL Express 2008 DB and I am not getting intellisense. Does it only work on Standard or above?
By ccarns on
10/4/2008 12:19 PM
|
Re: SQL Server 2008 Developer Goodies
OK Sorry I take that back I am getting intellsense but it is not as intelligent as what I was expecting. For Tablenames you have to start with owner and for field names you need both owner and table before it filters it down to the acutal fields when you are inside a SELECT.
By ccarns on
10/4/2008 12:19 PM
|
|