Archives: April 2011
Seize the Moment
Today I had a bit of regret slap me in the face. That face slap came from participation in a SQL Quiz on twitter that was hosted by Paul Randal (Blog | Twitter). The questions being thrown out there were deep technical internals type of questions. These weren’t… Read more
1 comments, 411 reads
Posted in SQL RNNR on 29 April 2011
Physical Row Location
SQL Server 2008 has presented us a couple of options to aid in becoming better DBA’s. You can see this evidenced in many ways in the product. A couple of the things that make me think this is the case boils down to two functions that are new in SQL… Read more
0 comments, 889 reads
Posted in SQL RNNR on 29 April 2011
SQLSat 83 – Johannesburg
Awesome news. I submitted a presentation for SQLSat 83 in Johannesburg South Africa for May 7, 2011. I saw that they were opening up the presentation schedule a little bit to allow for remote presenters and I decided to give it a try.
I got an email notification yesterday that… Read more
5 comments, 593 reads
Posted in SQL RNNR on 28 April 2011
A SQL Experiment – Mentoring
News Flash
The SQL Community is about to get stronger. Why? There is a great new initiative that was recently launched. Steve Jones and Andy Warren are teaming up to conduct this initiative. As they aptly named it, the new initiative is called “The Mentoring Experiment.”
How many times have… Read more
2 comments, 129 reads
Posted in SQL RNNR on 26 April 2011
SQLPeople Interview
Have you heard about this new project out there called SQLPeople? It is a new (relatively) project that is the brainchild of Andy Leonard. Andy is trying to help the community to get to know each other better than they already do.
Part of this initiative is to conduct interviews… Read more
0 comments, 93 reads
Posted in SQL RNNR on 25 April 2011
T-SQL Tuesday #17 – APPLY Knowledge
We have another opportunity to write as a part of TSQL Tuesday today. This month Matt Velic (Blog | Twitter). Matt has proposed a challenge that was derived from a comment on twitter. The challenge this month is to write about “Apply.”
Admins Apply Within
As an administrator… Read more
0 comments, 100 reads
Posted in SQL RNNR on 12 April 2011
SSIS Job Ownership
I was strolling along one day when I saw somebody asking how to find out who owns a maintenance plan. That evolved into finding out who owns the the job associated with the maintenance plan. All of this in SQL 2005 and SQL 2008.
Well, we were stumped for a… Read more
0 comments, 116 reads
Posted in SQL RNNR on 11 April 2011
S3OLV April Change
Earlier this week I announced the meeting for the Las Vegas User Group. I blasted some of you with emails – along with people in our mailing list. Those plans are now changed. No longer will the group be meeting on Thursday April 14th. Instead we will be having our… Read more
0 comments, 95 reads
Posted in SQL RNNR on 7 April 2011
S3OLV April 2011
Are you ready to learn again? The Las Vegas SQL Users Group is ready to have our April meeting. The meeting is to be held April 14, 2011 at 6:30 PST.
This month we have a BI presentation lined up and some top notch talent to present to us. Erika… Read more
0 comments, 119 reads
Posted in SQL RNNR on 5 April 2011
SQL Server Role Membership
How well do you know the security in your SQL instances? Do you know who has sysadmin level permissions? SQL Server provides a few methods for you to find out who is a member of which roles at the server level.
For those that like to point and click, you… Read more
0 comments, 243 reads
Posted in SQL RNNR on 5 April 2011
Indexing Just Got Easy
As a database professional one of the things that we should be familiar with is the use of indexes. In SQL Server an index helps to improve query performance – when properly implemented. There are some penalties in play when an index is created. These penalties are typically associated with… Read more
0 comments, 149 reads
Posted in SQL RNNR on 1 April 2011



Subscribe to this blog