Browse by Tags
All Tags »
SQL Server 2008 (RSS)
The best thing about working with SQL Server is working with the other people that use it. The SQL server experts who do most for their colleagues in the community are recognised as MVPs, so not only do they know their stuff they are willing to
Read More...
I promise this is the last time I mention SQL Bits this week, but I wanted to let you know I have got 25 free tickets for the paid for event this Friday which would normally cost £149 to attend. The venue is the Celtic Manor in Newport… and is probably
Read More...
I have been at TechEd Berlin last week and when I wasn’t speaking I spent most of the time in the Learning Centre (TLC) or ask the experts. I must confess I felt a bit of a non-expert this year for two reasons; I have been spending time getting up to
Read More...
To wrap up this mini-series on virtualisation, I wanted to clarify the support and licensing stuff you need to know if you want to Virtualise. The support is really simple, Microsoft support virtual machines just as though they are real environments.
Read More...
As I have said already in this series the major concern most DBA’s have when virtualising SQL Server is performance. I think this is actually a bit of myth for a number reasons: Virtualisation just keeps getting better . This is down to a partnership
Read More...
Given the almost mandatory drive to server virtualisation in data centres, what do you need to worry about and what’s in SQL Server to help you? The biggest worry is probably trying to manage everything, as typically many organisations simply create
Read More...
Security should be everyone’s business, but it’s often seen as someone else’s problem. When it comes to SQL Server there are at least three parts to the puzzle: The infrastructure guys will provide secure comms and accounts with which to access
Read More...
I get quite a few questions about virtualising SQL Server and typically today this is on VMWare so yesterday I went along to find out more at the VMWare London User Group. In the current world of computing, vendors compete with everyone but also
Read More...
I noticed a new tool appeared last week from Sentrigo that scrambles SQL Server passwords so that they cannot be seen in plain text by the DBA. This is to address a supposed vulnerability in SQL Server 2000/5 where by allowed memory dumps which
Read More...
I see Oracle have published a couple of papers recently on how easy it is install, configure and manage Oracle 11g vs SQL Server and DB2. The work was commissioned from the Edison Group and the paper on the Oracle / SQL Server comparison is available
Read More...
When I am not doing the day job I like to draw and paint to relax so I have combined a bit of business & pleasure for the SQL Bits Goes West conference by doing a few cartoons for them… As you can see the event has grown to three days. While
Read More...
I have decided to install the SQL Server 2008 R2 August technical preview (aka CTP2) on Windows Server 2008 R2. On this new OS there is a specific role the application sever role that you should setup before installing SQL Server This role adds in the
Read More...
Chris Webb MVP can, to quote a friend of mine can, “Make MDX sound interesting”. I have to say when I first when on a course on MDX the tutor went for the “Make MDX confusing and boring” approach. Chris has recently coauthored a book on Expert Cube
Read More...
This simple design, popped up in my inbox today asking for advice… What you need to understand about this diagram is that there is a concatenated key (keys are in BOLD ) on each of the orange dimension tables, with one part of that key being CompanyID.
Read More...
I haven’t had many problems myself when installing SQL Server 2008 on either Windows 7 or Windows server 2008 r2 but there are a few things to watch out for which I have shamelessly lifted from KB955725 : You should install SQL Server 2008 sp1 as this
Read More...