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

What is impersonation for?

I was doing some research on impersonation the other day, and among other things, I ran across a forum question Use of IMPERSONATE permissions in SQL Server? I started reading the answer, and it seemed like a pretty good answer, well laid out, decent formatting etc. I was honestly shocked… Read more

3 comments, 659 reads

Posted in SQLStudies on 27 December 2017

Making music with Powershell

Happy holidays everyone! Ok, this isn’t even remotely related to SQL Server but it sounded fun. I found someone playing music using Powershell (I lost the link, sorry) and thought Christmas Music! (Yes, I’m Jewish and I probably should have done The Dreidel Song or something but I didn’t think… Read more

3 comments, 448 reads

Posted in SQLStudies on 20 December 2017

When do usernames and passwords belong in connection strings

tl;dr: When using a windows or active directory authenticated id you do not put the username or password into your connection string.

Quite possibly the most common question I get is “Why won’t my login connect to the database?”. And the most common response? You’re using it wrong.

In… Read more

0 comments, 568 reads

Posted in SQLStudies on 18 December 2017

How to: Create an Azure VM with SQL Server using a default template

One of the really cool things about the cloud is how quickly you can spin up a new machine to work with. In the case of SQL Server professionals we want SQL Server installed on that machine, and the easiest way to get it is to one of the default… Read more

1 comments, 412 reads

Posted in SQLStudies on 14 December 2017

T-SQL Tuesday #97 – Setting learning goals for 2018

T-SQL Tuesday. Each month a different blogger hosts Adam Machanic’s (b/t) blog party. The host comes up with a topic on the first Tuesday of the month, and everyone who want’s to participate blogs on that subject, posting on the second Tuesday of the month. This… Read more

3 comments, 1,526 reads

Posted in SQLStudies on 12 December 2017

Restrict the usage of a SQL Server Authenticated Application Id

SQL Server login ids may not be the most secure thing in the world but they are likely to be around for quite a while and one of the more common uses of them is as an application id. An application uses a SQL Server id to connect to SQL… Read more

1 comments, 1,571 reads

Posted in SQLStudies on 6 December 2017

SQL Homework – December 2017 – View the log

Last homework of the year. Last month was to create a view. This month it’s time to take a look in the log! No, not the transaction log. The SQL Server Log. Where error events, backup events, startup events etc, etc get stored. If something goes wrong on your… Read more

2 comments, 229 reads

Posted in SQLStudies on 4 December 2017