(Suprotim Agarwal) Compound assignment operators are newly introduced in SQL Server 2008 and the code certainly looks cleaner and easier to type while using them.
Other News
How to configure Oracle Internet Directory with a new configuration set?
(Mahendra) This post talks about configuring OID with a new configuration set. First of all, let me tell you the necessity of a configuration set. OID by default uses configuration set 0 with certain pre-defined options.
Three tips for tweaking SQL Server’s SharePoint performance
(Don Jones) If you’re a “reluctant DBA” supporting Microsoft SQL Server, in an environment that uses SharePoint Server, you may find yourself wondering how you can get better SQL Server-SharePoint performance.
Clauses and Logical Operators for Retrieving Table Data
(Joel Murach) In this sixth part of a nine-part series that focuses on retrieving data from tables with the SELECT statement, you’ll learn how to code the WHERE clause and how to use comparison and logical operators.
Parsing CSV Data With An Input Stream And A Finite State Machine
(Ben Nadel) I’ve talked about parsing CSV (Comma Separated Value) data on this blog a number of times, both in ColdFusion and in JavaScript. Every now and then, someone brings up the fact that ColdFusion may run out of memory when parsing ginormous files.
More performance results for max_concurrent_queries
(Mark Callaghan) I have more performance results for a feature enforces the maximum number of concurrent queries an account may run.
Roles and Trusted Context
(Troy Coleman) During the SHARE conference in Orlando, I was standing in the vendor hall having a discussion with someone about DB2 security.
dbms_xplan.display_sql_plan_baseline can also lie !
(Coskan Gundogar) This blog post is about another buggy/funny/misleading behaviour which you MUST know if you are using baselines ( especially in a non-controlled fashion by let oracle manage them).
Designing SSIS Packages for High Performance
(Stacia Misner) The process for designing SQL Server Integration Services (SSIS) packages is typically iterative. You start by getting the components working individually or in small sets, then concentrate on ensuring that the components will work in the correct sequence.
How to Implement 2-Step Verification in ASP.NET MVC
(Keyvan Nayyeri) Nowadays security is more important than ever on the internet, and the majority of security issues on websites are caused by user accounts being compromised. As a good prevention strategy, the use of 2-step or phone verification mechanisms is becoming common on the internet. In this