Before SQL Server 2008 there was no native method to pass sets to a stored procedure or function. With SQL Server 2008 they introduced the User Defined Table Type. You could define a type just like a table, and pass in data using a variable of that type allowing sets of data to be passed to stored procedures like never […]
Other News
SSWUGtv: How introverts can break into a manager role even though they aren’t the most aggressive/outspoken?
Video Programming for IT Professionals Career management advice, coaching and much more. We discuss making the best of your professional development, provide specific tips and ideas for advancing your career and even answer questions from field.
MVC and jQuery with WCF Data Service
(Chathuranga Muthukumarana) In this tip, you can learn about how to use WCF data Service (ODATA) with MVC and jQuery.
A Guide to Diagram – Part 1 – Data for Nodes and Links
(Duncan Mills) I guess the first thing to get your head around with diagram is the core data structures that are required. Fortunately this is not a very complex area although it does differ in one small respect from that for other components that you might be worth dealing with.
Back to Buffer Pool Basics: Part 4 – The -DISPLAY Fields
(Willie Favero) We’ve already talked about how to run the DB2 –DISPLAY BUFFERPOOL command, now it’s time to discuss the information produced by the command, the command’s output.
Why %util number from iostat is meaningless for MySQL capacity planning
(Peter Zaitsev) Earlier this month I wrote about vmstat iowait cpu numbers and some of the comments I got were advertising the use of util% as reported by the iostat tool instead. I find this number even more useless for MySQL performance tuning and capacity planning.
Using Scope.$watch() To Watch Functions In AngularJS
(Ben Nadel) Most of the time, when I use $watch() in AngularJS, I am watching a $scope reference contained in a String value. But, you can also watch a Function. When you do this, your $watch function gets called multiple times per digest; and, if it returns a value, that value gets used, by Angular
SQL Server Stored Procedure to remove outliers from data sets
(Tim Smith) We have data sets with various algorithms stored and we’d like to construct an automated process that builds additional data sets from these original sets, except without outliers.
Permission to Add Replies to List Items For Discussion List in SharePoint 2013 Using jQuery
(Veda Bs) This article explains how to restrict permission only for a specific group for a Discussion Content Type in SharePoint 2013 using jQuery.
SOA Suite 12c: The demise of the OSB and … the glorious birth of the SB
(Lucas Jellema) Oracle has too many products. The range of acronyms is not infinite, especially when most of these acronyms start with an O and have three letters. As it turns out, OSB is Oracle-ese for Oracle Secure Backup. Well, and it used to also stand for Oracle Service Bus – but starting with