I was reading the Voice of the DBA and it referred to a post by Brent Ozar about caching at the database level. After discussing it with my homey, he thought it sounded a lot like memoization (I like to say it with a 3 stooges voice, mem moy Zay Shun). According to wiki, Memoization is a specific case of optimization, which seems to be what we are doing when we cache the results of a stored procedure.
In college one of my mentors was a jedi master of simulations and testing. The guy could write a simulation for just about anything you can think of, and with anything you can think of. I’m pretty sure that he once made a neural network for simulating dinosaur procreation rates…using sticks and mud (true story). Simulating workloads can help you thoroughly test ideas and present data to management that will allow them to make informed decisions. IRL, your career will be much happier if you can test your ideas BEFORE deploying them to production. No one is asking you to have good ideas all the time, but the business is depending on you to come up with ideas that will work as intended. The only way to accomplish this responsibly, is to test.
With my recent move to into a software development team I find myself paying more attention to software engineering techniques and tactics, one of them being source control. In the past I’ve had a very manual…archaic…system for maintaining indexes.
There may come a time in your career when you are tasked with finding out how a 3rd party application functions because some 3rd parties have completely closed source applications, or better yet, APIs that perform poorly. Microsoft SQL Server Profiler can help you identify what tables are used, procedures and what data is inserted when functions are run.
I came across a wonderful script by SQLDenis at Less Than Dot – Blog. I have been mapping data between a Numara TrackIt 8 system and a ManageEngine ServiceDesk system. While trying to find out how ManageEngine maps fields (with no database documentation, or assistance from their support team), I came across some fields on the web form that I needed to map, but I couldnt find them in the database. SQL Search by RedGate helped to some degree, but in this case I needed something a little faster.
Using the sp written by SQLDenis at http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/the-ten-most-asked-sql-server-questions–1#2 , I was able to put an identifying string (think codeword) then search it out. This enabled me to find form fields that used columns in the db named “Attribute_301” etc.
Thanks SQLDenis, you may take your place among the real men of genius.
So you might already know this, I didn’t and it kicked my ass for 30 minutes.
So you have a report deployed in reporting services, it takes date parameters, you want it to execute lets say…between Yesterday and Today…