$$SWYNK$$ Are you Ready for IPv6? According to information I gleaned from IPv6.com, the new internet protocol has a lot more going on than expanding the number of available network addresses. It has features enabling new hardware and software to work more efficiently. Summarizing their site, they list 10 key improvements over the 30 year old IPv4 internet protocol. • […]
Author: Ben Taylor
IDENTITY Results Clarification
SeleccTViews With Stephen Wynkoop Watch as Scott Gode from Azaleos talks with Stephen about gaps between private cloud systems and Office 365. IDENTITY Results Clarification I received an Email correcting my description on the behavior of both SCOPE_IDENTITY and @@IDENTITY. Also, there was a twitter response regarding the behavior of IDENT_CURRENT as well. Don Writes: In Getting rid of @@Identity […]
IDENTITY Results Clarification
SeleccTViews With Stephen Wynkoop Watch as Scott Gode from Azaleos talks with Stephen about gaps between private cloud systems and Office 365. IDENTITY Results Clarification I received an Email correcting my description on the behavior of both SCOPE_IDENTITY and @@IDENTITY. Also, there was a twitter response regarding the behavior of IDENT_CURRENT as well. Don Writes: In Getting rid of @@Identity […]
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 […]
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 […]
Trigger Tension
$$SWYNK$$ Trigger Tension You have a process that inserts a record into a table. You also have a trigger that fires after the insert event on the same table. Inside that trigger, you insert a record into a second table. When you attempt to get the identity value assigned from the insert, what value will be returned? The identity value […]
Trigger Tension
$$SWYNK$$ Trigger Tension You have a process that inserts a record into a table. You also have a trigger that fires after the insert event on the same table. Inside that trigger, you insert a record into a second table. When you attempt to get the identity value assigned from the insert, what value will be returned? The identity value […]
Covering Index
Covering Index Today I decided to talk about covering indexes. I was pleased to find there has been a lot of recent activity on covering indexes posted here at www.sswug.org. Simply go to our site and type “Covering Index” in the search box. You’ll find many posts. For our Accidental DBA friends, or those new to relational databases, a Covering […]
Covering Index
Covering Index Today I decided to talk about covering indexes. I was pleased to find there has been a lot of recent activity on covering indexes posted here at www.sswug.org. Simply go to our site and type “Covering Index” in the search box. You’ll find many posts. For our Accidental DBA friends, or those new to relational databases, a Covering […]
Version Control and Version Differentiation
$$SWYNK$$ Version Control and Version Differentiation I stated last week that a key reason I don’t care for a number of software development tools is that they do not lend themselves to the ability to integrate with existing version control products allowing you to see in a human readable form the modifications from one version to the next. Most diff […]