-->
SQL Clone
SQLServerCentral is supported by Redgate
 
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.

Archives: July 2018

The Failed One Laptop Per Child Project

I wrote about OLPC back in 2010 (and before that, somewhere back on a post I didnt port over here from SSC). It was a vision worth pursuing.  It failed though, for many reasons, perhaps not the least of the killer branding around the “$100 laptop” which turned out to… Read more

0 comments, 278 reads

Posted in SQLAndy on 30 July 2018

Zero Width Characters

Another bit of miscellany, this one shows how you can use zero width characters to tag/fingerprint data. Reminds me of the Canary Trap (if you’re a Clancy fan).

Read more

0 comments, 321 reads

Posted in SQLAndy on 23 July 2018

Paper Model of Hubble Telescope

Not even close to being about SQL, I ran across the plans for a paper model of the Hubble Telescope while doing some follow up reading on the Hale Telescope (because I just read a book about it). I haven’t attempted the model, but wanted to note it here in… Read more

2 comments, 2,296 reads

Posted in SQLAndy on 20 July 2018

Getting Schooled by Brent

Earlier this year Brent Ozar invited me to attend some of his online classes for free. Free is good! Training is good! I signed up with a few thoughts in mind:

  • I had not taken a class recently (I like to self learn, perhaps to a fault)
  • I was curious…

Read more

0 comments, 2,334 reads

Posted in SQLAndy on 19 July 2018

SQL Solver

A few months back I ran across this article for checking semantic equivalencies of queries. That’s interesting, from the perspective of someone that has once or twice rewritten a query to be faster and then discovered it was subtly different. I don’t think we have the equivalent. We can compare… Read more

0 comments, 369 reads

Posted in SQLAndy on 19 July 2018