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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

 

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

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