The Voice of the DBA
Archives: October 2012
Question what you think
0 comments, 394 reads
Posted in The Voice of the DBA on 26 October 2012
Windows 8 First Impressions
I haven’t worked with Window 8 at all. I’m not a big beta tester, and it’s been a busy few months for me, so I haven’t bothered to mess with any of the previews. My Win 7 desktop works well for me, and I haven’t bothered to think about doing… Read more
0 comments, 478 reads
Posted in The Voice of the DBA on 25 October 2012
Trace Flag 2371 and Statistics
One of the issues that I see published often on forums like SQLServerCentral is the advice to update statistics on your tables if you have strange performance issues, or sudden changes in performance. Statistics are important for the query optimizer, and you should understand the basics of how they… Read more
4 comments, 1,408 reads
Posted in The Voice of the DBA on 22 October 2012
On Source Control
A mention today from Jamie Thomson in his blog on source control. I left a comment, but it was long, so I thought I’d repost it here.
My comment
Thanks for the note, Jamie, and it’s interesting, but I don’t see any respondents that aren’t using VSC. I’m guessing… Read more
0 comments, 504 reads
Posted in The Voice of the DBA on 18 October 2012
Important Alerts for SQL Server
One of the things that I think is extremely important for DBAs and really anyone that has to administer a SQL Server instance is a set of alerts on various items that might occur.
I ran across Glenn Berry’s article on Provisioning SQL Server and there’s a section in there… Read more
0 comments, 1,051 reads
Posted in The Voice of the DBA on 18 October 2012
Thirteen Years Old
A very cool shot of our company at 13.
I first heard of Red Gate back in 2001 and they were our first advertising customer at SQLServerCentral.
A few years ago they bought the company and I now work for them. It’s a great company, and a fun one. Things… Read more
0 comments, 363 reads
Posted in The Voice of the DBA on 16 October 2012
(Mis)Using DBCC Page
In one of my presentations recently I was recommending DBCC CHECKDB on every database every day. I realize that isn’t always possible or practical, so I noted that if you don’t have resources on your production server, or enough spare hardware, you should at least run it on every… Read more
0 comments, 517 reads
Posted in The Voice of the DBA on 15 October 2012
Windows Server 2012 and Hyper-V
I recently went to a Microsoft event in Denver on Windows Server 2012 and Hyper-V improvements. Harold Wong (b | t) showed quite a few demos and there’s a number of demos and notes from the talks on his blog.
I haven’t looked much at the Windows… Read more
2 comments, 489 reads
Posted in The Voice of the DBA on 11 October 2012
Comments on the SQL in the City Tour
There’s still an event in Seattle in a few weeks. As I’ve been traveling around the country, literally around through New York, Austin, San Francisco, Chicago and Boston, I’ve met a lot of people and shaken a lot of hands. There have been lots of questions as well as, I… Read more
1 comments, 390 reads
Posted in The Voice of the DBA on 9 October 2012
T-SQL Tuesday #35 – Soylent Green
This month’s host is Nick Haslam (b | t) and he bases his question on the movie Soylent Green, which I haven’t seen. This month he asks what the most horrifying thing you’ve seen in SQL Server. It’s been a long few weeks for me, so I‘ll… Read more
2 comments, 336 reads
Posted in The Voice of the DBA on 9 October 2012
Database Maintenance Essentials – Resources
I told people in New York at SQL in the City that I’d post some resources on the blog from my talk. My apologies for not getting it done over the weekend, but during a little downtime in Austin I’m getting it done.
Checklist
From the last slide, a checklist… Read more
1 comments, 437 reads
Posted in The Voice of the DBA on 1 October 2012
SQL in the City
That’s where we were on Friday. 780 Third Avenue, in the middle of Manhattan. The start of our 2012 US SQL in the City tour.
I arrived Thursday, getting into the city in time to go running in Central Park. A solo #sqlrun, but one I enjoyed on a beautiful… Read more
0 comments, 388 reads
Posted in The Voice of the DBA on 1 October 2012



Subscribe to this blog