SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: July 2011

Calling SCOM in C#

Written by David Postlethwaite

I’m sure there are many out there using System Centre Operations Manager (or SCOM for short) it’s a great tool for monitoring the Windows estate.

One area where it is lacking is updating the subscribers list for a Notification Group – in other words changing the…

Read more

0 comments, 3,941 reads

Posted in The SQL DBA in the UK on 29 July 2011

Searching for Wild Card Characters

I got asked an interesting question recently, I was demonstrating how you can use wild cards in a WHERE clauses when someone asked ‘How do you search for a wild card character when using a LIKE based WHERE clause fro string comparisons. I must have looked stumped for a minute… Read more

1 comments, 762 reads

Posted in The SQL DBA in the UK on 27 July 2011

IT Professionals, the Job Search and the Killer CV

It has been while since I wrote anything on my contracting blog but over the past month or so I have had several  questions from people who are thinking about their future and what they want from their career. This includes people thinking about both permanent and contract work.

Whether… Read more

0 comments, 1,198 reads

Posted in The SQL DBA in the UK on 25 July 2011

SSRS: Dynamic Data Sources

I have been building dashboard using Reporting Services (SSRS) for a client of mine. The dashboard is going to be used to display useful information on their SQL Server instance, the information contained in the reports will be retrieved from DMVs. Information like the SQL Server wait types, information on… Read more

2 comments, 7,868 reads

Posted in The SQL DBA in the UK on 22 July 2011

DOS Batch File Date and Time

Written by David POstlethwaite

A non SQL blog for a change
Ever needed to create a batch file that wrote a time stamped log file that ensures the day and month number always have two digits?
Try this:
SET Now=%Time: =0%
Set YYYYMMDD=%DATE:~6,4%_%DATE:~3,2%_%DATE:~0,2%_%now:~0,2%%now:~3,2%
echo running Batch… Read more

0 comments, 1,343 reads

Posted in The SQL DBA in the UK on 20 July 2011

Execute Permissions

Written by David Postlethwaite

Security of the SQL database is becoming more and more important these days yet I’m finding that vendors often overlook setting minimum required privileges on a database. Many database I’ve been given to install just assign db_owner to the user accounts that really only need read… Read more

2 comments, 4,993 reads

Posted in The SQL DBA in the UK on 18 July 2011

Effective Permissions on a Database

written by David Postlethwaite

Ever wondered who has what access to your database or a particular object within? With the ever increasing need to keep permissions to a minimum this is becoming more important.

If you are using Active Directory groups to assign permissions to your servers and your databases… Read more

0 comments, 2,061 reads

Posted in The SQL DBA in the UK on 14 July 2011

We have a new contributor…

In order to keep the content fresh and the posts flowing here on my blog  I have decided to publish some guest posts. My friend and colleague David Postlethwaite (@postledm | Linkedin) has agreed to write some posts for GethynEllis.com. David has been a DBA for a few years… Read more

1 comments, 582 reads

Posted in The SQL DBA in the UK on 13 July 2011

Can you delete from a view?

I have seen this question come up several times over the last few months. Can you delete from a view? So I thought I would put a short post together to explain the answer.

What is a View?

First up what is a View? To paraphrase from Books Online (BOL)… Read more

1 comments, 57,479 reads

Posted in The SQL DBA in the UK on 11 July 2011