SQL windows functions, it would seem, get lost in the shuffle most of the time when dealing with SQL. Why do you think that is? I honestly think that it is more or less developers, DBA's, and data professionals are oblivious to some of the cool features that can be accomplished with its utilization. To put … Continue reading Windows Functions; Who Knew?
This months T-SQL Tuesday block party is coming from the renowned Jason Brimhall (blog|twitter). You see each month a SQL Community member hosts this block party and this months theme is “Place Your Bets”. So you want to gamble? Come on up to the SQL table and place your bets. Any Data Professional is welcome … Continue reading T-SQL Tuesday #051: Place Your Bets
It’s that time again for the T-SQL Tuesday party! This party was created by none other than Adam Machanic (Twitter). If you are interested in hosting a party at some point this year give him a shout; you need to have participated in two T-SQL Tuesdays along the way and also maintain your own blog … Continue reading T-SQL Tuesday #040: File and Filegroup Wisdom
Something that I have seen lately over and over again and even ran into this morning is a practice that I would say is a pretty bad habit in SQL….the dreaded Select * syndrome This method is heavily used for adhoc querying and I've seen it used in some troubleshooting scenarios but in my case … Continue reading Select * Syndrome
Recently, I approached a person in a business unit and asked if they had some standard documentation on one of their processes. The reply I received in general terms was, "No we do not have any standard documentation but we do continue to build on our processes". Knowing how I am, I began to read … Continue reading To Document or Not To Document ~ That is the question