Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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.

Granting or denying permissions to all of the tables within a database

When granting or denying permissions to the tables within a database you have two options. You can either add the user/role to one of the preexisting database roles

  • Db_datareader – grants SELECT to all tables & views in a database
  • Db_datawriter – grants INSERT, UPDATE and DELETE to all tables…

Read more

2 comments, 1,677 reads

Posted in SQLStudies on 15 May 2014

T-SQL Tuesday #54: Interviews!

It’s T-SQL Tuesday again and this month our host is Boris Hristov (b/t). He has asked us to discuss Interviewing. (If I was his boss I might be wondering if he was looking for tips. :) )

Interviewing is hard. You are trying to find that… Read more

1 comments, 822 reads

Posted in SQLStudies on 13 May 2014

Does SQL Server do a CHECKDB during an instance restart?

When you start up an instance do you rely on the CHECKDB entry in the error log of SQL Server to tell if your databases are corrupt? You shouldn’t be.

Ever wonder why the CHECKDB can run so fast when you start up your instance but takes so long when… Read more

10 comments, 1,454 reads

Posted in SQLStudies on 7 May 2014

Why is there a sysobjects when we already have sys.objects?

Once upon a time in a version of SQL far far away we had system tables that were easy to see and could even be updated. One day one of these system tables “sysobjects” went to its fairy god-corporation Microsoft and begged to be hidden away from its mean step-dbas… Read more

0 comments, 168 reads

Posted in SQLStudies on 5 May 2014

DBA Myths: TRUNCATE TABLE deletes all the rows of a table instantly.

Most DBAs and developers I’ve talked to over the years have felt that TRUNCATE TABLE is an instant DELETE. However would you believe that it doesn’t actually delete the data from the pages at all? Here is an example:

-- Setup code
CREATE DATABASE TruncateTest
GO
USE TruncateTest
GO
CREATE…

Read more

7 comments, 906 reads

Posted in SQLStudies on 30 April 2014

The default autogrowth settings do NOT come from the Model database.

I recently saw a question about How to inherit autogrowth settings. They commented that while the new database GUI seemed to inherit the autogrowth settings from the model DB the CREATE DATABASE command did not. Now my initial reaction was “Of course the autogrowth settings are pulled from model.… Read more

1 comments, 198 reads

Posted in SQLStudies on 28 April 2014

Collation: Confusion

I started reading about collations after I had a recent run in with them. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out.

In Europe, Canada and… Read more

0 comments, 1,576 reads

Posted in SQLStudies on 23 April 2014

Collation: Confusion

I started reading about collations after I had a recent run in with them. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out.

In Europe, Canada and… Read more

0 comments, 79 reads

Posted in SQLStudies on 23 April 2014

Collation: Temporary objects and variables: Demonstration

I had a recent run in with collation problems and it got me started reading about them. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out.

I’ve… Read more

0 comments, 29 reads

Posted in SQLStudies on 21 April 2014

Collation: Temporary objects and variables: Demonstration

I had a recent run in with collation problems and it got me started reading about them. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out.

I’ve… Read more

4 comments, 913 reads

Posted in SQLStudies on 21 April 2014

Who is an expert?

Recently Paul Randal had a brief rant on twitter where he complained about the fact that there are no stupid questions. This lead to a discussion on and how experts should and should not react to said questions. I’ve been thinking about what makes up a stupid question and what… Read more

9 comments, 172 reads

Posted in SQLStudies on 16 April 2014

Who is an expert?

Recently Paul Randal had a brief rant on twitter where he complained about the fact that there are no stupid questions. This lead to a discussion on and how experts should and should not react to said questions. I’ve been thinking about what makes up a stupid question and what… Read more

9 comments, 25 reads

Posted in SQLStudies on 16 April 2014

Collation: Correction -> Instance

I had a recent run in with collation problems and it got me started reading about them. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out.

You’ve… Read more

0 comments, 33 reads

Posted in SQLStudies on 14 April 2014

Collation: Correction -> Instance

I had a recent run in with collation problems and it got me started reading about them. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out.

You’ve… Read more

0 comments, 103 reads

Posted in SQLStudies on 14 April 2014

Collation: Correction -> Expression, Column, Database

I had a recent run in with collation problems and it got me started reading about them. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out.

You’ve… Read more

0 comments, 157 reads

Posted in SQLStudies on 10 April 2014

Collation: Correction -> Expression, Column, Database

I had a recent run in with collation problems and it got me started reading about them. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out.

You’ve… Read more

0 comments, 26 reads

Posted in SQLStudies on 10 April 2014

T-SQL Tuesday #53: Why so serious

Why so serious? If you ask anyone who knows me they will tell you I’m not a terribly serious person. Add that to the comment “Mess with your co-workers” and I was hooked on this one. T-SQL Tuesday this month is hosted by Matt Velic (b/t)… Read more

4 comments, 30 reads

Posted in SQLStudies on 8 April 2014

T-SQL Tuesday #53: Why so serious

Why so serious? If you ask anyone who knows me they will tell you I’m not a terribly serious person. Add that to the comment “Mess with your co-workers” and I was hooked on this one. T-SQL Tuesday this month is hosted by Matt Velic (b/t)… Read more

4 comments, 873 reads

Posted in SQLStudies on 8 April 2014

Microsoft announces that it will no longer support SQL Server and that SQL 2014 was an April Fools Joke!

Microsoft has announced that SQL 2014 was in fact an elaborate April Fool’s joke and that Microsoft intends to move even farther into the cloud. Microsoft’s new CEO Satya Nadella announced this morning

“We felt that by creating such an elaborate prank it would soften the blow. Microsoft will no…

Read more

4 comments, 289 reads

Posted in SQLStudies on 1 April 2014

Microsoft announces that it will no longer support SQL Server and that SQL 2014 was an April Fools Joke!

Microsoft has announced that SQL 2014 was in fact an elaborate April Fool’s joke and that Microsoft intends to move even farther into the cloud. Microsoft’s new CEO Satya Nadella announced this morning

“We felt that by creating such an elaborate prank it would soften the blow. Microsoft will no…

Read more

4 comments, 24 reads

Posted in SQLStudies on 1 April 2014

Newer posts

Older posts