(Willie Favero) The last time I checked there were still 17 tables currently used by EXPLAIN (as described in my Feb 16, 2010 post “Explaining the history of EXPLAIN tables”). I hope that hasn’t gone up again sine I last checked… (smile)…
Other News
New Data Type Conversion Functions in SQL Server 2012
(Ashish Kumar Mehta) SQL Server 2012 code named Denali has a lot of new features to offer. A new set of features includes new Conversion Functions such as PARSE, TRY_PARSE and TRY_CONVERT which support data type casting and converting. In this tip we will take a look at these new conversion functio
Open Software is a Great Resource
Open Software is a Great Resource Many have written in with examples of how Open Source software has been essential to their business solutions. Today, as I close out this topic, I am including comments from David. They pretty much encapsulate the comments as a whole. David Writes: Putting on my developer hat, open source software is a great boon. […]
What Does Open Systems Mean?
What Does Open Systems Mean? All Open System software is not the same. There are number of different licensing models allowing different rights. May people equate Open System with free…but that is not necessarily true. One thing (I think) Open System software has in common is that the source code is available. Different licenses may allow you to contribute to […]
Pretty up SharePoint 2010 mysite with showModalDialog
(John Liu) The problem with My Site, even back in the days of SharePoint 2007, is that your users get lost. It doesn’t look anything like your nice branded site. It doesn’t share the same global navigation.
Execute Multiple 2008/2005 SSIS Packages with T-SQL
(Mike Davis) If you want to execute a set of SSIS packages in SQL Server 2008 or 2005, you can do this using T-SQL. First you will need a table with all of your package names on it. Then a While loop to execute each package.
Fluent C#: Application Development
(Rebecca M. Riordan) In this chapter, we’ll talk about development platforms, application architectures, development methodologies, design patterns, and best practices for C#, and where they all fit in the process of getting from here (an idea for some software) to there (a working application).
Don’t Do Azure Cloud (or any Development) on Your Own!
(Paul Ferrill) It seems like every time you turn around as a developer there’s a new technology you have to learn just to stay relevant. Moving applications to the cloud gets a lot of attention from management because they see it for the possible cost savings. What they don’t see is the amount of ef
Detect DOM changes with Mutation Observers
(Ernest Delgado) Back in 2000, the Mutation Events API was specified to make it easy for developers to react to changes in a DOM (e.g. DOMNodeRemoved, DOMAttrModified, etc).
SQL Server – Changing Rows to Columns Using PIVOT
(Paresh Prajapati) During working with one logic, i got chance to work with PIVOT operation. Sometime we need do require rowdata as column in our custom logic, then we can use some temp table and then populate agreegate data in temp table. But With PIVOT we can do it very easily. Let me prepare smal