-->
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: October 2015

Who’s on call


Of all the posts I’ve written I think this one is my favorite, even though it’s not a technical post.  So while I’m at Summit (I’m even presenting today!) I thought I would re-post it for your enjoyment.

The new IT manager (Lou) walks into the DBA manager’s office… Read more

0 comments, 349 reads

Posted in SQLStudies on 28 October 2015

Finding and keeping your #SQLPassion

I consider myself lucky. I fell into a job that I truly enjoy, something that I do for fun even when I don’t have to. A job, a technology and a community that I’m truly passionate about. Unfortunately maintaining that passion can be a bit difficult at times. And I’ll… Read more

1 comments, 343 reads

Posted in SQLStudies on 26 October 2015

Generating scripts for previous versions of SQL

I make a habit of using the latest version of SSMS even if I’m not working with the latest version of SQL Server. For example right now at home I’m using SSMS 2016 even though I frequently work with SQL Server 2014 or 2012. Well this can cause a bit… Read more

1 comments, 1,422 reads

Posted in SQLStudies on 21 October 2015

Working with “special” names

What do you do when you need to use a special character in a name? Well, I guess I should define what I mean by special first. Special characters are any non-alphanumeric character, so &#!~\/ etc, including spaces. It’s really pretty easy. Put []s around the name. Now you can… Read more

4 comments, 1,338 reads

Posted in SQLStudies on 19 October 2015

“That little green arrow.” or “My code used to work but now I’m getting a debug error.”

If you’ve worked with SSMS for any length of time this will look awfully familiar:

SSMS 2008R2

SSMS 2012 +

This little green arrow turns on the Transact-SQL Debugger. I have to wonder how this feature is actually used on purpose. I mean I’m sure people do, I’ve just… Read more

3 comments, 341 reads

Posted in SQLStudies on 15 October 2015

Keep an eye on those Audit files!

This month’s T-SQL Tuesday (#71) is hosted by Sebastian Meine (b/t). He has picked an interesting security subject. SQL Server Audits. Fortunately this is one I have a bit of experience with. It’s one of my favorite new features if only because it’s so simple to… Read more

0 comments, 334 reads

Posted in SQLStudies on 13 October 2015

Finding the error from a failed job.

This is a fairly simple one once you’ve seen it, but then so are lots of things :). Let’s say you have a failed SQL Server job.

Here is our job that will fail:

Pic1

Then we run it and it fails!

And when we click on the error… Read more

4 comments, 1,948 reads

Posted in SQLStudies on 7 October 2015

The powerpoint for my SQL Server Security Basics session

Well I’ve done it. I’ve spoken at an event. I’ll discuss how I felt about it and what I learned along the way a bit later. But in the mean time I promised I would make the PowerPoint for my SQL Server Security Basics session available on my blog and… Read more

2 comments, 334 reads

Posted in SQLStudies on 5 October 2015