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

Archives: March 2011

Taking It To The Next Level

Have you set the bar high enough to ensure your success?

You’re reading Taking It To The Next Level, day 5 of 5 Days to Outstanding DBA Customer Service. What prompted this journey into exploring what is Outstanding Customer Service for the Data Professional?  Good Question.  You can find… Read more

0 comments, 581 reads

Posted in John Sansom - SQL Server DBA in the UK on 31 March 2011

PASS Subcommittee

In February I posted this post about the need for Volunteers for SUMMIT 2011.  I submitted my application to volunteer.  This past week I got word back concerning that application.  I am pretty happy that I have the opportunity once again to serve on a subcommittee for the upcoming SUMMIT. Read more

0 comments, 662 reads

Posted in SQL RNNR on 31 March 2011

To Do: Win Great SQL Training and a Cruise

Wondering what to do when you get a break from work email today?

Make your opening move in a fun contest.

What’s to win?

The prize is tempting booty: Idera Software is giving away a free trip to SQLCruise Alaska. And not just part of the trip, it’s the full… Read more

0 comments, 747 reads

Posted in LittleKendra on 31 March 2011

Hanging with an Inspiration

A long, long time ago, in a state far away, I started writing about technology. At the time, in the late 90s, I was looking to share some of my knowledge, and hopefully advance my career along.

It was intimidating to think that I could produce articles anywhere near the… Read more

5 comments, 571 reads

Posted in The Voice of the DBA on 31 March 2011

Presenting with a Mac

My name is Brian Kelley and I used to be a PC bigot. That was back in 1989. I was selected to attend the South Carolina Governor's School for Science and Mathematics and one of the things about attending there is everyone has a work service assignment. Mine was as… Read more

Change SQL Startup Parameters with PowerShell

Backups Abound

The Annoyance

Sometimes when we’re trying to track down a problem and looking through SQL’s Logs we have to dig through hundreds of backup successful events just to find what we’re looking for. Unfortunately, SSMS doesn’t have an exclusion filter when viewing the logs, so I can’t filter… Read more

6 comments, 2,436 reads

Posted in Eric Humphrey on 31 March 2011

The DBAs Guide to Expectation Management

Your customers expectations are their primary measure of your success. How well are you managing them?

You’re reading The DBAs Guide to Expectation Management, day 4 of 5 Days to Outstanding DBA Customer Service. What prompted this journey into exploring what is Outstanding Customer Service for the Data Professional?… Read more

2 comments, 1,044 reads

Posted in John Sansom - SQL Server DBA in the UK on 30 March 2011

NULLIF

Do you use NULLIF?  For me, this command has been seldom used.  Because of that, I have been dabbling with it a bit lately to make sure I have a better understanding of it.

What is it?

This is a function that compares two values.  If the two values are… Read more

22 comments, 1,764 reads

Posted in SQL RNNR on 30 March 2011

Dude, where’s my memory?

A session I have wanted to see. Marciej Pilecki has done this before with high ratings and I have missed until today

He starts with a description of how memory is allocated in the 32 and 64 bit systems. One interesting thin he noted is that the lock Pages in… Read more

0 comments, 789 reads

Posted in The Voice of the DBA on 30 March 2011

Brad McGehee talking about tempdb issues

Brad presented a session that tries to help you identify and fix tempdb problems. Performance monitor is your friend. the local disks, avg read and write counters should help you determine if I/O is an issue. Watch for systems where you have >20ms for the averages, this is a gross… Read more

0 comments, 867 reads

Posted in The Voice of the DBA on 30 March 2011

Brian Kelley on Security at SQL Server Connections

Random notes from Brian Kelley’s security talk. Brian spent a number of years working a a security guy for a bank in the Windows and infrastructure teams.

Networking, the UDP port is 1434. This is the listener and browser for SQL.

Default Tcp1433 is the default port for SQL. What… Read more

0 comments, 992 reads

Posted in The Voice of the DBA on 30 March 2011

I laughed, I cried, it was better than CATS: The Fast Track Data Warehouse 3.0 Reference Guide

Careful what you say about cats, lady.

You know what’s crazy?

A comprehensive, technical, well thought-out, and ENJOYABLE document. One written with the occasional interesting diagram and a reasonable use of acronyms, with effective tables and practical advice. A document that’s written for a human being which has helpful links… Read more

0 comments, 888 reads

Posted in LittleKendra on 30 March 2011

Improving Meetings

Most folks I know hate meetings. They especially hate meetings about meetings. Recently I was working with a developer who loves to meet. He's a knowledgeable guy and he likes to talk and share technology. These meetings have often gone down various rabbit trails and they take up a lot… Read more

Tampa IT Camp 2011 Lessons Learned Part 1

On Saturday, March 19th 2011 we held the first ever Saturday “code camp” style event for the IT Pro (Sys Admins) community which we called IT Camp. IT Camps are a free, one day learning event for anyone seeking professional development. This event serves IT professionals and students with a… Read more

0 comments, 682 reads

Posted in Chad Miller on 30 March 2011

SQL Saturday #74 Jacksonville

For the 4th year SQL Saturday comes to Jacksonville, FL this year on April 30, 2011. Many of you already know about these events but just to remind you it is a totally FREE all day event that brings top speakers to you.

I hope everyone already realizes this, but… Read more

0 comments, 664 reads

Posted in Devin Knight on 30 March 2011

How To Really Listen

One of the most undervalued skills that an individual can possess is the ability to listen. Are you really hearing your customers?

You’re reading How To Really Listen, day 3 of 5 Days to Outstanding DBA Customer Service. What prompted this journey into exploring what is Outstanding Customer Service… Read more

0 comments, 668 reads

Posted in John Sansom - SQL Server DBA in the UK on 29 March 2011

Extended Events at SQL Server Connections with Jonathan Kehayias

I was very interested to hear Jonathan Kehayias’ session on extended events. I know this is one of the areas i need work and it is becoming a more important part of SQL Server with each version. Beginning with a good discussion of what extended events are and the terminology… Read more

0 comments, 868 reads

Posted in The Voice of the DBA on 29 March 2011

Brian Kelley talking Windows Internals for SQL Pros at DevConnections

I have known Brian for nearly as long as i have been running SQLServerCentral. He has been the guy that I called for security questions. He was a DBA, then became a security and auditing guy, and is now back to being a DBA. This talk is designed to better… Read more

0 comments, 765 reads

Posted in The Voice of the DBA on 29 March 2011

DevConnections Pictures

0 comments, 612 reads

Posted in The Voice of the DBA on 29 March 2011

Brent Ozar Blitz at SQL Server Connections

The first session of the day for me was Brent Ozars Blitz talk on how to quickly get information on a new server. I have seen Brent’s video on this and read some of his blog posts, but i wanted to see him go over the script in a session. Read more

1 comments, 738 reads

Posted in The Voice of the DBA on 29 March 2011

Older posts