Featured Article(s)
Review: SoftTree SQL Assistant
SQL Assistant is a tool that integrates into your environment of choice, offering to help with your SQL coding. The hope is that you will end up with standardized code, better, more efficient coding time since the tool would help you create the code and more.
One reason to use Cursors than Set based solution!
(Vadivel Mohanakrishnan) This article explains an example where ‘Cursors’ outperforms ‘Set’ based solution in SQL Server.
Featured Free Tool: Digipede
Head to our free software center for more information: http://bitonthewire.wpengine.com/free_software
Digipede – Grid Computing for .NET – The Digipede Network is a grid computing solution that delivers dramatically improved application performance for Windows applications. It includes the Digipede Framework SDK, which enables .NET developers to build scalable, high-performance, distributed applications in the Visual Studio environment. Scale compute-intensive middle tier software by combining the power of many cores, processors, and machines. The Developer Edition is a free, fully featured version of the software.
New Search Approaches
I noticed this article talking about CES, going on now in Las Vegas. While it’s ironic that they chose "SQL" as the search term that they were using to talk about the new search results tools, what really had me thinking was the new ways they’re developing to present information when it’s presented to users.
In the example in the article, if you search on "SQL," for example, you end up getting back clustered results – so not only is it figuring out likely relevance (as may be the case with a Google-type search), but it’s figuring out the relevance and logical grouping of the search results to one-another. Cool.
I wonder if SQL Server will include this as a native ability – where you could flip a bit in the full-text index-type search and ask it to pull back things clustered with the most likely clusters of successful search hits shown first. That would be pretty nice!
I keep waiting to hear about Bill Gates talk about storage tools at CES and some cool thing doing this or that, only to find out it’s SQL Server. Why would this be neat? Because if he’s talking about it at CES, it would mean it (SQL Server, or the service it’s supporting anyway) was a consumer-level tool – a commodity. That would be life-changing for the applications and how SQL Server will have moved into being the storage subsystem rather than a database. I think once that happens "officially," we’ll see additional cool applications (like the search clustering) that are supported by the database with more commonplace commands, not exotic application subsystems driving them.
Featured White Paper(s)
Data modelers – 7 Steps to Success – Building a Collaborative Team Environment
Your data models are brilliant… but only if the DBAs and developers are on the same page. Often, there is a significant dis… (read more)
IT Director’s Reference Series: Practical Guide to Sarbanes-Oxley IT Internal Controls
Sarbanes-Oxley is the most comprehensive financial regulatory law in US history. It places responsibility for accurate and re… (read more)