(Paresh Prajapati) You may worked with Service Broker in SQL Server. I am just learning Service Broker and implemented practically with an examples which i evaluated. Before moving on it i would like to introduce service broker, not in the deep but having some overview. Service broker appliees to SQ
Other News
Handy Oracle Scheduler Troubleshooting Tip
(David Clement) I’ve found the following query handy for investigating an ORA-12012 in an alert log. ORA-12012 is a dbms_scheduler execution error and it provides a job number without a name, where the Scheduler views give job names without numbers.
Do bind variables matter?
(Lewis Cunningham) That title is somewhat facetious. Even without a performance benefit using bind variables is more secure and easier to maintain but do they really make a difference in performance?
SQL Server: Move Data to a Different Table using OUTPUT clause
(Madhivanan) Suppose you want to move some data from one table to another table and then delete the data from source table. In versions prior to SQL Server 2005, this is done in two steps.
MySQL Clusters on Amazon EC2 – verified AMIs
(Johan Andersson) We regularly receive questions from our user community with regards to which AMIs to use when deploying database clusters on Amazon EC2.
Solid-state drives: Changing the data world
(Paul Pendle) Solid state drives represent a quantum leap in enterprise storage performance over hard disk drives and Fibre Channel drives. With these new drives, you may need to reevaluate some of the ways that you deal with databases, as the move from spinning disks to solid-state technology will
Usability
$$SWYNK$$ Usability Today, to finish up the week, I decided to take a topic that is as hard to nail down as Jello; usability. I am not a usability expert. But I do know when something doesn’t work. I’d like to pick on Facebook today because it is often held up as an example of modern usability. Frankly, I find […]
Cross Apply Table Functions
SelecTViews With Stephen Wynkoop Dell enters the Cloud Provider Space, Nokia breached with SQL Injection Attack, interview with Monotouch developer Michael Bluestein about Development with Monotouch as a technology to use your C# skills on iPhone, iPad and Android platforms. Watch the Show $$SWYNK$$ Cross Apply Table Functions I have really enjoyed the use of TSQL functions in SQL Server. […]
Advanced AOP Techniques
(Eric Vogel) In my previous article Clear Cross-Cutting Concerns with Aspect Oriented Programming in .NET, I covered the basics of Aspect Oriented Programming (AOP). Since then I’ve received some feedback asking for ways to utilize AOP for more advanced tasks such as security and threading, and will
Polish the EPUB
(Colin Beckingham) In EPUB documents, you cannot detect some problems with normal validation methods. As long as the document validates as well-formed XML and follows the EPUB standard, it can appear to be correct but might not read correctly in an e-Reader.