(Jovan Popovic) Microsoft ASP.NET MVC framework follows a standard MVC pattern – Model contains data that will be shown, controller performs actions when some event happens, initializes model and passes it to the view, and view takes a model and renders HTML output that would be sent to the client b
Other News
Integrating BLOB Data With Normalized Data
SelecTViews With Stephen Wynkoop Ryan Adams joins the show today, also information about disaster recovery and planning. Additional information on recent news, the SQL Server tip of the day and much more. [Watch the Show] Integrating BLOB Data With Normalized Data As promised…we are moving on today from the topic of database normalization from the editor’s perspective. I will be […]
How Much Normalization is Enough?
How Much Normalization is Enough? I’m pretty sure you’ve already had enough of this topic as well. I have had a number of contacts from accidental DBAs and new developers in appreciation of the great lessons shared from real world problem solving. J writes in with an ERD (Entity Relationship Diagram) emphasizing how detailed you can get with your normalization. […]
XQuery and XPath Regular Expressions
The W3C standard for XQuery 1.0 and XPath 2.0 Functions and Operators defines three functions fn:matches, fn:replace and fn:tokenize that take a regular expression as one of their parameters.
Building XML Workflow Applications
(Dr. Michael Kay) In my previous articles, I introduced some of the mechanics of coding with XQuery and XSLT 2.0 — in a rapid progression from novice to advanced level I started with a brief ten-minute introduction to XQuery, went on from there to explore FLWOR expressions in some depth, and then ex
Suppress Output in SQL*Plus
(chet justice) A friend of mine IM’d me asking if there was a way to supress the output of a query in SQL*Plus. I imagined what he was looking for was similar to what SET AUTOTRACE TRACEONLY does…without all that output.
YAPO-4068: Yet Another Post on ORA-04068
(Neil Johnson) I’ve had discussions with developers over the last few months about how to deal with the dreaded ORA-04068.
Letting the Usage Reporting feature show you the way
(John “JB” Brock) Some times when you’re looking to start an extension project, you’re just not quite sure where to start to accomplish the task that you have in mind. Maybe it’s something that is already possible in JDeveloper, but you just want to modify it in some way, or do things a little bit
Executing a SSIS Package from Stored Procedure in SQL Server
(Arshad Ali) Here are two different ways a SSIS package can be executed from a stored procedure. In the first approach, we will create a job, making SSIS package call a job step and executing it by calling the sp_start_job system stored procedure from the user defined function. In the second approac
Rolling Out 101 Samples
(Roman Schindlauer) StreamInsight’s LINQ query and analytics language is powerful and versatile. To ease users and developers over the inevitable initial learning curve, we know that high-quality documentation and a variety of examples are absolutely crucial. While we are trying to improve the forme