-->
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

SQL Puzzle: Advent of Code

A few years back someone started the Advent of code. If you aren’t familiar with it, it’s an advent calendar of coding puzzles. Each day of December before Christmas there are two puzzles (with very Christmasy descriptions). You can do them with any language you choose, or even multiple… Read more

0 comments, 396 reads

Posted in SQLStudies on 29 August 2018

Copying formatted text out of a grid column.

I was reading a post today by Bert Wagner (b/t).

Displaying Long Variable Values in SQL Server

By the way, if you haven’t seen any of Bert’s vlog posts before they are well done and highly entertaining. Anyway, Bert was having difficulties displaying particularly long text… Read more

3 comments, 748 reads

Posted in SQLStudies on 27 August 2018

#SQLCareer 3/4 August 6th 2018

Last month Steve Jones (b/t) suggested that it might be helpful if those of us that work in the IT/database field shared four random days out of our lives. This is one of them.

The first two are:

 
Before work
Not… Read more

0 comments, 1,583 reads

Posted in SQLStudies on 22 August 2018

Nada to Speaker: Demystifying and Diminishing Dynamic SQL Difficulties

Last Thursday I spoke at NTSSUG (North Texas SQL Server User Group). This is my local group (only 1.5 hours away from me) and my second time speaking for them. I don’t speak frequently so I’m always more than a bit nervous, but the crowd was great, laughed in the… Read more

3 comments, 181 reads

Posted in SQLStudies on 20 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

1 comments, 3,086 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, 323 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, 249 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, 285 reads

Posted in SQLStudies on 6 August 2018

SQL Homework – August 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, 285 reads

Posted in SQLStudies on 1 August 2018