Euan Garden's BLOG

Life, the Universe, MS, VS, Testing and SQL Server

Browse by Tags

Tagged Content List
  • Blog Post: FAQ: SQL Server 2008 SP1 released, but how does the fix list relate to CU4 that was just released?

    I have received a ton of private mail on this, hence rather than just pasting the same answer in I’m going to take it on here. Interestingly enough I explained this problem, with a slightly different context, back when 2005 SP1 came out here , but lets go through it again with 2008 context. Bob Ward...
  • Blog Post: SQL Server 2008, Reportbuilder RTMs

    Get it here
  • Blog Post: High performance loading in SSIS for Oracle and Teradata

    While SSIS has always been able to load SQL Server at high speed it doesn't use any of the high speed Oracle APIs that are available. Well there is now a new high performance loader for Oracle and another one for Teradata. Downloads are here.
  • Blog Post: Slipstreaming SQL Server Updates/Service Packs in SQL 2008, almost

    One of the most common asks for SQL Server related to servicing/patching (after uninstall of updates/SPs) is the production of slimstreamed media, ie where the Update/SP and the RTM are included together in a single plackage. Now there are a couple of reasons to do this, the first is to save time and...
  • Blog Post: SQL Server 2008, Report Builder

    Ok so not everything for SQL Server 2008 is available yet, Report Builder is going to have a lag, you can find RC 1 here. This should work with RTM SQL 2008. Here are some of the changes from the last RC; Easy to use wizards for creating table, matrix and chart data regions. Support for directly...
  • Blog Post: SQL Server Express 2008, Advanced Services and Tools now available

    Get it here. That should not be all the pieces of SQL Server 2008 available.
  • Blog Post: SQL Server 2008, Express Edition now available

    Get it here. No tools or advanced services yet, but they will be here shortly. Good info on this page but beware its download link points to 2005 still.
  • Blog Post: SQL Server 2008: Why do all the Microsoft web sites still point at and talk about SQL Server 2005

    In short there is a "rolling thunder" plan to both release bits and update all the sites. Yesterday the MSDN subscriber sites were updated, also the MVP and TAP sites. Today Eval Edition and Feature Pack became available
  • Blog Post: SQL Server 2008 Installation Confusion, VS 2008 Sp1 and NetFx 3.5 Sp1

    Ok lots of folks are confused and are having their installations bounced. There is some info in the release notes but this is the definitive KB Let me try and explain; SQL Server 2008 has dependencies on (and includes) VS 2008 SP1 and its components (BIDS...
  • Blog Post: SQL Server 2008 RTM

    I'm forward dating this, but as you read this the bits should start becoming available. Congrats to the team on a focused release < 3 years since the last release. The various SKUs and supplimental bits such as the Feature Pack are going to be coming available over the next few weeks. Once all...
  • Blog Post: SQL 2008: Technet/MSDN Subscriber? Download RC0 now

    Details are here More info once I have mine downloaded and installed under Hyper V
  • Blog Post: SQL Server has a logo again!

    Read all about it here Remind me to write a long and painfu post about the battle with Central Marketing during SQL 2000 as to why it was better(or NOT) to have a picture of a building on the box than...
  • Blog Post: TDS Documentation

    Somehow I managed to miss this one (thanks to Erland for the pointer). Folks have been asking for access to docs on TDS since before I was involved in SQL Server, well now you can peruse(all 124 pages) to your hearts content.
  • Blog Post: SQL 2008: How do I tell if a specific table is still being used in an app?

    Ever had to take over the code for a system you did not define? Ever found the documentation for such an app, to be ahemmm lacking?   Its  a fairly common ask from new app developers/ DBAs to find out if certain code is still being used for apps that have evolved over  a number of years...
  • Blog Post: New Tools Features announced at Launch event

    The SQL 2008, VS2008, Windows Sever 2008 launch event in the US happened this week. Dan Jones has some highlight features that were announced; T-SQL Debugger is back Object Search is back Activity Monitor has effectively been rewritten to improve perf and usefulness
  • Blog Post: SQL Server 2008 CTP's and "Leap Day"

    Apparently there is an issue in the CTPs of SQL Server 2008 related to leap year. Although there is no known impact on SQL Server 2005 or prior versions at this time. The result of this issue is that SQL Server 2008 services will not start during the 24 hours of Feb 29 GMT. Action: Do NOT stop or restart...
  • Blog Post: SQL Server 2008, Feb CTP - Get it while it is hot! Update: While this page still says Nov it actually takes you to a page that is Feb, or says it is Feb. I'm downloading at home right now, if its the wrong version I will know in 20 mins.
  • Blog Post: Confused by SQL Server Version Numbers?

    Here is a nice picture of all the version numbers, now I still see a bunch of folks who are confused by the info that comes out of SQL Server in terms of versions, so try running the following script; set nocount on go select @@version go select 'Edition: ' + convert ( char...
  • Blog Post: SQL Server 2008: Reporting Services no longer needs IIS?

    Title says it all, but is this really a feature you can benefit from or is it some piece of random engineering that the dev team decided to do because it would be "fun"? One of the big challenges with SSRS has always been config, in fact I would argue its a problem for all of SQL Server 2005 so much...
  • Blog Post: SQL Server Customer Advisory Team

    I've talked about the SQLCAT team before and the great content they produce , you may have had a chance to sit in on one of their sessions at PASS or elsewhere. Well the team is trying a new outlet, richer than the std blog interface, they are testing a new web site. They've started out with some great...
  • Blog Post: Playing with SQL 2008, long gestation features - Spatial Support

    There are a bunch of features in SQL 2008 that have been on the ask list for a VERY long time. I suspect DATE and TIME types will win the prize as I remember asking for these as a customer of 6.5 10 years ago. However one that's been around for a long time (I remember hearing it asked for as part of...
  • Blog Post: Visual Studio Support for SQL 2008 Nov CTP

    For those of you who remember the "fun" days of the Yukon + Whidbey dance you are likely trying to forget the challenges of getting good builds of both that would work together via the same NetFx, Shell etc. Well this should be much less of a problem going fwds and as such the VS team has just released...
  • Blog Post: SQL Server 2008 November CTP/CTP 5 Arrives

    Just got the following link from Connect ; Looks like the first version of SQL 2008 Express is included. There is sooo much goodness in this CTP it deserves a separate post but some highlights; Upgrade(but not of clusters) Performance Data Warehouse for SQL Engine Compression Resource...
  • Blog Post: Compression: Whats the difference between SQL2005 and SQL2008?

    Looks like some folks are confused about the functionality and differences so let me try and explain and give some pointers to great blog entries for more details. SQL2005 Compression was added to SQL Server 2005 as part of SP2 and it was added via a new "type". The primary goal here was to catch up...
  • Blog Post: Getting to know SQL Server 2008: Training, WebCasts and Virtual Labs

    (Updated, fixed broken links mangled by Live Writer) Thanks to Francois here is a bunch of info on SQL 2008, some I have posted the base link for before but there is a bunch of new stuff; Check out this elearning -
Page 1 of 10 (239 items) 12345»