August 2008 Blog Posts
I just received my latest copy of TechNet Flash and it included a section on SQL Server 2008. I have copied it here for anyone who may not receive TechNet flash - well work signing up for. For overview resources, check out: . SQL Server 2008 Videos . Webcasts: 24 Hours of SQL Server 2008 for IT Professionals If you are looking for assistance with SQL Server 2008 planning and installation, here are some helpful links: . Planning a SQL Server Installation ....
I have used T-SQL for quite a few years now and I have always wondered why it has such bad support for date and times? OK, I can create a data type called DateTime, but where is the function to return just the date portion? There are functions to return the Year, Month and Day of a DateTime variable, but not the hour, minute or second! Now even with DateTime2 we do not really get a lot more functionality. It would seem very common to want to format a date and time in a custom way but...
I am not at work today because I have a very sore back so I thought in the moments that I can sit I could find SQL Server Tools that you can download for free. As we all know you will probably have to register to get them free but who cares free tools are free tools and you never know when you really need one of these tools. The tools are listed in no particular order: Idera have 4 free tools available that you may want including a free tool (SQL Job Manager) that they...
This site contains presentations, recordings, hands-on labs and demonstrations for the SQL Server 2008 JumpStart technical training event. There are 5 tracks in this event: Overview Sessions Database Infrastructure and Scalability Business Intelligence Part I & II Developer & Software + Services Application Compatibility & Upgrade. You must register online to get access to the content, which I have just done. At this stage it is hard to know if it is going to be very useful,...
Axialis Software, in association with Microsoft Corporation, presents Axialis IconWorkshop Lite for Visual Studio 2008: 100% Free for Visual Studio 2008 users; Make icons for Windows up to 256x256 PNG-compressed icons for Windows Vista™ and include them in your software projects; Use an advanced icon editor with various tools, filters and effects; Work efficiently using a Plug-in for Visual Studio 2008; Create icons from images or ready-to-use image objects; Use a fully integrated workspace with librarian,...
You may find that when installing SQL Server 2008 you receive the follow error during installation. "The SQL Server 2005 Express Tools are installed. To continue, remove the SQL Server 2005 Express Tools." A couple of things to do: Remove SQL Server 2005 Express Tools Remove Red-Gate SQL Prompt if installed. UPDATE: SQL Prompt v3.9 (available for download from www.red-gate.com) addresses this problem and no longer blocks the installation of SQL server 2008. Also, SQL Prompt v3.9 supports SQL Server 2008. ...