Browse by Tags
All Tags »
SQL Server (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...
I have been at a couple of trade shows over the last couple of weeks and a consistent theme has emerged, the reluctance of DBA’s to virtualise SQL Server, whether or not that is Hyper-V. If you fall into this camp please read-on… Hopefully
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 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...
Microsoft’s approach to stuff is to ship the basic product as part of a license and then provide you with lots of other add-ins, packs, resource kits and so on which are all free to use on top of what you just paid for e.g. Windows has the Live platform
Read More...
My first introduction to Access was a painful experience, not because of the product itself but the way it was used, so it was mixed feelings that I read up on the official Access blog what it will look like in Office 2010. Yippee it’s going to
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...
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...
I see a lot of tweets, and questions on forums about SQL Server Express from developers, particularly around installing it on client versions of windows, so I though I’ll give it a go and see if there is nay truth to the rumours. Rather than try it on
Read More...
Subscribe in a reader" />
