(Jeff Hunter) I have two simple tables that I want to join in an outer join:
Other News
New course: XML Fundamentals
(Megan Russell) Dan Sullivan has just published a new course: XML Fundamentals.
How is semantic technology more flexible than relational technology?
(Rob Gonzalez) Michael from SemanticArts started this great thread on Linked In a couple weeks back. The question: How is semantic technology more flexible than relational technology?
What is ASP.NET MVC TempData
(Suprotim Agarwal) Simply said, ASP.NET MVC TempData dictionary is used to share data between controller actions. The value of TempData persists until it is read or until the current user’s session times out. Persisting data in TempData is useful in scenarios such as redirection, when values are nee
Creating Service Objects And Value Objects In A Dependency Injection (DI) Framework
(Ben Nadel) For the last couple of months, I’ve been thinking a lot about my level of programming and my architectural understanding. Currently, I feel like I know enough to get most things “done.” But, with the increasing complexity of my applications, especially those that require robust, modular
DB2 10 for LUW Tools: Love and Hate
(Dave Beulke) First, I want to thank everyone for their emails regarding the Optim products that I wrote about last week. The reasons the comment sections on the blog are shut down is because I can’t keep up with the all the spammers while I am consulting or teaching. So please keep the emails com
Did You Know? Turning Off Locking
(Kalen Delaney) Back when the lock manager was rewritten for SQL Server 7, and row level locking was added to the product, the procedure sp_indexoption gave us the ability to turn OFF either row or page locks or both, for one particular index, or for a table and all the indexes on it.
Getting started with DB2 Express-C 10.1 on RightScale
(Bradley Steinfeld) DB2 Express-C is the free edition of the IBM DB2 database. Version 10.1 has just become available for download as well as for deployment in your cloud environment.
varchar(max) in an Index
(Erin Stellato) There is one more attendee question from SQLSaturday #118 that I want to follow up on, and it is this: “Is there any way to create an index with a varchar(max) column as the leading column?”
SQL Server Upgrade Advisor, Upgrade Assistant can ease transition pains
(Robert Sheldon) You’ve been waiting for SQL Server 2012 to arrive, and now that it’s here, you’re ready to make the switch. You’ve verified software and hardware requirements. You’ve put the resources necessary to test and implement a new system into place. But you might be forgetting something imp