Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQLAndy

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.

Moving SQLAndy to Project Nami

I’ve been hosting this blog on Azure for a while, running WordPress on top of MySQL. Works fine, gives me a reason to use Azure here and there to gain experience. No good reason to change. Still, why not?

Last night I loaded Project Nami, a port of WordPress… Read more

0 comments, 25 reads

Posted in SQLAndy on 2 July 2015

Reporting Services Subscriptions in “Pending” Status

Ran into this issue today. A subscription that had been working failed. Looking at it in the RS portal it had a status of “pending” Not helpful! I tested the report, looked at the datasources, and the subscription, it all looked good. It was only when I stepped through the… Read more

0 comments, 27 reads

Posted in SQLAndy on 1 July 2015

SSC Editorial: Exit Lines & Writing Editorials

I’m trying to evolve a little in the topics I pick and how I write them to push the boundaries a little more than normal. Editorials should trigger thinking and debates, evoke more than provoke, but not be polarizing. I resist the impulse to measure success by the number of… Read more

0 comments, 27 reads

Posted in SQLAndy on 29 June 2015

Changes to the 2015 PASS Board Elections

PASS just posted Changes to the 2015 PASS Board Elections based on feedback from the 2014 NomCom. I was part of that team, so now that the process is complete I want to add some comments on the process and the results. They are, of course, my opinion only –… Read more

0 comments, 3 reads

Posted in SQLAndy on 25 June 2015

SSC Editorial: Culture Clashes and Arrogance

I’m a little late posting this, Culture Clashes and Arrogance was featured on June 17, 2015. One of my favorites for the lessons I learned that led to writing it. Oh, things I wish I had learned much sooner!

Read more

0 comments, 3 reads

Posted in SQLAndy on 25 June 2015

oPASS June 2015: Using BI Power tools to visualize your SQL Infrastructure with Rodney Landrum

The next oPASS meeting is tomorrow night (June 25, 2015):

DBAs do not always have time to work with some of the amazing visual data tools that are becoming common place now for analysts. In this presentation I will show how in just a few very easy steps you can…

Read more

0 comments, 1 read

Posted in SQLAndy on 24 June 2015

Seeking Full Day Seminars For The Friday Before SQLSaturday Orlando 2015

We’re planning to run one or two (or maybe even three) seminars (aka pre-cons) in conjunction with SQLSaturday Orlando 2015. What are we looking for?

  • An interesting topic. I know that’s vague, so let’s say we want a topic that will be of interest to 15+ people willing to…

Read more

0 comments, 1 read

Posted in SQLAndy on 24 June 2015

Use 100% Fill Factor on Insert Only Tables

SQL Server has the concept of fill factor for leaving extra space in pages to reduce the number of page splits. If you picture library shelves, it’s like leaving space for a couple new books on each shelf. It’s a trade-off though, putting in that space may reduce page splits… Read more

0 comments, 2 reads

Posted in SQLAndy on 24 June 2015

SSC Editorial: Sweat Files and Practice Projects

Published last week on SQLServerCentral, Sweat Files and Practice Projects is about the need/lack of packaged projects that a newbie SQL Server DBA/SSIS/BI person can use to exercise skills. I’m going to try writing a couple later in the year. They don’t need to be big and I think they… Read more

0 comments, 2 reads

Posted in SQLAndy on 23 June 2015

Notes from the June 17, 2015 MagicPASS Meeting

Notes:

  • Kendal has been doing an exam push focused on 70-461. A couple passed so far, a couple more tried and not quite, planning to do a retake.
  • Last night they were running through practice questions as a group. Interesting way to make the group feel like a group, but…

Read more

0 comments, 2 reads

Posted in SQLAndy on 18 June 2015

Presenting at the Space Coast SQL Group on August 13, 2015

I’m heading to the coast on August 13, 2015 to talk about database corruption, SQLSaturday Orlando, and the possibility of a  SQLSaturday Cocoa Beach  in 2015 with the members of the Space Coast SQL Group.

Read more

0 comments, 1 read

Posted in SQLAndy on 17 June 2015

Presenting at the Jacksonville SQL Group on September 16, 2015

I’ll be driving up to speak to the Jacksonville SQL group on September 16, 2015 on database corruption. Meeting starts at 6 pm. You can join their meetup group now, but the September meeting isn’t listed yet.

Read more

0 comments, 1 read

Posted in SQLAndy on 17 June 2015

Publicizing Mistakes

I was reading Our Journey to Cloud Cadence, Lessons Learned at Microsoft Developer Division  and saw this bit on transparency:

“No incident is done until we have captured and communicated the learning from it. We use the “5 Whys” to capture the multiple perspectives on what can be done better…

Read more

0 comments, 2 reads

Posted in SQLAndy on 16 June 2015

Working With Sponsors

Apologies for the poor photo, the example was trampled a bit on the journey home! This past weekend at SQLSaturday South Florida they put these out on the table prior to the end of the day raffle and wrap up. It’s a half sheet of yellow 8.5×11 paper, directions on… Read more

0 comments, 2 reads

Posted in SQLAndy on 15 June 2015

Marketing Materials for PASS Chapters

I brought this back with me from SQLSaturday South Florida. It’s postcard sized and laminated, and information dense in a good way. It feels like something that would be kept far more than a paper flyer or a business card. Might be interesting to make it magnetic to get it… Read more

0 comments, 2 reads

Posted in SQLAndy on 15 June 2015

Notes From SQLSaturday #379

Notes from the trip:

  • Made the trip down without stopping and without getting stuck in traffic – a first!
  • Attended speaker dinner on Fri night. Nice location, service was slow. I don’t understand how they reserve space for large parties and then fail to staff for it
  • Good signs to…

Read more

0 comments, 2 reads

Posted in SQLAndy on 15 June 2015

Notes on the June 11, 2015 ONETUG Meeting

I attended the monthly ONETUG meeting last night to do a SQL presentation focused on developers. Same location as last year, the main library downtown. About 20 attendees this time. I chatted with a few people before things go started, including one who was trying to return to IT after… Read more

0 comments, 2 reads

Posted in SQLAndy on 12 June 2015

SSC Editorial: Should Salary Information Be Confidential?

I’m expecting Should Salary Information Be Confidential? to draw a wide range of comments. I’m curious to see if many will be fear based or if there are good reasons for keeping it a secret (aside from whatever legal constraints might exist).

Look at it a different way. Imagine you… Read more

0 comments, 1 read

Posted in SQLAndy on 5 June 2015

Notes From The May 2015 oPASS Meeting

Really late posting these, forgot to put on my task list!

  • About 20 attendees
  • Lots of good questions, and I saw quite a new faces (or not recent ones) attending. That’s good and bad I guess. I worry that we’re drawing people solely based on the topic/speaker and not because…

Read more

0 comments, 2 reads

Posted in SQLAndy on 3 June 2015

Im Attending SQLSaturday #379 in South Florida on June 13, 2015

It’s almost summer and that means it’s time for a trip to South Florida for SQLSaturday #379.  I’ll be doing my presentation on Learning Plans, trying to meet the speakers I don’t know yet (quite a few), doing some learning of my own, and staying over until Sunday to enjoy… Read more

0 comments, 1 read

Posted in SQLAndy on 2 June 2015

Older posts