Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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…

Read more

0 comments, 1,044 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, 3,024 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…

Read more

1 comments, 830 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"];

Read more

0 comments, 444 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, 439 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…

Read more

1 comments, 371 reads

Posted in The SQL DBA in the UK on 16 August 2011

Auditing SQL Logins Part II

Written by David Postlethwaite

In a previous blog  I talked about how to audit successful logins. So what about failed logins?

As mentioned before logon Auditing can be configured under server properties. Here you can audit failed logins..

 

 

This puts the audit records into the Windows…

Read more

2 comments, 840 reads

Posted in The SQL DBA in the UK on 15 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, 759 reads

Posted in The SQL DBA in the UK on 8 August 2011

Audit SQL Logins

Written by David Postlethwaite
 
There are several ways that you can audit who has logged in to your SQL Server. The easiest way is to turn on logon Auditing under server properties. Here you can audit failed logins, successful logins, or both.
 
 
This will put the audit…

Read more

2 comments, 1,488 reads

Posted in The SQL DBA in the UK on 5 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, 3,651 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, 290 reads

Posted in The SQL DBA in the UK on 1 August 2011