Archives: May 2011
I love the identity property. I use it in many of my tables, mostly because it gives me a fairly reliable surrogate key that I can use in my tables, especially when testing something. I often do something like this:
CREATE TABLE MyIdentityTest ( id INT IDENTITY(1,
These are five rules for writing from Ernest Hemingway, which I like and recommend for use in your communications. Definitely try to incorporate them into your writing, especially being short and positive.
(Cross posted from The Modern Resume)
Filed under: Blog Tagged: syndicated, writing
It’s Memorial Day, and as usual, I have a blooper reel for the editorial. However I couldn’t fit everything in there, so I’ve pulled out a few more items. Mostly body mistakes or movements and some speaking issues. Enjoy!
The editorial blooper reel is here: http://m.podshow.com/media/15351/episodes/282544/sqlservercentral-282544-05-26-2011.mp4
Filed under: Blog Tagged:…
I caught the end of a Twitter conversation the other day between Wes Brown (Blog | @WesBrownSQL), Paul Randal (blog | @PaulRandal), and Aaron Bertrand (blog | @aaronbertrand) talking about shrinking tempdb and the potential issues.
I’ve never thought about it before, but someone… Read more
Once again we’re running a contest to find the Exceptional DBA around the globe. I’ve been a judge the last three years, and it’s been a hard choice trying to pick from some great applications. This year the judges are Brad McGehee, Brent Ozar, Rodney Landrum and me.
Nominations are… Read more
I needed an image of a “great idea”, and decided to use a light bulb. I started looking through Flickr and then realized I could just as easily do my own picture. So I enlisted Kendall for this series of shots.
We had fun, with Kendall holding some of… Read more
I went to run this query recently:
select TOP 10 * from users a inner join Banned b on a.username = b.username
and got this lovely message.
I’d seen that message before, so I knew what was wrong. The collations for the two tables were inconsistent.… Read more
This is a powerful quote:
“This is the digital world IT must keep up with–one where Apple can view a $40,000 car as an accessory to the iPhone.” – From IT Is Too Darn Slow
The IT world definitely needs to learn to move quicker, and that means that we… Read more
I’m in a fun mood today, so a few silly items for you.
The last few weeks, Paul Randal (blog | @PaulRandal) of SQLskills has been doing a quiz on Twitter some days. He’s asked some rather difficult questions on Twitter, and people have had fun following along.… Read more
Simon Sabin had his own take on increasing laptop speed. He had some good ideas, but he inspired me to try to top his suggestions. Here’s what I came up with:
Anyone needing help, let me know. I can swing by.
Filed under: Blog Tagged: Humor, syndicated
Someone posted this query recently:
select a.*,name, b.*
from sys.database_principals a, sys.database_permissions b
where permission_name = 'INSERT'
b.grantee_principal_id = a.principal_id
That’s a little ugly, so let’s fix it:
SELECT a.name, a.principal_id, a.is_fixed_role
I saw a post from Marc Beacom on the presentations this week for various groups. You can get the info on them all from Marc’s post, but basically this is user group week in CO.
- Tuesday – Boulder
- Wednesday – Colorado Springs
- Thursday – Denver
I’m not sure I’ll… Read more
I saw a post recently that had query that looked like this:
select a.*,name, b.* from sys.database_principals a, sys.database_permissions b where permission_name = 'INSERT' and b.grantee_principal_id = a.principal_id
Ugly to read, at least to me, and… Read more
My email account started getting notices of Windows patches yesterday, indicating it’s patch week again. If you manage Windows devices, be sure you are aware of the patches that came out. The May Bulletin on Technet shows 2 issues, one critical, one important.
I tend to apply patches late, probably… Read more
This quote says it all:
It’s from an article on the 9/11 memorial and how an algorithm was used to inscribe the names in particular places.
That could easily be applied to your career as well. The connections you have, with people that know you, respect you, like your work,… Read more
It’s time for T-SQL Tuesday again, and it’s number 18. Hard to believe it’s been a year and a half since Adam Machanic (blog | @AdamMachanic) thought of the idea. I’ve participated in most and it’s something I look forward to each month. This month Bob Pusateri… Read more
I wasn’t sure that I would submit anything, but in the end I committed to a few events in Seattle and decided that this was something I should do. If I get selected it will save my boss some $$ and it’s part of what I should be doing for… Read more
It seems that every month I have someone asking the question about ordering or row numbers for a query. Let’s get one thing clear from the start: there are no "row numbers" in a table.
You can assume that the first row you inserted is row number one, but it’s… Read more
Other than the week I hosted it, I’ve been caught off guard by T-SQL Tuesday most months. This time I caught Bob’s Twitter announcement about #18. The topic this month is CTEs, so you have a week to get things ready.
Filed under: Blog Tagged: syndicated, T-SQL Tuesday
I have always put FKs into my database for data integrity purposes. I’ve worked on enough applications that didn’t have FKs, or any RI in place and it was always a nightmare when the application broke down or there were enhancements that allowed duplicates, orphans, or other data integrity problems. Read more