SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in


I'm Andy Warren, currently a SQL Server trainer with End to End Training. Over the past few years I've been a developer, DBA, and IT Director. I was one of the original founders of SQLServerCentral.com and helped grow that community from zero to about 300k members before deciding to move on to other ventures.

Archives: January 2008

Hello Secure World - MS Site Worth Looking At

Saw this in the MSDN flash yesterday, MS has a new Silverlight site up (newest toy and all!) that focuses on security, but the part that intriged me is if you click on the virtual labs, there are some great exercises that walk you through actually hacking sites using various… Read more

0 comments, 1,364 reads

Posted in SQLAndy on 29 January 2008

The Long Tail

Another book I read recently, The Long Tail by Chris Anderson of Wired Magazine goes into detail talking about some of the changes in retail brought on my the internet with the main premise (in my words) being that companies like Amazon, Netflix, and Itunes sell fewer copies of a… Read more

0 comments, 1,449 reads

Posted in SQLAndy on 29 January 2008

IT Transparency Posted on SSC

As I mentioned yesterday the article I wrote on IT Transparency is finally live today and now the wait to see what the response is! I hope you'll drop me a comment after you read it, either here on the blog or in the SSC forum attached to the article. Read more

0 comments, 1,279 reads

Posted in SQLAndy on 29 January 2008

Agenda Posted for South Florida Code Camp

I'll be there doing a presentation on Transactional Replication, and my friend Chris Rock will be doing on on LINQ to SQL. This will be my first time attending this event, so I'm looking forward to seeing some new speakers (not that I don't appreciate those that speak in Orlando/Jacksonville/Tampa!).… Read more

0 comments, 1,348 reads

Posted in SQLAndy on 28 January 2008

IT Transparency, the intro!

Tomorrow SSC is scheduled to publish an article I wrote on IT Transparency which gives a first person account of one strategy I used to try to make it a little easier for the business to see where IT time/money was going. Debated over whether to publish it, not necessarily… Read more

1 comments, 1,376 reads

Posted in SQLAndy on 28 January 2008

Visiting the Charlotte SQL User Group on Feb 27th

I'll be visiting the Charlotte SQL Group on Feb 27th and I'll be doing one of my favorite presentations, Transactional Replication for Beginners (and probably talking a little about career development as well). I'm looking forward to the trip, always fun to see how other user groups work and to… Read more

0 comments, 1,339 reads

Posted in SQLAndy on 28 January 2008

Interesting Article about Measuring Performance in Software Test Mag

The Jan 2008 issue of Software Test & Performance Magazine  (available as free PDF download, you can also download back issues through 2004) has an article called 'Gauging Performance in the Absence of Metrics' that I found interesting. From a SQL perspective it's a good read because it talks about… Read more

0 comments, 1,625 reads

Posted in SQLAndy on 27 January 2008

System Sessions/Spids Rather than Spid < 50

Saw System Sessions posted on the PSS blog and it shows an example of information being written to the error log as 'spid5s', where the trailing 's' indicates a system session (spid). You can also filter them out of the processes by doing this:

select * from sysprocesses where spid… Read more

0 comments, 514 reads

Posted in SQLAndy on 23 January 2008

Free Subscriptions to Visual Studio Magazine

First time I've noticed this being offered, saw it posted on the Orlando .Net Users Group (ONETUG) site. Sign up is easy enough, just one page to register and they also offer a digital edition for those who prefer paperless. Register for your subscription, they've had some good LINQ… Read more

1 comments, 1,365 reads

Posted in SQLAndy on 21 January 2008

Learning to Blog via Books

I was chatting with a friend recently and in the course of 'what are you up to lately' I mentioned I had been doing some reading about how to blog, which resulted in the raised eyebrow and 'how hard can be blogging be' look. You just set up a blog… Read more

0 comments, 475 reads

Posted in SQLAndy on 20 January 2008

Connecting to a Reporting Services Model

There's always been some confusion about models in Reporting Services, many people ignore them thinking that they are only for use by Report Builder. Models can also be used by BI Design Studio and should be used for all the same reasons that make it useful in RB - it… Read more

0 comments, 1,542 reads

Posted in SQLAndy on 18 January 2008

Free Ebook Chapter(Book) - Introducing SQL Server 2008

Saw it mentioned in the recent MSPress newsletter, Peter DeBetta is writing Introducing SQL Server 2008 and right now Chapter 1 on the Declaritive Management Framework (essentially Group Policy for SQL Server) is a free download. If you sign up you'll get the entire e-book when it's completed. Can't beat free! Read more

7 comments, 845 reads

Posted in SQLAndy on 18 January 2008

MS Making .Net Framework Source Code Available

Scott Guthrie posted the announcement on his blog today. It's a 'read only' license with a few other limitations, but in general this is a great thing for .Net developers. Sometimes you're just curious, sometimes it's really important to see what goes on at the deepest levels. It really makes… Read more

0 comments, 739 reads

Posted in SQLAndy on 17 January 2008

Partitioning Part 4 Posted on SSC

Partitioning Part 4 concludes the series with a look at 'real' partitioning in SQL 2005 Enterprise Edition. Overall the series worked out reasonably well, accomplished my goal of introducing the technology and options without getting into dense technical detail. There is definitely more to explore in partioning than I've covered! Read more

2 comments, 538 reads

Posted in SQLAndy on 17 January 2008

Sun Acquires MySQL

Just posted on Jonathan Schartz's blog. They've definitely been playing more in the open source arena, now they've got a reasonably good database product. Read more

0 comments, 625 reads

Posted in SQLAndy on 16 January 2008

Upcoming Presentations

I'll be attending the South Florida Code Camp on Feb 2 and also SQLSaturday Tampa on Feb 16th. For both of those I'll be doing my 'Introduction to Transactional Replication' presentation, the same one I did at PASS 2007. Call for speakers for the Orlando Code Camp has not yet… Read more

0 comments, 515 reads

Posted in SQLAndy on 16 January 2008

E-Readers, Will They Ever Take Off?

I was discussing the Kindle recently with business partner Steve Jones and while we both like the idea of having a portable reader, the $400 price tag - even when you consider the potential savings on books for buying e-version only - just seems too high, and that trumps any… Read more

0 comments, 475 reads

Posted in SQLAndy on 14 January 2008

Evaluating Speakers at Events

Speakers tend to live for the evals. Hopefully it's a validation of work done well after a lot of time preparing, but most speakers would gladly pay for meaningful feedback that would help them improve their game. Event organizers use the evals to see if there is anyone that did… Read more

0 comments, 828 reads

Posted in SQLAndy on 9 January 2008

Sometimes You Need an Analog Solution, Sorta - Earth Class Mail

Spotted this on the Webware feed, Earth Class Mail is a service that opens and scans your regular mail so you can read it as email! Interesting idea, plus they could make some extra recycling all that paper. Seems like the next logical if evil step would be for mail… Read more

0 comments, 493 reads

Posted in SQLAndy on 9 January 2008

SQL Injection, Again!

Many posts including this one about as many as 70,000 sites being hacked using SQL injection and a vulnerability in MDAC that was patched in Sep 2006. You can see what's still out there by searching google for UC8010 and seeing it listed in the link title with a script… Read more

0 comments, 617 reads

Posted in SQLAndy on 9 January 2008

Older posts