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

SQLStudies

My name is Kenneth Fisher and I am Senior DBA for a large (multi-national) insurance company. I have been working with databases for over 20 years starting with Clarion and Foxpro. I’ve been working with SQL Server for 12 years but have only really started “studying” the subject for the last 3. I don’t have any real "specialities" but I enjoy trouble shooting and teaching. Thus far I’ve earned by MCITP Database Administrator 2008, MCTS Database Administrator 2005, and MCTS Database Developer 2008. I’m currently studying for my MCITP Database Developer 2008 and should start in on the 2012 exams next year. My blog is at www.sqlstudies.com.

Archives: August 2018

What are my permissions?

Permissions are a common concern. One of the most frequent requests I get is I need X, Y and Z permissions. And all too often the conversation goes like this:

Dev: I need write permission to this database.
Me: Ok.
Me: Checks their current permissions.
Me: You already have that… Read more

0 comments, 104 reads

Posted in SQLStudies on 16 August 2018

Complicated linked servers and a bunch of head-desks: T-SQL Tuesday #104

Wayne Sheffield (b/t) is our host this month for the long running blog party (104 months now and running!) started by Adam Machanic (b/t). In this case Wayne is asking us to talk about a time when we hit a brick wall Read more

0 comments, 99 reads

Posted in SQLStudies on 14 August 2018

Putting Object Explorer etc on the right side of SSMS rather than the left.

A while back I was given the advice Move your tabs (Object Explorer etc) to the right side of SSMS. Now I didn’t do it at the time, but recently I decided they were right and I should give it a shot. It’s taking some getting used to, but… Read more

0 comments, 181 reads

Posted in SQLStudies on 8 August 2018

T-SQL Formatters

The other day I was given a truly horribly formatted piece of SQL. Something a bit like this only worse, and with plenty of dynamic SQL.

CREATE TRIGGER [Sales].[iduSalesOrderDetail] ON [Sales].[SalesOrderDetail] 

	

AFTER INSERT, DELETE, UPDATE AS 

	

Begin

	

    DECLARE @Count int;

	
    SET @Count = @@ROWCOUNT;


    IF @Count = 0 

	

        RETURN;

	
    SET…

Read more

3 comments, 141 reads

Posted in SQLStudies on 6 August 2018

SQL Homework – July 2018 – Set up database mail

This month’s homework is pretty simple to say, not necessarily easy to do. Set up database mail.

Why database mail? Well, since last month’s homework was setting up a SQL Agent job, it would be nice to have an easy way to send messages about a jobs progress, success, or… Read more

0 comments, 169 reads

Posted in SQLStudies on 1 August 2018