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, 426 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, 504 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, 507 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, 415 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
1 comments, 546 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 31 March 2011
Change SQL Startup Parameters with PowerShell
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, 1,605 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, 727 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,042 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, 604 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, 642 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, 794 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
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, 675 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
3 comments, 708 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 30 March 2011
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, 490 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, 512 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, 514 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, 600 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, 552 reads
Posted in The Voice of the DBA on 29 March 2011
DevConnections Pictures
0 comments, 461 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, 532 reads
Posted in The Voice of the DBA on 29 March 2011



Subscribe to latest posts