Archives: August 2011
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…
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
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…
.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"];
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
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…
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
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
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