$$SWYNK$$ SQL Tip – SP_Execute_SQL For those rare occasions when you really must build dynamic SQL for your SQL Server instance while using scripts or stored procedures. When doing this you have two options. EXEC(‘SQL Statement’) Or Sp_Execute_SQL There is a big difference between the two. The exec method operates completely as an ad-hoc query. If every command is EXACTLY […]
Other News
How Simple Is Logging?
(Kalen Delaney) As anyone who works with SQL Server should know by now, the transaction log is a vital component of any SQL Server database. Talking about the log is one of my favorite topics, but just to describe the common misunderstandings would take far more space than I have available in this s
Performance impact: The cost of doing small lookups in a large batch update
(Linchi Shea) Lookup tables are widely used in database applications for good reasons. Usually, a lookup table has a small number of rows and looking it up with a join is fast, especially when the table is already cached.
SQL SERVER – Add New Column With Default Value
(Pinal Dave) SQL Server is interesting and the people who work with SQL Serve rare even more interesting. The amount of communication, the thought process, the brain storming they do is always phenomenal. Here is the quick conversation I have observed in one of the organization I recently visited.
XML v.next
(Norman Walsh) If you weren’t paying attention when XML was being designed, it may seem odd that it carries so much SGML heritage on its back. Surely, it could have been made even simpler if it didn’t have to be compatible with SGML. And it really didn’t, did it?
Convert XML to JSON with JavaScript
(David Walsh) If you follow me on Twitter, you know that I’ve been working on a super top secret mobile application using Appcelerator Titanium. The experience has been great: using JavaScript to create easy to write, easy to test, native mobile apps has been fun.
Build Automation and Lab Management with Team Foundation Server 2010
(Jani Jarvinen) When it comes to processes that can take manual labor out of development, build automation immediately springs into mind. In the world of Team Foundation Server, organizations using the product can use a wide set of functionality. This includes not only build automation, but also aut
Programmatically Accessing ADF Task Flow List
(Andrejus Baranovskis) Based on different scenarios, you may need to implement solution to access ADF Task Flow list available inside ADF application. These scenarios can be really different, for example you may construct UI Shell menu based on available ADF Task Flows or simply present list of avai
Oracle XE 11gR2 – the free eXpress Edition for Oracle Database 11gR2
(Lucas Jellema) It is only beta at this point, but the long awaited Oracle 11gR2 XE edition – free but with certain limitations – is available for download from OTN – http://www.oracle.com/technetwork/database/express-edition/11gxe-beta-download-302519.html.
The Power of Oracle PROFILES
(James F. Koopmann) While the locking and expiring of user accounts, through commands, is the first step in securing who can connect to an Oracle database, these single commands are more for, in my opinion, for use in singular and pointed scenarios.