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

Using Microsoft Learn

I’ve just signed up on Microsoft’s new learning opportunity Microsoft Learn. The main categories are Azure, Business Apps, and Windows Development. There seem to be quite a few classes for each category and at that this is still fairly new and I expect it will grow over time. Everything… Read more

3 comments, 404 reads

Posted in SQLStudies on 31 December 2018

Identity in a SELECT

Always be learning right? So when I saw this I had to go HU?! That’s new. What’s going on here?

SELECT
	IDENTITY(INT, 1,1) AS Id,

Now, looking at it a bit more closely you’ll see that this is a function call, not just a property. Now, in my… Read more

4 comments, 3,835 reads

Posted in SQLStudies on 19 December 2018

Savings changes is not permitted. The changes you have made require the following tables to be dropped and re-created.

Microsoft does a lot of things to try to help us not shoot ourselves in the foot. This little error is one of them. It’s an annoying error, and almost everyone turns it off automatically, so what is it and why is it there? Well, by default, when using the… Read more

4 comments, 965 reads

Posted in SQLStudies on 17 December 2018

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

1 comments, 326 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, 194 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, 869 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, 190 reads

Posted in SQLStudies on 3 December 2018