Browse by Tags

Plenty of FREE SQL 2008 stuff from JumpStart Event

JumpStart 2008 is an event held in Seattle in February. All the content delivered there is now available for everyone (after a quick registration). http://sqlserver2008jumpstart.microsofttraining.com/content/DownloadMaterial.asp?CcpSubsiteID=69&section=Overview Here are some examples of what's...

Posted to The Premiers (Weblog) by ThePremiers on 05-06-2008
SQL Internals Viewer - New version with sparse column support

I've just released a new version of SQL Internals Viewer that has support for 2008 sparse columns, a feature introduced in SQL Server 2008 CTP6. There are also a few bug fixes and minor changes. It's available to download from http://www.sqlinternalsviewer.com/ Thanks to Kalen for the help with...

Posted to Danny's SQL Server and Internals Viewer Blog (Weblog) by Danny on 05-02-2008
Operations Day for SQL Server 2008 (Open for Premier customers only)

Dear Premier, I am pleased to announce that Premier Field Engineering (PFE) are hosting an Operations Day for SQL Server 2008. The day will provide customers with a wealth of technical information covering a wide range of issues relevant to SQL Server 2008 database administrators. When? 9am on Thursday...

Posted to The Premiers (Weblog) by ThePremiers on 04-27-2008
SQL Server 2008 - Breaking bug

If you are using CTP6 of SQL Server 2008 and want to use Integrated Full Text and find it is not working. You might get timeouts or other general errors. It could be due to an account that iFTS uses. iFTS does some stuff out of process for security and reliability in CTP6 the run this process under a...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 04-11-2008
SQL Server 2008 - HierarchyId - How do you move nodes/subtrees around

In a recent post SQL Server 2008 - HierarchyId whats the point? I talk about the scenarios that the new hieararchyId can be applied to. Here we expand on this further and also provide a solution for moving hierarchies around. The limitation is that you can't do something like this to change the parent...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 03-31-2008
SQL Server 2008 - HierarchyId whats the point?

I've recently been deliverying training sessions on SQL Server 2008 and doing launch events. The training covers all aspects of SQL Server development. For most features I can provide a strong argument for the feature with the exception of one. HierarchyId . HierarchyId is the new data type that...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 03-29-2008
SQL Internals Viewer 1.0 Released

I’m pleased to announce that SQL Internals Viewer 1.0 has been released. It can be downloaded from www.sqlinternalsviewer.com . I've also put up the first part of a user guide that covers the main window and Allocation Map. The second part will follow shortly which will cover the Page Viewer. The...

Posted to Danny's SQL Server and Internals Viewer Blog (Weblog) by Danny on 03-24-2008
BI Tools - SQL2008 CTPFebruary Bug (SSIS)

Dear friends, This is my first post in SQLBLOGCASTS... I have my blog in www.pedrocgd.blogspot.com , and I' trying to transfer all the content to here, but I have that blog for a year and is not easy the change... so, I let you my fisrt post here...:-) I found the gold… no...no… I found the bug!...

Posted to Pedro Perfeito (PedroCGD) (Weblog) by PedroCGD on 03-22-2008
SQL Server 2008 - Whats this abut 30,000 columns?

Its all about Sparse columns and they are a great feature of Katmai Imagine you have a products table, you will have attributes for some products that don't apply to others i.e. cup size applies to bras but not to socks. There are a number of ways of modelling this each with downsides. With sparse...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 03-16-2008
SQL Server 2008 - Converting binary(hex) values to strings

One of the frequently asked questions in the newsgroups is how do you convert a string representation of a binary value to the equivalent binary value and the reverse. The latter is often required to be able to print out the binary representation. There have been a few undocumented functions and many...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 03-11-2008

Page 1 of 8 (75 items) 1 2 3 4 5 Next > ... Last »