Browse by Tags
All Tags »
SQL Server 2008 (RSS)
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...
Excel and analysis services are pretty open technologies so it’s very easier for anyone to grow their own stuff in for a richer experience, and even Microsoft provide things like the data mining add-ins which follow this principle. These add-ins are not
Read More...
I had two contrasting conversation about upgrade to SQL Server 2008 yesterday. A good friend of mine Darren is keen to use SQL Server 2008 for his new projects because he understands how it makes much better use of the many cores available on his new
Read More...
My development skills are so old that the term 4GL and client server were the buzzwords of the day back then, so I thought it was about time I had look at what’s out there now. A quick search on Microsoft web development on Bing got me to the Microsoft
Read More...
Subscribe in a reader" />
