Archives: March 2011
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
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
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
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
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
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
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
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
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
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
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
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.
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
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
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.
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
And I’m late.
I planned on doing this yesterday, I really… Read more
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
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