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

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest

Archives: 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, 546 reads

Posted in The Voice of the DBA on 31 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, 761 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, 836 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, 963 reads

Posted in The Voice of the DBA on 30 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, 816 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, 727 reads

Posted in The Voice of the DBA on 29 March 2011

DevConnections Pictures

0 comments, 584 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, 698 reads

Posted in The Voice of the DBA on 29 March 2011

Locking and Blocking from Joe Webb – DevConnections

Locking should be simple, right? You need to access a row or table and you get a lock. Oh yeah, blocking is bad.

It’s not that simple, and I find this is an area that many people do not understand that well. Joe does a nice job of presenting this… Read more

0 comments, 257 reads

Posted in The Voice of the DBA on 29 March 2011

On the Move to SQL Server Connections

Brian Kelley, speaking on the SQLServerCentral track.

A bit of a crazy day for me, starting off a crazy week. I leave this afternoon for SQL Server Connections in Orlando, where it’s in the 80F with some rain. It was about 60F yesterday and sunny in Denver, a beautiful t-shirt… Read more

0 comments, 256 reads

Posted in The Voice of the DBA on 28 March 2011

SQL in the City – The Red Gate Tour

Red Gate Software is announcing SQL in the City today, a series of events that will bring a free day of training to a few locations later this year. The events will be free and features specific Red Gate products and solutions to the common problems and situations that many… Read more

4 comments, 461 reads

Posted in The Voice of the DBA on 28 March 2011

How Many Bytes Are In My Column? – T-SQL Functions

One of the things you want to be aware of when writing T-SQL is using the proper function for a particular problem. Someone posted a question asking about why they were getting a 0 for this code:

SELECT Mychar
    , '''' + mychar + ''''
   FROM dbo.MyTable

That… Read more

0 comments, 1,006 reads

Posted in The Voice of the DBA on 25 March 2011

SQL Server Connections in a week

I’m heading to SQL Server Connections next week, part of the DevConnections conference featuring a whole slew of technologies. Once again SQLServerCentral is sponsoring a track at the event, and I’m playing host and reporter.

We’ve picked some great speakers, including Brian Kelley, Joe Webb, and Jonathan Kehayias Read more

3 comments, 265 reads

Posted in The Voice of the DBA on 21 March 2011

My Connect Items – Won’t Fix

There’s been some work to close out items in Connect that aren’t going to be fixed. I don’t know exactly if these are items that aren’t good ideas, are dropped because of a lack of resources, or because no one wants to figure that out.

However, I had three items… Read more

2 comments, 321 reads

Posted in The Voice of the DBA on 17 March 2011

The MCM is Worldwide

Well, not everywhere, but as long as Prometric sites meet some security requirements, they can offer the MCM tests. I got a note from Joe Sack after someone asked me the question about when the MCM would be offered outside the US. From what he sent me, it’s in these… Read more

3 comments, 289 reads

Posted in The Voice of the DBA on 15 March 2011

The Lighter Side of Technical Interview Questions

I hate those puzzle type interview questions. I am sure that they show some level of aptitude about something, but I’m not typically a puzzle person. I’m a let’s solve this person, and I rarely figure out the answers.

Someone send me this interview text, which supposes that someone… Read more

1 comments, 512 reads

Posted in The Voice of the DBA on 14 March 2011

MCM – The Knowledge Exam

I recently took the knowledge exam, and I loved it. I thought it was a great exam. I have taken ten or twelve Microsoft exams and this was the first time that I crossed the two hour mark in an exam. Actually, with my time to review the questions and… Read more

4 comments, 815 reads

Posted in The Voice of the DBA on 10 March 2011

T-SQL Tuesday #016 – Aggregation

It’s that time of month again, time for Adam Machanic’s (Twitter | Blog) T-SQL Tuesday blog party. This month the party is hosted by Jes Borland (blog | @grrl_geek) and the topic is Aggregation.

And I’m late.

I planned on doing this yesterday, I really… Read more

1 comments, 326 reads

Posted in The Voice of the DBA on 9 March 2011

Rocky Mountain Tech Trifecta v3.0 Keynote

I had the main room keynote at the recent Rocky Mountain Tech Trifecta v3.0 in Denver. Jeff Certain & Ben Hoelting had the beginner track keynote, and I was sorry I missed that. I would have liked to see them talk.

However I had enough stress with my own keynote,… Read more

1 comments, 276 reads

Posted in The Voice of the DBA on 9 March 2011

An Overview of SQL Server AlwaysOn

One of the changes coming in SQL Server v11 (not sure what the name will actually be), also known as “Denali”, is the addition of more High Availability/Disaster Recovery Options. When I first heard about this, I was excited, but the public CTP had limited support for it. I’m hoping… Read more

0 comments, 425 reads

Posted in The Voice of the DBA on 8 March 2011

Older posts