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

Archives: December 2009

Running a Small User Group - Getting Help

When we first started Midlands PASS, we tried to do it the way PASS suggested. We tried to get folks together to work on a set of bylaws, and the first try floundered. Myself and one other person attending the first organizational meeting. Needless to say, we tabled the… Read more

Outlook or LinkedIN

Funny the things you don’t think about until you hear someone doing it a different way. In this case it was at the December oPASS meeting and Kendal Van Dyke was talking entering business cards he had gathered at PASS and how long it took. I remarked that I’ve stopped… Read more

2 comments, 209 reads

Posted in SQLAndy on 28 December 2009

Fun With DBCC FREEPROCCACHE

Nearly anytime you see the command DBCC FREEPROCCACHE mentioned in a blog post, magazine article or book, you get some sort of a scary warning about how you should not use it on a production system, or else life as we know it will end. For example, Books Online says… Read more

18 comments, 11,765 reads

Posted in Glenn Berry's SQL Server Performance on 28 December 2009

Where’s My Laptop

It’s been almost 4 weeks without my laptop. I mailed it back to Toshiba and they received it on Dec 4. They then worked on it, and I got a few updates before they shipped it back on Dec 13, which was within their 7-10 business day window. I got… Read more

0 comments, 268 reads

Posted in The Voice of the DBA on 28 December 2009

Where’s My Laptop

It’s been almost 4 weeks without my laptop. I mailed it back to Toshiba and they received it on Dec 4. They then worked on it, and I got a few updates before they shipped it back on Dec 13, which was within their 7-10 business day window. I got… Read more

0 comments, 248 reads

Posted in The Voice of the DBA on 28 December 2009

Running a Small User Group - Getting Quality Speakers

Midlands PASS is a small user group. We average about 15 people coming to meetings, which is good for Columbia, but still puts us in the small user group category. Having a small user group can mean some challenges, and that's what I'll be blogging about over the next few… Read more

Scratch – A Programming Language for Kids

I ran across Scratch in a PC World article a while back. It’s a free download from MIT, and is primarily a drag and drop programming environment. You can do if/then, loops, and it also supports sprites for animation. There are a bunch (thousands) of projects you can download to… Read more

1 comments, 223 reads

Posted in SQLAndy on 28 December 2009

Presenting a Live Meeting vs. a Real Meeting

I recently had the opportunity to present,  Nuggets Found by Mining the Default Trace, for SQLLunch.  This was my first time presenting via Live Meeting (or any on-line meeting functionality for that matter) and it was quite different.  I have presented technical contant at several user groups and… Read more

0 comments, 142 reads

Posted in Wise Man or Wise Guy on 28 December 2009

Who Uses Rules?

Someone submitted an article recently that walked through how to find the rules in your database, which columns they were bound to, and then how to remove them in order to replace them with Check Constraints. It was interesting because it had been a long time since I’d worked with… Read more

0 comments, 287 reads

Posted in The Voice of the DBA on 28 December 2009

Little info about Resouce DB (SQL Server 2008-2005)

Little info about System Resource Database in (SQL Server 2008/2005)

The fifth system database in both versions (SQL Server 2008 - 2005) is Resource Database. In this DB we have all relevant information about systems objects and functions that we use every day in our daily routine, such as:

SELECT…

Read more

0 comments, 612 reads

Posted in Dukagjin Maloku - Dugi'DBA on 28 December 2009

How To Get a Count of SQL Connections BY IP Address

These queries (which work on both SQL Server 2005 and 2008) are very handy if you want to know who is connecting to a SQL Server instance and how they are doing it.  It will give you a nice idea how your application or web servers are behaving in terms… Read more

28 comments, 2,545 reads

Posted in Glenn Berry's SQL Server Performance on 28 December 2009

I have pens!

We usually stuff stockings with little things for each other in the family. Sometimes it’s junk, or candy, but this year I tried to be a little better. I aimed for funny and practical, and cheap.

My wife got some wiper blades since her truck needs them. My oldest got… Read more

1 comments, 234 reads

Posted in The Voice of the DBA on 26 December 2009

Error Log:

Following steps happened when sql server starts… we can see that in error log::

1. Build of sql server and platform as Microsoft Sql server 2005 version. Edition on OS.

2. Windows process ID (kid):

3. Error log file location.

4. when last time sql was down and what spid…

Read more

0 comments, 305 reads

Posted in Vinay Thakur on 25 December 2009

Merry Christmas 2009

Just a short Happy Holiday, Merry Christmas wish to everyone out there. Enjoying our White Christmas here in Denver. Read more

0 comments, 273 reads

Posted in The Voice of the DBA on 25 December 2009

Merry Xmas 2009

Hope you’re enjoying a break from the routine and spending quality time with family. Xmas for me is a time for music, so I thought I’d share another of my favorites, You Make It Feel Like Christmas by Neil Diamond. Read more

0 comments, 187 reads

Posted in SQLAndy on 24 December 2009

One Hit Wonders of the 80’s

Happened to channel surf across this on TV, found the list - http://blog.vh1.com/2009-04-01/100-greatest-one-hit-wonders-of-the-80s-read-the-list-2/. Many of the links seem to point to videos that ‘aren’t there right now’, but maybe fixed by the time you read this. Easy to poke fun at one hit wonders, but never having had a… Read more

1 comments, 344 reads

Posted in SQLAndy on 24 December 2009

OT: What Christmas Means to Me

Merry Christmas to everyone.  As many of you know, at least I hope you do, I am a born-again Christian and try to live my life according to the Bible, so I’d like to share what Christmas means to me at this time.

There are many scripture passages that are… Read more

0 comments, 123 reads

Posted in Wise Man or Wise Guy on 24 December 2009

We’re Like the Zoo

Actually we’re not quite like the Denver Zoo, which is open every day of the year. The zoo in Virginia where I grew up closed on Christmas, which is kind of like SQLServerCentral. Some years I’ve sent out a Christmas newsletter, just saying Merry Christmas and wishing everyone a… Read more

0 comments, 310 reads

Posted in The Voice of the DBA on 24 December 2009

Wireless Video

Have not tried this yet, but had it bookmarked to share, the TruLink Wireless USB to VGA will send video signals 30 feet. Not far, but far enough for an instructor machine to connect to a projector, or maybe from a PC in a closet to a monitor used for… Read more

0 comments, 193 reads

Posted in SQLAndy on 23 December 2009

Should You Get a Netbook Computer?

On Monday, Intel officially announced the next generation Atom processors (aka Pineview) that are part of the new Pine Trail platform. According to AnandTech, these new Atoms offer about 5-10% better performance along with 15-20% better battery life. If you have an Atom N270 or N280 based netbook, you… Read more

1 comments, 263 reads

Posted in Glenn Berry's SQL Server Performance on 23 December 2009

Newer posts

Older posts