08 July 2014
It’s T-SQL Tuesday today. The topic: assumptions, things that are accepted as true, without proof.
There are some great posts to read.
|Ken Wilson (@_KenWilson||blog ) writes about why we do things because “that’s the way it’s always been done”.|
|Aaron Bertrand (@AaronBertrand||blog ) writes about common assumptions people make about how SQL Server works.|
|Boris Hristov (@boris||blog ) writes about how many brilliant professionals don’t train or present because they assume something is stopping them.|
|JK Wood (@sqlslacker||blog ) writes about data teams that build complexity on top of complexity by assuming everything exists for a good reason.|
|Mickey Stuewe (@SQLMickey||blog ) writes about why it’s important to list your assumptions when starting a project.|
|Sebastian Meine (@sqlity||blog ) writes about the dangers of assuming your company is safe from attacks (a.k.a. “security by obscurity”)|
|Rob Farley (@rob_farley||blog ) writes about the danger of assuming SSIS lookup transformations work like JOINs, and how to create lookup transformation behavior using T-SQL.|
|Russ Thomas ( @sql_judo||blog ) writes about the dangers of assuming something isn’t your problem.|
|Jeffrey Verheul (@DevJef||blog ) writes about teams that assume their tests are complete, their automation never fails, and people who assume they know the answer to every question.|
|Adam Mikolaj ( @SqlSandwiches||blog ) writes about what happens when everyone assumes a problem is your company’s fault.|
|Kenneth Fisher ( @sqlstudent144||blog ) writes about the dangers of assuming online answers are correct, and what to do to check.|
|Jason Brimhall ( @sqlrnnr||blog ) writes about the benefits of assuming responsibility, rather than assuming somebody else will take care of it.|
|Julie Koesmarno ( @MsSQLGirl||blog ) writes about ways to validate assumptions using T-SQL.|
|Warwick Rudd ( @Warwick_Rudd||blog ) writes about the assumptions people make when creating indexes.|
|Wayne Sheffield ( @DBAWayne||blog ) writes about a common ‘smart’ assumption: a table will return data in clustered index order without an ORDER BY clause.|
|Cathrine Wilhelmsen ( @cathrinew||blog ) writes about how assuming responsibility is a way to own, and question, assumptions.|
|Vicki Harp ( @vickyharp||blog ) writes about one a common gotcha: date formats and regional assumptions.|
|Chris Yates ( @YatesSQL||blog ) writes about the dangers of assuming your backups are good.|
There is some amazing wisdom in these posts. I’d recommend reading each and every thing here. Twice. Don’t assume you already know these lessons (see what I did there?).
T-SQL Tuesday was started by Adam Machanic ( Blog | @AdamMachanic ) in 2009. It’s a monthly blog party with a rotating host, who is responsible for providing a new topic each month. In case you’ve missed a month or two, Steve Jones ( Blog | @way0utwest ) maintains a complete list for your reading enjoyment.
Thanks for blogging, and for reading!