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.

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, 42 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, 155 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, 117 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, 222 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,409 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, 160 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, 851 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, 137 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,680 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,490 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, 697 reads

Posted in SQLStudies on 29 June 2015

Which user function do I use?

Earlier this week I was scripting out a table with some legacy columns (InsertDate and InsertBy for example). If you have created these type of columns before you have probably put a default on each. InsertDate is pretty easy, probably something like GETDATE() or GETUTCDATE(). But what do you… Read more

0 comments, 1,490 reads

Posted in SQLStudies on 24 June 2015

Copying a TDE database from one instance to another

I got my first real world experience with a TDE (transparent data encryption) database recently. For those who don’t know TDE encrypts all of the data at rest. So the database files are encrypted and the backup is encrypted. The data is automatically decrypted as you read it and encrypted… Read more

0 comments, 147 reads

Posted in SQLStudies on 22 June 2015

Pass TV

Recently Adam Machanic (b/t) was telling me about an interesting effect of the top operator. When I asked for an example he pointed me to a few of his sessions from various Pass Summits. They are amazing and I recommend watching them, but they… Read more

3 comments, 172 reads

Posted in SQLStudies on 17 June 2015

Rename a database

Renaming a database isn’t something you do frequently but it does have bit of a gotcha. First of all let’s go over how you actually rename the database. It’s pretty simple.

SSMS
Right click on the database name in the object explorer and select rename or highlight the name and… Read more

3 comments, 145 reads

Posted in SQLStudies on 15 June 2015

Modifying the “New Query” template.

TLDR; Search for and modify the sqlfile.sql file.

During a recent T-SQL Tuesday Boris Hristov (b/t) taught me about SET NOEXEC ON in his post Teaching and Learning. The NOEXEC Thing. When this setting is turned on queries in the current window are compiled but not… Read more

7 comments, 1,963 reads

Posted in SQLStudies on 11 June 2015

A walk-through of creating the Activity Tracking template using Extended Events.

It’s the second Tuesday of the month and that means T-SQL Tuesday time! T-SQL Tuesday is a blog party started by Adam Machanic (b/t) over 5 years ago. Each month a different blogger will present an idea to blog on. Side note: If you are having… Read more

2 comments, 1,347 reads

Posted in SQLStudies on 9 June 2015

Clean up all (most) of the orphans on an instance

Recently we have been doing a number of instance moves as part of a large upgrade project. And as anyone who’s done many of these types of moves knows, orphans are a big pain. You backup your database from one server and restore it to another and all of a… Read more

3 comments, 1,242 reads

Posted in SQLStudies on 3 June 2015

Yet one more quick and easy performance tuning setting

I blogged in the past about two simple commands that can be a big help in performance tuning SET STATISTICS IO and SET STATISTICS TIME. Well I learned a new one recently. Client Statistics Unfortunately there is no t-sql command to turn it on but it’s not terribly difficult.

Query->Include… Read more

1 comments, 171 reads

Posted in SQLStudies on 1 June 2015

Multiple Windows Groups with different default databases

A question came up at work the other day, mostly as a mind game, but you never know it might actually come up at some point. So here is the idea.

  • UserA is a member of Group1, Group2 and Group3.
  • Group1 is set up as a server principal with a…

Read more

2 comments, 881 reads

Posted in SQLStudies on 28 May 2015

Older posts