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 2014

See Consolidated Data About SQLSaturday (Events, Sponsors, And Speakers)

Yesterday Kendal Van Dyke posted a file to Skydrive with consolidated information from all the events published so far. He built it by grabbing the individual event feeds and I’m guessing some scraping to come up with a file that is useful. Kudos to Kendal for doing this, it fills… Read more

0 comments, 1,150 reads

Posted in SQLAndy on 31 January 2014

Famous Move Quotes–Visualized

Ran across this poster of movie quotes – $20 will get you a copy. Why might you be interested? The visualizations of the quotes!

Read more

0 comments, 1,220 reads

Posted in SQLAndy on 31 January 2014

Security, Compliance, and SQL Server – Recording Now Available

If you missed it live you get a second chance! http://www.mssqltips.com/sql-server-video/284/security-compliance-and-sql-server-video/. Had about 300 attend and more questions than we could answer in the time left, will try to do some follow up posts in the next week or so to answer them (and feel free to post questions… Read more

0 comments, 1,093 reads

Posted in SQLAndy on 30 January 2014

Uninstalling SSMS on Server Breaks SQL Powershell

I reviewed my daily report and saw that some jobs failed on six instances overnight, the common factor being that they all used Powershell. None of them had failed recently or been changed recently, and the same code executed fine on many other instances in the same time frame.  Here… Read more

0 comments, 1,751 reads

Posted in SQLAndy on 30 January 2014

Reminder: I’m Presenting Security, Compliance, and SQL Server Today at 3PM Eastern

I hope you can make time for a learning break at work today – register directly at https://www2.gotomeeting.com/register/279348610 to learn more about how to deal with your corporate Security and Compliance teams, and what you can do to keep your databases secure.

Read more

0 comments, 543 reads

Posted in SQLAndy on 29 January 2014

Movie Adaptations of Books

I’ve never written a novel or a movie script, but I’ve sure consumed a lot of both and enjoy both. I’ve always been excited when a book I have read becomes a movie. Validation of a sort I guess – I like something popular! But really it’s a chance to… Read more

0 comments, 786 reads

Posted in SQLAndy on 28 January 2014

More On The Target Breach

Over the past week there has been information finally coming out about how the Target breach occurred. This write up in Wired and another by Brian Krebs point back to a compromise in the Point of Sale (POS) system by malware that does ‘memory scraping’. Interesting. Typically POS devices are… Read more

0 comments, 926 reads

Posted in SQLAndy on 24 January 2014

More on Password Managers

Last week I posted about reviewing passwords and mentioned using a password manager as part of that effort. DaniSQL noted in a comment a whitepaper about some browser vulnerabilities that can impact password managers – http://isecpartners.github.io/whitepapers/passwords/2013/11/05/Browser-Extension-Password-Managers.html. It’s a quick read and as always when we talk about security it… Read more

0 comments, 784 reads

Posted in SQLAndy on 23 January 2014

Three Hundred!

Just announced on Friday, SQLSaturday #300 will be held in Kansas City, MO, on September 13, 2014 . Everything about that is amazing, but especially the organizers and speakers that put in a lot of hours to make events happen – thank you!

Read more

0 comments, 479 reads

Posted in SQLAndy on 21 January 2014

Using Outlook.com

I looked at Outlook.com when it launched and recently revisited. I connected a couple of my personal email accounts to it via POP3 without issue and started using it.  It’s a pleasant change from OWA which always felt heavy. Its responsive but doesn’t give up the Outlook paradigm. It’s comfortable.… Read more

0 comments, 534 reads

Posted in SQLAndy on 21 January 2014

Moving WordPress to Windows Azure

For the past year or so I’ve hosted this blog at Godaddy using their web hosting service. It took a little getting used to compared to having a full server, but overall it worked well enough. Performance has been up and down, ranging from ok to terrible, which I’d guess… Read more

0 comments, 1,583 reads

Posted in SQLAndy on 21 January 2014

One More Minute

Ever say “one more minute” while working on something and then realize 30 minutes have gone by? My daughter has caught on to this – during a recent trip to the bookstore she wanted me to come look at something and I said “one more minute”. How long is a… Read more

0 comments, 633 reads

Posted in SQLAndy on 17 January 2014

Notes From the January 2014 MagicPass Meeting

I went 30 miles south last night for the first meeting of the year. Extra good night because I was taking someone with me for their first MagicPass meeting! Meeting went well, enjoyed the open floor time and also the idea of having a topic to discuss during the dinner… Read more

0 comments, 483 reads

Posted in SQLAndy on 16 January 2014

How To Encourage Someone To Run For the PASS Board

Email them, call them, instant message them – pick your preferred method, and send a message that says “I think you’d be a great candidate for the PASS Board this year”. Add to if you will, but start the conversation. Remember that we all struggle to know when and if… Read more

0 comments, 504 reads

Posted in SQLAndy on 16 January 2014

A Server Bench

This past weekend I was doing some early Spring cleaning and decided it was time to throw out two old servers. Still working, but long past their prime – purchased in 2006. They are sturdy boxes as far as construction, something I noticed as I was carrying them to the… Read more

0 comments, 625 reads

Posted in SQLAndy on 15 January 2014

Should You Run For the PASS Board? How Do You Decide?

Here are some of the questions I ask when someone is thinking about running for the Board:

  1. Are you eligible? Read the application. Do you have meet all the requirements? Can you get credible letters of recommendation to support the application?Willing to put in the 2+ hours to fill it…

Read more

0 comments, 540 reads

Posted in SQLAndy on 15 January 2014

Google Buys Nest

I was a bit sad to see that Google bought Nest. I like upstarts that see a problem and solve it. I’m highly in favor of them profiting from doing so. I just don’t want to see Google (or Microsoft, or Apple, or Facebook, or Amazon) buy them all… Read more

0 comments, 621 reads

Posted in SQLAndy on 14 January 2014

Time to Plan For Running For The PASS Board

I know it’s only January, but if you’re at all considering being a candidate you need to get going now. You need time to figure if you’re eligible, qualified, and have the time and energy for a campaign and then two years of service. You might note that I left… Read more

0 comments, 433 reads

Posted in SQLAndy on 14 January 2014

Security, Compliance, and SQL Server Webinar on January 29, 2014

My first webinar of the year! I’m joining forces with the GreenSQL and MSSQLTips to present Security, Compliance, and SQL Server on January 29th at 3pm Eastern. I’ll be talking about how to work with/understand the Security and Compliance teams – what drives them, what they hope to accomplish, and… Read more

0 comments, 972 reads

Posted in SQLAndy on 13 January 2014

Bradley Ball at MagicPASS on January 15, 2014

First meeting of the year with Bradley Ball presenting Locking, Blocking, Latches, Deadlocks, and Spinlocks.  Let them know you’ll be attending by registering at http://www.eventbrite.com/e/magicpass-january-2014-meeting-registration-10105352381?ref=website.

Read more

0 comments, 654 reads

Posted in SQLAndy on 13 January 2014

Older posts