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: March 2011

SQLRally–Convince The Boss

This week the SQLRally team published some notes to help you convince the boss to send you to three days of great training. It’s good stuff and worth reviewing, and I want to add a couple tips of my own:

  • Make it concrete. Get a copy of the schedule and…

Read more

0 comments, 1,547 reads

Posted in SQLAndy on 10 March 2011

SQLSaturday in Hawaii, Portugal, and New Zealand

Just a quick post today for those you who haven’t visited www.sqlsaturday.com lately, we’ve got a lot of events coming up including first timers in Hawaii, Portugal, and New Zealand. I know those might be a bit far to travel (but what a trip it… Read more

0 comments, 675 reads

Posted in SQLAndy on 10 March 2011

Firefox and Reporting Services

Not everyone uses IE and that’s ok, but what’s strange is that by default if you point Firefox at a Reporting Services report the display gets chopped to about 200 pixels. The fix, documented on this post by Jon Galloway, is to modify the CSS to force the height (and…

Read more

0 comments, 851 reads

Posted in SQLAndy on 8 March 2011

Speaking at Orlando Code Camp on March 26, 2011

I’ll be speaking at the upcoming Orlando Code Camp on March 26, 2011, at Seminole State College in Lake Mary. I’ve included a copy of the schedule, a truly awesome array of topics and talent! Jack Corbett & I will also be doing our bit to raise awareness about SQLRally Read more

0 comments, 1,218 reads

Posted in SQLAndy on 8 March 2011

SQLSaturday #77 in Pensacola–Call for Speakers

Karla Landrum just announced SQLSaturday #77, coming to Pensacola on June 4, 2011. Pensacola is a great weekend destination, hit Hemingways on the beach for lunch or dinner and visit the aviation museum – and do some tech learning too of course! I won’t make it this year, it’s a… Read more

0 comments, 857 reads

Posted in SQLAndy on 8 March 2011

Customizing Report Manager Should Be Easier

You might be reading this hoping that I have the magic answer on how to make the Report Manager portal look the way you want it to, but as of SQL 2008 R2 we’re still pretty limited. Shouldn’t it be easy – maybe even part of the install – to… Read more

0 comments, 676 reads

Posted in SQLAndy on 8 March 2011

IT Camp Saturday

The first ever IT Camp is being held in Tampa on March 19, 2011, organized by cool Tampa guy Chad Miller. I’ll be there as an attendee and then talking for a couple minutes during the closing ceremonies about the upcoming SQLRally. It’s long overdue for more community… Read more

0 comments, 615 reads

Posted in SQLAndy on 7 March 2011

Leading Wildcards Aren’t A Good Default

SQL Server has LIKE, which lets us do various pattern matches, but most commonly we use the percent side as a wildcard, such that “where lastname  like ‘Smi%’” matches Smith and Smit and Smithy. It’s a useful tool. It can also be used to do a contains type search, something…

Read more

0 comments, 1,163 reads

Posted in SQLAndy on 5 March 2011

Presenting in West Palm Beach on March 22, 2011

I’m pleased to be joining the West Palm Beach .Net group on March 22 to do a presentation on SQL Server statistics. It’s part of my effort to participate more in the Florida community and to spend more time with the developers. Always stuff to learn on both sides. I’ll… Read more

0 comments, 886 reads

Posted in SQLAndy on 4 March 2011

The Power And Pain of Process–Part 1

Part of why I love IT is finding patterns and creating new ones. Patterns by themselves are interesting, but when you’re able to automate a pattern that’s when you start to really deliver value to a business. The result of that work is what I call process, and it might… Read more

0 comments, 1,111 reads

Posted in SQLAndy on 4 March 2011

Firefox and NTLM Authentication

By default Firefox doesn’t pass through NT credentials, not a big deal when you’re browsing Amazon by a big pain when you’re trying to hit a corporate Reporting Services site – you get prompted to enter credentials each time. It turns out there is an easy fix, just modify the… Read more

0 comments, 926 reads

Posted in SQLAndy on 1 March 2011