Subscribe to this blog
Archives: August 2011
Sharon Dooley’s Lightening Talk and the WIT Luncheon
At the end of last week I received an email from my friend and colleague Sharon Dooley telling me her “Lightening Talk” had been accepted and she would be speaking at the Summit in October. Sharon has many years experience in the IT industry, a former SQL Server MVP, currently…
0 comments, 665 reads
Posted in The SQL DBA in the UK on 31 August 2011
Using PowerShell to Monitor SQL Server
By Ian Treasure
Over the past few years, I have used a number of approaches to monitor SQL Server. For example, I have configured jobs to e-mail the DBA team if they fail. I have written programs to check that everything is OK. I have used a number of third-party… Read more
3 comments, 1,962 reads
Posted in The SQL DBA in the UK on 30 August 2011
VMFS LUN resizing options in vSphere
Introduction
First off, many thanks to Gethyn for the opportunity to post on his excellent blog.
I’m Christian Dadswell and I am a Senior Infrastructure Analyst at the Intellectual Property Office. I have 15+ years cross platform IT experience and currently support and maintain, amongst other things, the vSphere infrastructure…
1 comments, 559 reads
Posted in The SQL DBA in the UK on 24 August 2011
Get your AD information with .NET
.NET has a useful class called system.DirectoryServices to query LDAP such as Active Directory
Here is some example code to retrieve all the AD information for a user called FullName,
On a web site, your Active Directory Name can be found using
FullName = HttpContext.Current.Request.ServerVariables["AUTH_USER"];
0 comments, 313 reads
Posted in The SQL DBA in the UK on 22 August 2011
Another New Contributor–Christian Dadswell
This is just a short post to introduce you all to my good friend Christian Dadswell who has kindly agreed to write guest post for gethynellis.com.
Christian has a wealth of experience in IT especially in the field of virtualisation. I had the pleasure of working with Christian on… Read more
1 comments, 321 reads
Posted in The SQL DBA in the UK on 17 August 2011
Auditing SQL Logins Addendum
One thing that has come out of auditing successful logins is the number of applications called ".Net SqlClient Data Provider". This is slightly annoying because we don't want to audit a generic name because you won't then pick a rogue application.
This can be easily fixed by adding " Application…
1 comments, 269 reads
Posted in The SQL DBA in the UK on 16 August 2011
Putting a Database into Single User Mode
I was recently discussing with a group of budding DBA’s how you go about performing a restore of database. They were trying the restore for themselves and a few of them got an error about not having exclusive access:
Msg 3101, Level 16, State 1, Line 5
Exclusive access could… Read more
1 comments, 497 reads
Posted in The SQL DBA in the UK on 8 August 2011
Updating Views
Written by Ian Treasure
Gethyn recently posted on deleting from a view. He used a common situation where several tables are joined into one view. In simpler situations, views can be updated directly. If required, triggers can be used to allow updates to views which join several tables.… Read more
0 comments, 1,742 reads
Posted in The SQL DBA in the UK on 3 August 2011
We Have Another New Contributor…
I’d like to introduce you all to my friend Ian Treasure who has kindly volunteered to write some posts and articles for us. Ian works for a client of mine as a SQL Server DBA and DBA team leader and has many years experience with SQL Server from version 7… Read more
0 comments, 194 reads
Posted in The SQL DBA in the UK on 1 August 2011