Welcome to TechNet Blogs Sign in | Join | Help

Andrew Fryer's Blog

SQL Server Relational and Beyond

News

  • This posting is provided "AS IS" with no warranties, and confers no rights.
  • Technorati Profile

Browse by Tags

All Tags » SQL   (RSS)
SQL Server 2008 Central Management Servers
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...
SQL Server 2008 Intellisense support for SQL 2000/5
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...
SQL Server 2008 Unleashed
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...
Who stole my Report Builder
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...
SQL Bits - Don’t be square be cubed
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...
Install SQL Server 2008 Advanced Services
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...
SQL Server 2008 RC0 Express on Vista
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...
SQL Server 2008 End User Reporting
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...
SQL Server 2008: where’s my stuff?
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...
SQL Server Consolidation Options
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...
SQL Server 2008, no definite release date
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...
SQL Server 2008 RC0 feature pack
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...
Using Full Text Searching SQL Server 2008
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...
Microsoft SQL Server Community Utilities
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 Filtered Indexes vs Index Views
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...
More Posts Next page »
Page view tracker