I like to repost this blog about once a year, because you really really need to know about windowing functions. So, happy November! Here’s a quick summary of OVER and PARTITION BY (windowing functions, “new” in SQL 2005), for the uninitiated or forgetful… OVER OVER allows you to get aggregate information without using a GROUP […]
Category: Tech and Learning
Quick note: Redgate SQL Data Compare using the command line
I’ve been working on an automated data compare process for one client. I’ve been struggling a little with odd hangups and errors with the SQL Data Compare command line interface, but one particular StackOverflow post solved my final problem. So here’s the final solution: Create a data compare project using the Redgate GUI. Run the compare […]
MidnightSQL Server Evaluation script, version 1.0
Server evaluations are a major part of my consulting business. I need to get up to speed very quickly on a server when I first start a project, and uncover the big potential issues. So, I started developing a set of scripts to help me gather and summarize that information fast. What I have now is […]