-->
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: July 2016

When was this database restored?

I frequently need to know where backups went and I restore those backups for operational recovery on a regular basis. Would you believe in 20+ years as a DBA I can count the number of database restores for a disaster on my fingers? (Which is good because taking off your… Read more

4 comments, 499 reads

Posted in SQLStudies on 27 July 2016

Blogger Questions: What should I blog about?

Over the last four years I’ve blogged almost 400 times. It’s become a refuge, a resource, a source of pride, and a pleasure. I started out trying to build an on-line resume (just in case) and over time it’s evolved like crazy. I’ve become a huge proponent of blogging and… Read more

2 comments, 276 reads

Posted in SQLStudies on 25 July 2016

Want to be able to read your database between restores?

When restoring a database there are times when it would nice to restore a bit, check what’s been restored so far, restore a bit more etc. However, traditionally most people only know RECOVERY and NORECOVERY. This means that you restore to a point in time. Check the data and… Read more

0 comments, 618 reads

Posted in SQLStudies on 20 July 2016

Is the network your last performance bottleneck?

Let’s say your company relies on the cloud for its servers (or maybe not, on premise networks have more options but they still have their limits). Performance is important so you’ve tuned every query, you’ve tested and adjusted each of the server settings. The cloud gives you limited control over… Read more

6 comments, 277 reads

Posted in SQLStudies on 18 July 2016

Altering a column in a large table: A case study

Fair warning, this is a discussion piece. I had a task, I went through several possibilities and I’m going to share each of them and the results of those I tried. I will not be giving any specific examples or code. Feel free to give me your opinion in the… Read more

10 comments, 748 reads

Posted in SQLStudies on 14 July 2016

Default database file sizes

It’s Chris Yates (b/t) birthday! (I think he just tured 19.) And in honor of his birthday we are writing blog posts! Well, technically it’s T-SQL Tuesday again, but we can pretend we are writing for Chris’ birthday. In fact that’s the subject he’s selected. “Give… Read more

5 comments, 524 reads

Posted in SQLStudies on 12 July 2016

Zilch to Speaker: 2016 Summit Abstract Reviews

Steve Jones (b/t) has been asking people to post their Pass Summit submissions and the reviews that came back, along with maybe a few words about what they thought, so here we go.

I submitted two sessions. One I’d given before (including at Summit 2015), and… Read more

4 comments, 305 reads

Posted in SQLStudies on 7 July 2016

Phantom SSIS Changes

That SSIS change just won’t stick! There is a new business requirement, so now you have to change an existing SSIS package. You opened up a new project, imported the package, and made your changes.

Adding the original package to the new project.

Changes made to the old package in…

Read more

0 comments, 811 reads

Posted in SQLStudies on 5 July 2016