Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: November 2009

weekly update

Well I said that I would try to post regularly and seeing as its Sunday and I haven’t posted for nearly a week I thought I better type something up.

I haven’t worked out how to incorporate this blog into my website yet (www.gre-sqlserver-solutions.com) but when I do hopefully the…

Read more

0 comments, 176 reads

Posted in The SQL DBA in the UK on 29 November 2009

Picking a Branch

Do you know that there are actually two branches of SQL Server 2008 code right now? Actually I would bet there are 3 branches, but we have two publically available branches to choose from:

  • The RTM branch
  • The Service Pack 1 branch

I’ve known this for awhile, but haven’t thought… Read more

1 comments, 277 reads

Posted in The Voice of the DBA on 27 November 2009

Book Review: Let’s Create (for children)

I’m fond of browsing the discount shelf at the bookstore, it’s another way to see books that I might otherwise miss, tending to spend my time around the business and computer section. I found Let’s Create for a mere $2.99 and decided to get it, nothing makes for good family… Read more

2 comments, 132 reads

Posted in SQLAndy on 26 November 2009

Ola Hallengren Updates Free Database Maintenance Scripts to Support SQLBackup 6.3

Ola Hallengren has recently updated his popular free SQL Server database maintenance scripts to support the newest point release of SQLBackup 6.3.

For those of you who are not familiar with Ola’s database maintenance scripts, they are designed to help you backup, optimize indexes, and perform integrity checks on… Read more

0 comments, 703 reads

Posted in SQL Aloha on 26 November 2009

PASS European Conference 2010 Call for Speakers is Open

If you are interested in speaking at the PASS European Conference 2010, to be held in Neuss, Germany, April 21-23, 2010, the call for speakers is open at this link, and will close 1-1-2010.

If your not interested in speaking, but would like to attend the event, PASS… Read more

0 comments, 165 reads

Posted in SQL Aloha on 26 November 2009

Ft. Worth SQL Server User Group Meeting Recap

I’d like to say thanks to Andy and Judith over at the Ft. Worth SQL Server User Group for having me as a guest last Wednesday.  I got to meet a few new people, and meet up with several others whom I hadn’t seen in a while.  I look forward… Read more

0 comments, 262 reads

Posted in Tim Mitchell on 26 November 2009

Adios

If all goes well, by the time you read this on Thanksgiving I’ll be up in the mountains of Colorado. No SQL Server questions to answer, no editorials to write, no articles to edit.

I think I say it often, but it bears some repeating. Get away from your day… Read more

1 comments, 224 reads

Posted in The Voice of the DBA on 26 November 2009

Thanksgiving This Year, Stress, Cooking Something New, and Others

I know Thanksgiving has some deeper meanings, but at one level it’s all about the food. Food is a good way to celebrate family, having foods that you all enjoy and evoke good memories. However, cooking all that food isn’t always simple and is often stressful. Some years we’ve opted… Read more

0 comments, 165 reads

Posted in SQLAndy on 25 November 2009

The Sequels for SQL Server: The Week of November 27, 2009

Just as an FYI, I’ve added one new slide deck and webcast to http://KevinEKline.com/Slides/, as well as quite a few upcoming user group events where I’m speaking in http://KevinEKline/Upcoming-Events/.

I’m starting a new series called Sequels for SQL Server.  In this series, I point you to sites… Read more

0 comments, 279 reads

Posted in Kevin E. Kline on 25 November 2009

To Grant or Not to grant

It is said that you should not give direct table access (even select permission) to a user or group. But with the new ORM tools like N-Hybernate what do we do? N-Hybrbate is not designed for Stored Proc access. They are not even planning to have Stored proc support. So… Read more

2 comments, 154 reads

Posted in RumblingDBA on 25 November 2009

In Charge

I had to run our weekly conference call this week. My boss is out of the office, but he’s been trying to get everyone to participate by having different people run meetings on different weeks. I’m not the best employee in this sense, and not always prepared, so I’ve tried… Read more

0 comments, 200 reads

Posted in The Voice of the DBA on 25 November 2009

A good way to learn

I have noticed that one of the best way to learn about a certain topic is to write an article regarding it. When you do write an article, it forces you to do some research, read lots of documents and then try it out. You do not want to give… Read more

3 comments, 193 reads

Posted in RumblingDBA on 25 November 2009

Cleaning out Tempdb

I saw a post recently about the tempdb being overly large and causing issues for a user. The person was having issues shrinking the files and wasn’t sure what to do. Someone else responded that snapshot isolation might be an issue and I found that interesting. I hadn’t thought about… Read more

0 comments, 1,125 reads

Posted in The Voice of the DBA on 25 November 2009

More on DBAs and Local Administrator Rights

I'm looking over the comments about DBAs and local Administrator rights and I noticed an interesting trend: no one discussed the separation of duties aspect. Basically the comments that were returned either said, "DBAs should have that knowledge," or "You can't do the job without it because..." so let's took a… Read more

6 comments, 1,031 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 25 November 2009

SQL Server 2008 Diagnostic Information Queries (Late November 2009)

Here is the latest version of my Diagnostic Information Queries for SQL Server 2008.  Running these queries will give you a pretty good idea about the configuration and health of your server and about any particular databases on the server.

I have added several new queries this time, and tweaked… Read more

2 comments, 1,191 reads

Posted in Glenn Berry's SQL Server Performance on 24 November 2009

Opening Doors – Part 3

Earlier this week I posted Part 1 and Part 2, today I want to wrap up by thinking about how to handle success and judging success. I think that’s important, because I’m advocating that you (and me) put some extra effort into something that is speculative. No guarantees you help… Read more

0 comments, 122 reads

Posted in SQLAndy on 24 November 2009

Planning Your 2010 Professional Development

Virtually all successful DBAs I know put a lot of focus on education, and the best way to make it happen is to create your own professional development plan for the new year. This way, you will be better able to find time (and resources) to accomplish your learning goals. Read more

0 comments, 160 reads

Posted in SQL Aloha on 24 November 2009

The most optimal join type

What’s the best join type for a query? Should we aspire to seeing nested loop joins in all our queries? Should we tremble with horror at the sight of a hash join?

Well, it depends.

There’s no single join type that’s best in every scenario and there’s no join type… Read more

0 comments, 295 reads

Posted in SQL In The Wild on 24 November 2009

Planning Out a Holiday Weekend

I've got a four day weekend thanks to the Thanksgiving holiday here in the United States. After reading Jazz in the Bittersweet Blues of Life, and reading of the kind of schedule Wynton Marsalis' father, Ellis kept in order to feed his family and teach the next generation of… Read more

SQL Server 2008: Table-valued parameters

A new feature of SQL Server 2008 is Table-valued parameters (TVP).  This feature will allow Developers and DBAs to pass tables as parameters to stored procedures.  You cannot pass a variable table or temp table, you can only pass a Table Type, which is an alias data type or a…

Read more

0 comments, 294 reads

Posted in SQLDownSouth on 24 November 2009

Newer posts

Older posts