Browse by Tags
All Tags »
SQL (RSS)
I have done a blogcast and a few posts around the configuration servers in the betas of SQL Server 2008, however in SQL Server 2008 as released these are now called Central Management Servers. For those of you who have held off form trying
Read More...
Intellisense for SQL, how hard is that? Well judging for how long we have been asking for it the answer is “very”. Also talking to the product team it is actually much harder than for C# VB etc. because of the nature of SQL. Anyway intellisense
Read More...
Although the official UK launch of SQL Server 2008 merged in with the launches of Windows Server 2008, and Visual Studio 2008 back in March, we wanted to celebrate the actual release as well. So please join us in TVP on 10th September for SQL Server
Read More...
Anyone who has tried Report Builder v2, aka Report designer Preview, blue etc. will have noticed that it isn’t fit for purpose yet. By this I mean it is not in a state in which you could give it to a what Microsoft calls an information worker i.e.
Read More...
The UK SQL community are doing their next SQL Bits cubed on Saturday 13th Sept at Hatfield University. Possible excuses for NOT attending would be: You are reading this blog not because you are a highly skilled DBA but: You like my witty style You
Read More...
Having got past the pre-installation issues in my last post I am now ready to install SQL Server 2008 Express with Advanced Services.. I ran the System Configuration Checker and got a set of green lights, except for PowerShell... and the install won’t
Read More...
I wanted to get Express installed on my machine and so I downloaded the RC0 (of Express with Advanced Services) and ran it. BTW there is is this Akamai download manager behind all of the RC0 downloads which you have to allow to run to get the download
Read More...
I have been seeing a fair bit of confusion about the new end user reporting tools in SQL Server 2008, so I thought it would be good to try and clear it up. In SQL Server 2005 there is a Report Builder tool that relies on a Report Model. The report
Read More...
For those of us who have been tracking the evolution of SQL Server 2008 through it’s long gestation it can be a bit annoying when things get moved around. In RC0 odds and ends seem to have disappeared and the more sceptical DBA might assume the
Read More...
Consolidation of server is a very hot topic as server rooms fill up and cooling becomes ever more expensive. Virtualization is the current darling in this space and indeed it is fantastic for many application workloads. However it is not the only
Read More...
There is some buzz around about SQL Server 2008 being out in August e.g. on SQL Server Central , however that’s more than I know. I do know that it is listed in the August price list and that pricing is no different form SQL Server 2005, which is more
Read More...
The sharp eyed amongst you will have noticed that there are a few things missing in RC0 that were in CTP6 and I was a bit annoyed that one of my favorites, the report designer preview had disappeared. Don’t panic it’s tucked away in the SQL Server 2008
Read More...
I have now got SQL Server 2008 RC0 running in my Hyper-V 64-bit virtual machine, complete with the sample adventure works database from connect . Now it’s time to have a look at querying full text indexes. One of the common ways of doing this is to use
Read More...
As well as the independent SQL communities, there is also a Microsoft run one, the Microsoft SQL Server Community Worldwide ( You can tell it’s the Microsoft one by the catchy title). They do tend to assume worldwide is the United States wide or
Read More...
SQL Server 2008 has a new feature called filtered indexes which are like normal table indexes only they have a simple where clause, meaning that the index will only cover rows specified in the where clause. As I have mentioned before an obvious example
Read More...
