(Susan Visser) Once you register for IOD you’ll be sent a confirmation email that will tell you about the pre-conference education sessions that are available. Maybe you’ve heard of these before. They are full day classes that go deep in a particular topic. These classes have an additional cost.
Other News
SQL SERVER – Use INSERT INTO … SELECT instead of Cursor
(Pinal Dave) This blog post is written in response to the post showing some of the worst practices of past. Well, just like last month’s theme, everybody learns by doing it one step at a time.
Reading an AWR — 2
(Hemant K Chitale) I have extracted this from an AWR report :
Finding CURRENT_USER for any user
(Shlomi Noach) A MySQL account is a user/host combination. A MySQL connection is done by a user connecting from some host.
C#: Using IDictionaryEnumerator with HashTable
(Suprotim Agarwal) The IDictionaryEnumerator enumerates the elements of a non-generic dictionary like a HashTable. It is a strongly typed enumerator which inherits IEnumerator by adding three properties:
My Bet is That You’re a Hoarder…Me Too.
My Bet is That You’re a Hoarder…Me Too. I don’t know if you’ve seen the series of shows on a couple of different cable networks on hoarding, but they’re pretty interesting looks at the psychological triggers people go through in "collecting" – it seems like so many of the folks that are facing this say something along the lines of […]
Replace @@IDENTITY
$$SWYNK$$ Replace @@IDENTITY Yesterday we talked about the difference between the behavior of @@IDENTITY and SCOPE_IDENTITY(), especially as it relates to triggers. Today I’ll present an option for returning assigned IDENTITY values without relying on global variables or system functions, which are not guaranteed to behave as you may wish. @@IDENTITY is a global server wide variable returning the last […]
How to Create XML-Based Systems
(Roger L. Costello) An implicit tenet of the XML technologies is that data is a first-class citizen—it is not to be hidden away in a closet, behind locked doors. Data should be:
The Different Forms of Animate in SVG
(Darla Ferrara) If you are interested in pursuing scalable vector graphics animation, you are going to need to understand the different forms of animate in SVG. Animate is the element that triggers motion in this form of graphic. When designing transformations, you use transform as a sign post that
Take care while using SELECT Clause for Variable Assignment in SQL Server
(Paresh Prajapati) I ran through in one issue while working in one of the stored procedure and using SELECT clause while variable assignment. And i suffered this issue in live production environment and due to this it was killing the Server CPU.