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

Azure quick start

In case you hadn’t noticed, I love built in help. DBCC HELP, the script button in SSMS, even BOL. Well here’s another one.

Throughout the Azure portal you will find buttons called Quick Start. You won’t find it everywhere but I’ve found it in the Resource… Read more

1 comments, 177 reads

Posted in SQLStudies on 30 January 2017

My SQL logins don’t work. Again.

My recent post on why SQL logins aren’t working has generated a couple of follow up posts. The first one was on how to create a connect item and then this one. It was pointed out to me that the errors in the log have quite a bit more information… Read more

0 comments, 2,006 reads

Posted in SQLStudies on 25 January 2017

Creating a connect entry.

I recently wrote a blog about how to tell why your SQL login isn’t working. There were a lot of good comments and several of them suggested that I create a connect entry to make the error easier to understand. There was also a question of how to create… Read more

4 comments, 862 reads

Posted in SQLStudies on 23 January 2017

Lead Blocker

Blocking is just part of life I’m afraid. Because we have locks (and yes we have to have them, and no, NOLOCK doesn’t avoid them) we will have blocking. Typically it’s going to be very brief and you won’t even notice it. But sometimes you get a query or… Read more

7 comments, 235 reads

Posted in SQLStudies on 18 January 2017

What is COPY_ONLY?

You’ll frequently hear that you should add the COPY_ONLY clause when taking an ad-hoc full backup to avoid messing up the backup chain. Just in case you haven’t: You should add the COPY_ONLY clause when taking an ad-hoc full backup to avoid messing up the backup chain.

But you may… Read more

2 comments, 2,011 reads

Posted in SQLStudies on 16 January 2017

Why won’t my SQL Logins work?

I recently had an interesting time getting the SQL Auth logins on a new instance working. I was doing a side by side upgrade and the only server principals used by the application were SQL Server authenticated logins. I tried over and over again but kept getting the same error. Read more

10 comments, 515 reads

Posted in SQLStudies on 12 January 2017

Connect suggestion to add included columns to sp_helpindex

I’m a big fan of the sp_help system stored procedures, which is why I’ve been a bit disappointed that the sp_helpindex stored procedure is rather badly flawed. It doesn’t have the included columns from the index. This seems a bit strange to me since included columns first appeared in… Read more

0 comments, 233 reads

Posted in SQLStudies on 10 January 2017

A detailed view into your Azure resources

I’ve been studying Azure recently and came across a really interesting Azure site.

resources.azure.com

To give you an idea why I find this view so interesting I’m going to drill down to a SQL Database that I have.

Up front, you can see some interesting information. The location, status, service… Read more

0 comments, 1,137 reads

Posted in SQLStudies on 5 January 2017