I have always enjoyed reading articles and blogs which are different then others. There many be thousands of technology and programming blogs, only few makes difference in the tech world. One of the high quality blog, I enjoy reading is relationary by Grant Czerepak. Grant Czerepak is an IT professional with over 20 years experience in relational database technology specifically in the areas of design, development and administration.
As per Grant Czerepak “In this blog I will be mixing, matching, shifting and sifting paradigms that have come up in my work with relational databases and other concepts I’ve picked up while taking my time to explore the nooks and crannies of my university’s course calendar over seven years, studying the entire NIV version of the Bible over three years, travelling in southeast asia, reading broadly and having several good friends to exchange ideas with over coffee and across the internet. I hope to make entries daily and keep this blog interesting and stimulating.”
Grant Czerepak is also writing book from the posts and articles in his blog. I am really looking forward to read his book. I wish we all know the arrival date of his book.
A blog which is making difference in tech world : relationary
Reference : Pinal Dave (https://blog.sqlauthority.com)
2 Comments. Leave new
What do you think about using stored procedures as the ONLY avenue for accessing the database?
I view stored procedures as the headmaster in Oliver Twist.
The applications programmer comes up to the headmaster and asks “Please sir, may I have some data?”
The benefits of stored procedures are that it adds another layer to getting to the database. For people just learning ColdFusion, this is an unnecessary burden – they’re just trying to learn how to do a cfquery. If stored procedures are enforced, cfquery is obsolete (except for query of queries).
Once all access to the data has to go through sprocs, the dba can then start logging who is updating what, and even who is SELECTing what.
Of course, one of the required parameters should be a UserID as well.
If we know the user, then we can add a filtering capability to the database.
“You may WANT SELECT *, but you’re only allowed to view name, rank and serial number”.
In addition, sprocs provide a layer of abstraction. Let’s say you want someone’s cell phone number. You would call the necessary stored procedure and ask for his cell phone number. Never mind if it’s a field in the person table or a field in related table – you just want the cell phone number and you don’t care how it looks physically in the database schema.
This allows us to begin thinking about Object Oriented database design. You want his address – not specifically his Address1, Address2, City, State, Zip, Country; just his address please.
Dave,
Every single experienced DBA I know figured out that Grant Czerepak is spewing nothing but nonsense.
Witness his ramblings on this thread, which he actually links to on his website, and the reactions of professional DBAs:
“Pactory Tractory Exactory”????
“I have arrived at the tables by deconstructing Einstein’s and Newton’s equations.”???
WTF, dude?
His Emperor has no clothes, and its a pity you could not figure that out yourself.