Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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.

Learning Regular Expressions

I’m a regular watcher of the Midnight DBA Webshow and one day they mentioned regular expressions. Not a new term for me, but not something I’d ever looked at much. Well as it happens I had something that I needed to use it on a day or two later and… Read more

4 comments, 46 reads

Posted in SQLStudies on 2 September 2015

The default instance has a name

The default instance actually has an instance name. It’s MSSQLSERVER. This is probably familiar to a lot of you but hold on because I’m going to go a little bit deeper. When we connect to a default instance we typically just put down the server name right? Is that because… Read more

2 comments, 90 reads

Posted in SQLStudies on 31 August 2015

The 30 minute rule

In one of my first IT jobs (back in the dark ages) we had something called the thirty minute rule. Kind of catchy right? But what did it mean? Simply said, if you have made no progress on a problem for 30 minutes go find some help.

The idea… Read more

3 comments, 120 reads

Posted in SQLStudies on 26 August 2015

The tail of the log

The tail of the log

A little while back I was feeling overwhelmed by the number of blog posts ideas that I had so I asked around if anyone wanted one. Surprisingly I only had one taker. Warwick Rudd (b/t), and he wrote this great post… Read more

0 comments, 142 reads

Posted in SQLStudies on 24 August 2015

SSMS’s Clipboard Manager

The other day Richie Rump (b/t) mentioned something called a clipboard manager on twitter. I’ll admit I had to ask what exactly they meant, but once it was described to me I realized it was something I’d wanted off and on for years. Basically it’s… Read more

10 comments, 1,595 reads

Posted in SQLStudies on 19 August 2015

Pulling data from the error log

The other day I was asked to pull a list of errors from the SQL Server log into a table for analysis. It seemed like something that others might find useful so I decided to post what I came up with.

First I had to get the number of error… Read more

6 comments, 1,988 reads

Posted in SQLStudies on 17 August 2015

Getting and storing a high precision datetime

Earlier today I was working on a project where I was recording some time stamps. In order to get as much precision as possible I decided to go with a datetime2 datatype. Unfortunately when I recorded the time stamp it didn’t quite work out liked I’d hoped.

DECLARE @StartDate datetime2…

Read more

5 comments, 117 reads

Posted in SQLStudies on 13 August 2015

Database Master Keys can have more than one password.

Our subject for this month’s T-SQL Tuesday blog party (#69) is Encryption, hosted by a guy with an awesome first name: Ken Wilson (b/t).

Encryption isn’t a subject I spend a lot of time on. I’ve studied it enough to know most (I hope) of the… Read more

3 comments, 126 reads

Posted in SQLStudies on 11 August 2015

A pattern to match correctly on a value or a NULL

As you may have noticed if you read my blog I learn a lot from trolling various forums. In this particular case I was looking at dba.stackexchange.com and came across this great code pattern. Now the answer comes from Andriy M but in the comments they give credit to… Read more

3 comments, 553 reads

Posted in SQLStudies on 5 August 2015

SQL Crossword

I decided I’d have some fun today. So for your entertainment here is my first crossword puzzle. (Word and PDF versions at the bottom.)


Download the crossword as a Word file.
Download the crossword as a PDF


Filed under: DBA Humor, Microsoft SQL Server, SQLServerPedia Syndication Tagged: Humor

Read more

0 comments, 113 reads

Posted in SQLStudies on 3 August 2015

Some of my favorite SSMS Keyboard shortcuts

I love keyboard shortcuts. I recently mapped a keyboard shortcut to Change Connection and thought I would share some of my other favorites.

  • Shft+Arrow keys (sometimes + Ctrl): Highlight blocks of code. Adding in the control key moves you a word at a time rather than a single character.…

Read more

11 comments, 191 reads

Posted in SQLStudies on 29 July 2015

Permissions Posters

I’ve been doing a lot of research recently for my permissions session and for a project at work. During said research I came across three great sets of posters about permissions. I’m going to list them here and on my Study and Reference Materials

Permissions Hierarchy (Database Engine)

Database Engine… Read more

3 comments, 169 reads

Posted in SQLStudies on 27 July 2015

#ArgenisWithoutBorders the Sequel

Last year Kirsten Benzel(b/t) and Argenis Fernandez(b/t) did this amazing thing. They organized a campaign and raised over $13,000 for Doctors Without Borders. The campaign was called #ArgenisWithoutBorders. The idea was that Argenis would wear this really amusing (and… Read more

1 comments, 259 reads

Posted in SQLStudies on 22 July 2015

Filtered Index restrictions and Kendra Little’s Index Quiz

A few weeks ago I saw a tweet about Kendra Little’s (b/t) new SQL Server Quizzes. Of course I had to give them a shot and while I was somewhat disapointed in my scores on a few over all they were a lot of fun.… Read more

0 comments, 1,510 reads

Posted in SQLStudies on 20 July 2015

SSMS 2015

Yes, you heard me right. SSMS 2015. No I’m not one of those crazy recruiters who keep asking for 10 years of experience with SQL 2013. Well, technically it’s a preview of a separate install of SSMS for SQL 2016.

SQL Server Management Studio June 2015 preview

There are supposed… Read more

0 comments, 215 reads

Posted in SQLStudies on 16 July 2015

TSQL Tuesday #68: What is my configuration?

It’s T-SQL Tuesday again and this month Andy Yun (b/t) is our host and he has asked us to “Just say no to defaults”.

Defaults. This is subject with a huge breadth and depth. Which as it happens, makes it a great T-SQL Tuesday subject.… Read more

1 comments, 906 reads

Posted in SQLStudies on 14 July 2015

What is the database property “Compatibility Level”

What is the database property Compatibility Level? I don’t get asked to write about specific subjects very often but in this case not only did I have someone ask me to write about it but had a co-worker ask me what it is. I’ve always thought this was pretty… Read more

2 comments, 165 reads

Posted in SQLStudies on 8 July 2015

Adding a new keyboard shortcut in SSMS.

I love keyboard shortcuts. I’d rather keep my hands on the keyboard than move back and forth to the mouse. Not that I won’t use the mouse, but only when I have to. One frequent (and annoying) task that I haven’t been able to find a keyboard shortcut for is… Read more

4 comments, 1,771 reads

Posted in SQLStudies on 6 July 2015

Blocking and deadlocking on purpose

Blocking and deadlocking are not things you typically want to do deliberately. But sometimes you need to test error handling or prove a point and then you need to do the unusual.

Blocking and Deadlocking are based on lock requests and locking is handled differently depending on the TRANSACTION ISOLATION… Read more

0 comments, 1,578 reads

Posted in SQLStudies on 1 July 2015

Zero to Speaker pt 2

A few months ago I wrote a post about the fact that I had actually submitted a session to PASS Summit. Well as I’m sure you are aware the selected sessions have been announced. They were officially announced Friday but I actually received my result email on Thursday evening.… Read more

4 comments, 755 reads

Posted in SQLStudies on 29 June 2015

Older posts