-->
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.

Bulk insert and an identity column

TL;DR; BULK INSERT doesn’t have an easy way to specify a column list so the columns in the insert file must match the columns in the table unless you use a format file or a staging table.

As simple as they appear on the surface identity columns are fairly complicated… Read more

0 comments, 71 reads

Posted in SQLStudies on 12 December 2018

Moving SSISDB is not as easy as it sounds

We’ve been doing a lot of upgrading recently and at one point had to move an instance from one 2016 server to another. In the process, we found out (the hard way) that it’s not that easy to move SSISDB (the SSIS Catalog that may or may not be named… Read more

0 comments, 89 reads

Posted in SQLStudies on 10 December 2018

UDL files and connection strings

A co-worker showed me a really neat trick the other day. We deal with a lot of connection problems and one of the first places I look is the connection string. Now I’ve gotten pretty good at it over the years and more often than not I can point to… Read more

0 comments, 708 reads

Posted in SQLStudies on 5 December 2018

SQL Homework – December 2018 – Configure SSMS

I’ve committed to posting a piece of homework for you to do each month. I post at the beginning of the month to give you plenty of time to get these done. They are basic tasks that we can all use practice on. For this month check your SSMS (SQL… Read more

0 comments, 103 reads

Posted in SQLStudies on 3 December 2018

Oh Query, Query, Query

I thought I would post this a bit early so everyone can memorize the words before Hanukka starts next week.

I have a little query
I wrote it in a day
And when it’s fixed and ready
My query I shall run

Oh, query, query, query
I wrote it in… Read more

0 comments, 139 reads

Posted in SQLStudies on 28 November 2018

My backup script (where, how, how big, etc.)

A while back I wrote about how to find where your backups are. And I’ve also written about I use a solution in SSMS to hold a bunch of my scripts. I was using this again today (I use it a lot!) and thought I would bring… Read more

4 comments, 1,756 reads

Posted in SQLStudies on 26 November 2018

The Cloud and Shadow IT.

Shadow IT has been, well, maybe not the bane of the IT department, but certainly a pain in the neck. On the off chance you’ve never heard of shadow IT do any of these sound familiar?

  • A user asks you to restore a corrupt database on a SQL Server you’ve…

Read more

2 comments, 791 reads

Posted in SQLStudies on 21 November 2018

Dealing with multiple AD accounts

To help promote the seperation of duties one of the things my company has done is to divide our permissions into two accounts. We have one account that is for our daily tasks. Reading email, searching the internet, basic structure changes in a database etc. The other account is our… Read more

7 comments, 2,148 reads

Posted in SQLStudies on 19 November 2018

Parameterized dynamic SQL is parameterized.

Ok, that title sounds silly, but it’s actually a real point. The first parameterized refers to using parameters within dynamic SQL, while the second refers to how the optimizer treats parameters differently from variables. When you use parameterized dynamic SQL with sp_executesql SQL server treats the parameters as actual parameters not… Read more

3 comments, 2,269 reads

Posted in SQLStudies on 15 November 2018

T-shaped knowledge and learning about the cloud: T-SQL Tuesday #108

Upper management at my company has started asking for something called T-Shaped knowledge. The idea is that we have a broad range of knowledge in an area that may not be overly deep and one or more spikes of deeper knowledge. I have to admit, up to this point my… Read more

5 comments, 139 reads

Posted in SQLStudies on 13 November 2018

Missing those we’ve lost

It’s the start of Summit for many of us (not me, sorry) and it seemed like a good time to highlight a few of those we’ve lost way too soon. Below are members of the SQL community sometimes called the #sqlfamily who’ve we’ve lost in the last year. I didn’t… Read more

3 comments, 141 reads

Posted in SQLStudies on 7 November 2018

SQL Homework – November 2018 – Constraints

You’ve created tables before but how about constraints? Constraints allow a finer level of control over what data is allowed into a given field or combination of fields. Basically, you are putting in some form of business logic. The benefit is that this logic remains in place regardless of how… Read more

2 comments, 1,850 reads

Posted in SQLStudies on 5 November 2018

Zombie SQL

It Halloween so time for a scary SQL story. Ok, maybe not that scary. Ok, not scary at all, but still a bad practice. It’s Zombie code so it seemed like something fun to talk about on Halloween. But what is it?

 
Zombie Code

Code that is left in…

Read more

2 comments, 2,659 reads

Posted in SQLStudies on 31 October 2018

Blogger Questions: What if I get a mean/rude comment?

There is a fear that almost every blogger has to overcome. I’ll be honest, it pops up almost every time I hit schedule on a post.

What if my post sucks? What if someone tells me it sucks?

After 6 years of blogging, I finally got one! (Yes, I was… Read more

10 comments, 228 reads

Posted in SQLStudies on 29 October 2018

I’m in a book! Data Professionals at Work

A while back a friend of mine, Malathi Mahadevan (b/t), asked me if I’d like to do an interview for a book she was working on. I’ve been interviewed before but never quite like this. She called me up (on skype if I remember correctly) and… Read more

2 comments, 168 reads

Posted in SQLStudies on 24 October 2018

How do I look at my error log if SQL won’t open?

Quick and easy post today. Hopefully you’ve opened the error log on a SQL instance. However, what happens if you don’t have the log viewer in SSMS? In fact, the instance won’t come up at all so you really need to see what went wrong.

Fortunately, the error logs… Read more

1 comments, 2,476 reads

Posted in SQLStudies on 22 October 2018

What is the Object Explorer Details tab good for?

For a long time there I would see the Object Explorer Details tab show up when I opened SSMS (SQL Server Management Studio) and I would immediately close it. I couldn’t think of a single use for this view that seemed to be just another way to see the list… Read more

0 comments, 197 reads

Posted in SQLStudies on 17 October 2018

Highlighting sp_spaceused

I’ve been using sp_spaceused a lot recently so I thought I would bring it up again. Basically it’s a quick way to bring up the size of things. Specifically:

  • Tables
  • Indexed views
  • Service Broker queues
  • Databases

 
It’s the first and last that I use the most often. It’s… Read more

0 comments, 172 reads

Posted in SQLStudies on 15 October 2018

Which is faster? IN (list) or IN (SELECT FROM Temp)

If you’ve done much with IN (list) then you’ve realized that it basically translates out to

col=val1 OR col=val2 OR ....

You’ve probably also realized that you can throw all the values into a temp table and do this

SELECT *
FROM tablename
WHERE col IN (SELECT col FROM #temp

Read more

8 comments, 2,317 reads

Posted in SQLStudies on 11 October 2018

Letting the business bully you: T-SQL Tuesday #107

Before I start anything I want go give a disclaimer. I absolutely believe that the business should be involved in every stage of a project. When it comes down to it they are who we do the work for. That said, Introduction!

This is T-SQL Tuesday, the long-running blog… Read more

1 comments, 186 reads

Posted in SQLStudies on 9 October 2018

Older posts