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

The CONNECT permission

The CONNECT permission exists at the instance and database levels. Note: as of SQL 2012 it is CONNECT SQL at the instance level, but prior to that it was just CONNECT. It does basically the same thing in both cases. The CONNECT permission allows you to connect to the associated… Read more

6 comments, 1,457 reads

Posted in SQLStudies on 27 January 2016

Reusing schedules in SQL Agent

I’m a big fan of automation. You get it written, tested, and scheduled, then you just sit back and monitor for unexpected problems (because if they are expected you fixed them right?). One common place for us SQL people to do our automation is SQL Agent. It’s built into SQL… Read more

1 comments, 1,337 reads

Posted in SQLStudies on 25 January 2016

Start SQL Server without tempdb

tl;dr; Re-start the instance in safe mode (-f startup parameter) and move tempdb. Then re-start without the parameter.

While at the 2015 Summit I walked into the last few minutes of Russ Thomas’s (b/t) session on Stress Inoculation: Maintaining Performance Under Pressure. As a side… Read more

1 comments, 797 reads

Posted in SQLStudies on 20 January 2016

To the page and back again

To the page

It’s not one of those things you have to do frequently but every now and again you need to know what page a particular row is on. It’s not terribly difficult. There is a virtual column called %%physloc%%, but unfortunately it’s not terribly useful on it’s… Read more

1 comments, 350 reads

Posted in SQLStudies on 18 January 2016

What is RESULT SETS?

I was reading some code the other day and it included the statement RESULT SETS. I’d never seen it before so it seemed worth a quick look. I’ll warn you in advance this is somewhat of a BOL blog post. I’m basically taking what you can find in BOL… Read more

10 comments, 3,411 reads

Posted in SQLStudies on 14 January 2016

Ad-hoc Changes

TSQL Tuesday #74: Be The Change

Each month, on the first Tuesday of the month, the announcement for the blog party T-SQL Tuesday comes out. Those that are interested then post their blogs, on the subject selected, on the second Tuesday of the month. If you’ve never heard of T-SQL… Read more

4 comments, 1,300 reads

Posted in SQLStudies on 12 January 2016

MSDTC Requirements for SSIS Transactions

MSDTC is frequently required when using transactions within SSIS. And not just when you are connecting to two SQL Server instances.

Disclaimer: Neither SSIS nor MSDTC are my strongest skills. So while the information here is correct (to the best of my knowledge) I won’t make any claims as to… Read more

2 comments, 2,556 reads

Posted in SQLStudies on 6 January 2016

2015 a year in review

It’s a new year, so time to look back at the previous year, and forward to the next. I’ll tell you up front, this post is more for me than you. It’s a way to catalog my year and make some goals for the future. That being said I’d of… Read more

7 comments, 303 reads

Posted in SQLStudies on 4 January 2016