(Willie Favero) They say cute blog tittles should be avoided. Sometimes it’s just impossible.
Other News
Read and write Open XML files (MS Office 2007)
(ZeljkoS) With Office 2007, Microsoft decided to change the default application formats from old, proprietary, closed formats (DOC, XLS, PPT) to new, open, and standardized XML formats (DOCX, XLSX, and PPTX). The new formats share some similarities with the old Office XML formats (WordML, Spreadshee
An inside look at DB2 Advanced Enterprise Server Edition, Part 2: Q replication and federation
(David Tolleson) This article is the second in a series highlighting IBM DB2 Advanced Enterprise Server Edition (AESE) for Linux, UNIX, and Windows (LUW) — a software package that includes IBM DB2 Enterprise Server Edition V9.7 with optimization, plus a set of robust development and management tools
Creating a SQL Server Denali User Defined Server Level Role
(Ashish Kumar Mehta) While looking through the new features and improvements in SQL Server Denali, we found a potentially interesting feature which can be used to Create a User Defined Server Level Role.
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 […]
Rapid Deployment Tools – What Are Yours?
Rapid Deployment Tools – What Are Yours? I had a great discussion with an Azure MVP today – we’ll have more on that as we get the show produced and ready to go. We talked though about deployment times and the impact that the cloud is having on expectations for getting new databases up and running. It hits me that […]
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 […]
SQL Server: Common mistake while Calculating Quarter Sales
(Suprotim Agarwal) When it comes to calculating quarter sales, I have always seen developers grouping only by quarter. For eg: Assuming we have a table called SalesTable with columns – SalesDate and Qty.
Top 10: New Features in SQL Server Denali
(Michael Otey) The next release of Microsoft SQL Server, code-named Denali, is right around the corner. Microsoft has just released Denali CTP3, and the final release is expected by the end of the year. Denali continues SQL Server’s climb into the enterprise with a number of important features. Here