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

Archives: December 2010

A Collection of Good Information About Controlling VLFs in SQL Server

Because of the default settings in SQL Server (for the model database), and a lack of understanding about how the transaction log should be sized and maintained, I run into many databases that have a high number of virtual log files inside the transaction log file.

Even though I have… Read more

0 comments, 250 reads

Posted in Glenn Berry's SQL Server Performance on 27 December 2010

MCM Live Blog – Week December 27

Watching videos?! Su-ure!

Time for the third week of blogging about the things that I’m doing to study for the MCM exam. Last week wasn’t too spectacular – with the holidays and all I was pretty lazy on the studying.  The formatting issues did get fixed, so if you see… Read more

1 comments, 200 reads

Posted in StrateSQL on 27 December 2010

Meet a New Blogger: Malathi Mahadevan

My friend Malathi (Mala) Mahadevan has chaired the Louisville PASS Chapter for the past couple years, and will be heading up their second SQLSaturday in January 2011. She’s started a blog at http://beyondrelational.com/blogs/diligentdba/default.aspx that I wanted to share. Getting started and finding your voice takes time, hope you’ll follow along… Read more

1 comments, 314 reads

Posted in SQLAndy on 27 December 2010

Why I’m All For 24HOP Showcasing 24 Women Speakers

This is not the HOP you are looking for.

I’ve been thinking about the upcoming 24HOP event planned for March 15 and 16 which will showcase 24 women speakers. Karen Lopez (post | twitter), Jenn Stirrup (post | twitter), and Jen McCown (post | twitter Read more

0 comments, 412 reads

Posted in LittleKendra on 27 December 2010

Rebuilding my laptop

I finally got around to adding the new memory (16GB), removing the old 4GB and then replacing the DVD drive with an SSD. Now he hard part: rebuilding the machine.

In order to use the 16GB, and get VMs to run more smoothly, I need 64 bit Windows 7. I…

Read more

2 comments, 326 reads

Posted in The Voice of the DBA on 27 December 2010

MVP Program

There is one thing that have been bothering me for quite some time. I thought I would blog about it. (And make some enemies in the process :-))

The thing that bothers me is the working of the MVP Program or the lack of it. I have noticed at least… Read more

12 comments, 505 reads

Posted in RumblingDBA on 27 December 2010

The Twelve Days of (SQL) Christmas

Once upon a time a group of twelve bloggers agreed to each pick a post (or posts)  they found interesting from the previous year, blog about them, comment, and call attention to them. I was tapped to summarize things, and here we go.

On the twelfth day of Christmas Stuart… Read more

2 comments, 918 reads

Posted in The Voice of the DBA on 27 December 2010

Script Drop all tables of a database

Hi people, following a script that deletes all tables in a database. Enjoy.

 

SET NOCOUNT ON;
DECLARE @Tabela TABLE
(    Seq INT,
    Id INT,
    Name sysname);
DECLARE @Loop INT, @Qt INT;

 

-- While there ForeignKey exclude objects that are not referenced recursively

WHILE (SELECT COUNT(*) FROM… Read more

0 comments, 1,367 reads

Posted in Adeilson Brito on 27 December 2010

The MCM Journey

I’m not really planning on getting the MCM. Perhaps I’ll change my mind, but it’s not the time for me to do it. I’m not consulting, and not planning on doing it anytime soon. If I studied enough to pass the lab, likely my skills would atrophy without some… Read more

7 comments, 380 reads

Posted in The Voice of the DBA on 27 December 2010

SQL Server Storage Internals Part 5 - Properties of Clustered and Non Clustered Index pages

In this article, I thought of explaining different types and levels of index pages. but while start preparing for that, I realise , newbies need to understand concepts on Index architecture before moving on to see what is there inside index pages.

So, before going see internals of Clustered and NonClustered index pages, lets quickly recap some… Read more

11 comments, 3,871 reads

Posted in LivingForSqlServer on 27 December 2010

PBM and PowerShell

The best new management feature added to SQL Server 2008 is Policy Based Management or PBM. PBM allows DBAs to automate many of the traditional daily (or more frequent) checklists*. Although PBM is useable out-of-box there are several key features missing:

  • Unable to capture results of policy evaluations…

Read more

4 comments, 1,141 reads

Posted in Chad Miller on 25 December 2010

Merry Christmas

This is just a short post for a Friday and not just any old Friday either, Santa is on his way :-)

 

 

I would just like to wish everybody a very Merry Christmas.


Read more

2 comments, 185 reads

Posted in The SQL DBA in the UK on 24 December 2010

Get SQL Scripts Manager for Free

Red Gate Software has released a new, free tool for database administrators and developers called SQL Script Manager. It includes 25 scripts written by many well-known DBAs, such as Ola Hallengren, Louis Davidson, Glenn Berry, Tim Ford, and many more, that can help you to automate common troubleshooting, diagnostic,… Read more

0 comments, 360 reads

Posted in SQL Aloha on 23 December 2010

PASS Summit 2010 Session Eval Results

Speakers and bloggers alike crave feedback (good or bad) so I was excited to see my session evaluations from the 2010 PASS Summit arrive in my inbox this week. First I'll show the results, then I'll share some thoughts about them.

Eval Format
Eval forms had 6 questions with a… Read more

0 comments, 288 reads

Posted in Kendal Van Dyke on 23 December 2010

SQL Bits 8

It seems the dates for the next SQLBITS have been released will take between April the 7th and April 9th 2011.

Location: The Grand Hotel, Brighton


Read more

2 comments, 169 reads

Posted in The SQL DBA in the UK on 23 December 2010

PASS Summit Speaker Evals – THE ANALYSIS

Rule: No Sushi with Adam within 24 hours of session

I’m inspired by Brent Ozar‘s and Andy Leonard‘s sharing of their PASS feedback scores and comments. But first, I’m going to tell you how I think my PASS session went: I give it a C+. 118 people attended… Read more

2 comments, 240 reads

Posted in SQL Awesomesauce on 23 December 2010

PASS Summit 2010 Survey Results

As I have done in previous years, I’m going to post the results from my sessions at the PASS Summit. Feedback is a gift. I received a great many gifts this year and I’m extremely happy about all of them.

There are a set of questions with ratings, the… Read more

2 comments, 330 reads

Posted in The Scary DBA on 23 December 2010

Filling in Data Potholes with Recursive CTEs

Data: it can break your foot.

Imagine that you are writing a script that looks at data grouped by the minute. You notice that there are no rows for some minutes, and you’d like to display a value when that is the case, probably showing a count of zero.

In… Read more

0 comments, 494 reads

Posted in LittleKendra on 23 December 2010

Spreading the DBA Gospel (from Old English, god spell "good news")

 

There are times when I wonder why I get so few comments on this blog, however there are assumptions I have made which were confirmed to me recently again by those who wrote to me directly, or spoke with. Some told me that fewer comments are a good thing… Read more

0 comments, 396 reads

Posted in The Database Hive for SQL Server DBAs on 23 December 2010

Video: Efficiency and Effectiveness at work

In this vblog entry on www.SQLServerPedia.com shows SQL Server expert Kevin Kline discussing his views on how to be both efficient and effective in your day to day and career – aimed at the SQL Server professional, but good for anyone.

Posted August 08, 2008.

Read more

0 comments, 170 reads

Posted in Kevin E. Kline on 23 December 2010

Newer posts

Older posts