Archives: April 2010
“Show up for work on time for six months and then we’ll talk. Until then, I have four words for you: shut the fuck up.” – Kitchen Confidential
I wish people showed up and heard this on their first day of work. Too many people I think have a very… Read more
No, I didn’t buy an iPad, but I have to say on a trip to the Apple Store this week (for an iPod issue), I played with one for about 20 minutes and I came to this conclusion.
It. Is. Cool.
It’s not semi-cool. Or neat. It is very, very… Read more
It seems to rear it’s ugly head more and more these days. Once again I found some content from my site republished on another site, without permission, and without a link.
I can’t speak for others, but if I knew you were plagiarizing content, I wouldn’t hire you. I believe… Read more
Someone asked an interesting question recently. If they had this code:
if OBJECT_ID('aa') is not null
drop table aa
create table aa (id int identity(1,1))
set identity_insert aa on
insert aa (id) select -10 union select -11
set identity_insert aa off
insert aa default values
select * from… Read more
From the PASS 2010 Summit Survey: 29% of people want a presentation on backup compression. OK, here it is.
Turn it on:
Turn it off:
That’s it. If you want to script it, go here.
Tia thinks I’m crazy to book early, but I like to have a choice of flights, and I like to get things off my plate. I heard back from someone about TechEd today, so I decided to just book the trip. One less thing for me to worry about.
SQL… Read more
I hope there will be more surveys, so I’ll tag this as 2010. The results were released recently, and there were some write-ups on the results. There was the release by PASS, and then a great interpretation (and debate) by Brent Ozar. There are others as well ( Read more
I think so. This past weekend had three events, #39 in NYC, #41 in Atlanta, and #44 in Huntington Beach, CA. That’s unusual, but this weekend we have #36 in Wheeling, WV and #38…
This is one of the reasons that I don’t like to put CTP software (or Beta software) onto machines that I can’t take the time to wipe and rebuild. Buck Woody wrote a note about upgrading your CTP, and the short answer in his blog is:
You can’t… Read more
I installed a new VM with SQL Server in it, along with Win 7 and Reporting Services. The plan was to mess with this as a detailed journey through to learning more about SSRS this year.
I was excited to get going on this new install since I hadn’t messed… Read more
I have been a fan of 37 Signals for some time, and I read their blog regularly. I think they go a great job of writing about how to run a business and not build an investment.
I saw this article on the improvements from E-ink that are coming. There are two videos, one of a better screen that can handle simple animations, likely getting into actual products you can by in about a year (early 2011).
The other was low power, but more durable. The guy… Read more
My Windows Home Server died a month ago, just as I was getting ready to leave the country. I didn’t have time to deal with it, but since I was still in the process of moving data over to it, I felt fairly safe. When I got back to it… Read more
I was listening to the announcement of SQL Server 2008 R2 yesterday on a call from Microsoft. It was released to manufacturing, downloadable on May 3. While listening and making notes, I wandered over to the Microsoft SQL site and was surprised to find a video montage of the Tweet-up Read more
Microsoft scheduled a conference call this morning, and I jumped on since I was laid up in bed with a pinched nerve in my neck. What else did I have to do?
Actually I had work to do, but I was in pain much of the night and this morning,… Read more
In the past, when I’ve set up log shipping, it was primarily as a DR device, designed to get copies of logs to another server ASAP. The idea being that if we had an issue on the production server, we could switch to the secondary server quickly and lose minimal… Read more
I feel like I have some bad digital karma lately. In the past week I’ve had these downed systems:
- iPod iTouch
- Lenovo Laptop
- Acer laptop
- Windows Home Server
To be fair the Windows Home Server died just before we went to the UK and I hadn’t had time to mess… Read more
You can only have one mirror of a SQL Server database in SQL Server 2005/2008. I researched that last year when someone asked the question. It didn’t make sense to me why you couldn’t have more than one, and I struggled to find documentation, but finally Paul Randal pointed me… Read more
The RTM date is out for SQL Server 2008 R2. At the UK Tech Days it was released as May 21 of this year, so my guess it’s pretty much done and there’s a little fit and finish work to be completed.
I’m surprised that they can announce that date… Read more
One of my 2010 goals is to really increase my SSRS knowledge. I’ve used SSRS in a cursory manner over the years, but never really delved into building complex reports and trying new things. So I decided to fix that and work my way through some articles and books on… Read more