-->
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: March 2018

What’s the difference between Files and Filegroups?

tl;dr; Filegroups are a logical construct used to separate tables and indexes from each other, files are the physical construct used to store information (log & data) about the database.

When creating a database you’ll notice that each database is built of several components. There are two files, one for… Read more

0 comments, 694 reads

Posted in SQLStudies on 28 March 2018

Introducing The Blame Game

Introducing the Blame Game! Someone has messed up the new anatomy application’s (Mr. Body) performance and no one is willing to fess up. It’s up to you to place blame where it’s due.

8 Characters you’ll recognize from your own meetings.
6 Mistakes you’ve probably made (more than… Read more

4 comments, 229 reads

Posted in SQLStudies on 26 March 2018

Moving a table using BCP and native format

You need to move a table from one instance to another with the following requirements:

  • The instances are on separate domains. In fact, you might be shipping the table to a vendor or client.
  • The destination is an actual SQL Server instance.
  • Can be automated on either end.
  • Quick and…

Read more

7 comments, 290 reads

Posted in SQLStudies on 21 March 2018

GDPR – After the restore

I joined in on an interesting conversation the other day on twitter. It was about some unusual ramifications of GDPR (The EU General Data Protection Regulation). In case you haven’t heard of GDPR (maybe you’ve been offline for the last few months?), the GDPR is some rather sweeping security… Read more

1 comments, 274 reads

Posted in SQLStudies on 19 March 2018

DB_NAME() vs ORIGINAL_DB_NAME()

I’d never seen ORIGINAL_DB_NAME until recently and I thought it would be interesting to highlight it out, and in particular the difference between it and DB_NAME. I use DB_NAME and DB_ID fairly frequently in support queries (for example what database context is a query running from or what database… Read more

1 comments, 2,639 reads

Posted in SQLStudies on 15 March 2018

A look back from the future. – TSQL Tuesday #100

The date is July 14th, 2026 and it’s TSQL Tuesday #200. We are still using SQL Server, and in fact SQL v2026.July.10 has just been released and v2026.July.25 announced.

Many things haven’t changed much in the last 8 years. For example:

  • Profiler is still deprecated.
  • msdb and SQL Agent haven’t…

Read more

3 comments, 244 reads

Posted in SQLStudies on 13 March 2018

Simply Debugging

Debugging is a life skill. Yes, the term comes from IT (literally removing a bug from a computer believe it or not) but the techniques are used all through life.

  • Why won’t my phone charge?
  • Why won’t the living room light turn on?
  • Why hasn’t that water boiled yet?!?

  Read more

3 comments, 1,964 reads

Posted in SQLStudies on 7 March 2018

SQL Homework – March 2018 – Recovery Objectives

My very first SQL Homework post was about taking a backup. The vast majority of people who work with databases (there might be some reporting people who are exceptions) need to know how to take a backup. If nothing else you need to know how to save your work.… Read more

0 comments, 217 reads

Posted in SQLStudies on 5 March 2018