(Kanchana Padmanabhan) Stored procedures and functions are highly valued for the efficiency with which they can carry out database logic. But they also come with a high level of complexity, which can challenge application writers.
Other News
Overview of ASP.NET MVC
(Ashish Shukla) The ASP.NET MVC Framework is Microsoft’s Web Application development framework. The framework was built to make it easier to implement software design principles. Secondly the framework at its very core supports building unit tests so the MVC applications are highly testable. And as
Controlling the use of linked objects in SSAS
(Siddharth Mehta) Linked objects in SSAS should be used very carefully, as the object resides in the original cube and just a link is created in the target cube. The risk is that when multiple teams are working on different projects, people can take a shortcut for faster development and create links
TOP (10) Worst Things to Do in a Database
TOP (10) Worst Things to Do in a Database The top ten list is finally here. Thanks to all your votes, (I know only three votes was hard), I have the final tally. Our top 10 list is: Count Down Database Actions to Avoid Individual Votes 10 Compensating for Bad Schema 19 9 Poor Clustered and Non Clustered Indexes 19 […]
Integrating BLOB Data With Normalized Data
SelecTViews With Stephen Wynkoop Ryan Adams joins the show today, also information about disaster recovery and planning. Additional information on recent news, the SQL Server tip of the day and much more. [Watch the Show] Integrating BLOB Data With Normalized Data As promised…we are moving on today from the topic of database normalization from the editor’s perspective. I will be […]
Index Not Being Used – Fragmentation
(Michael T. Dinh) I was experiencing FTS on SELECT for 1 record.
Cores vs Threads: Util Differences…Part 2
(Craig Shallahamer) This is so typical… What I think will be a casual research project ends up being so much more. I hope you find this blog entry very enlightening and useful.
Four common REST pitfalls
(Justin James) In the last several months, I have done integrations with a number of RESTful Web services. I understand why REST is popular; SOAP is a huge hassle to handle by hand, so if your system lacks sophisticated SOAP processing tools, it is easier to deal with REST.
Leveraging Intangible Assets Using Semantic Technologies
(Mike Bergman) Something strange began to happen with company valuations beginning twenty to thirty years ago. Book values increasingly began to diverge — go lower — from stock prices or acquisition prices. Between 1982 and 1992 the ratio of book value to market value decreased from 62% to 38% for p
Top reasons to get started with SQL Server Denali
(Roman Rehak) The last three releases of SQL Server had unofficial labels, each based on the type of user that the most new features were geared toward. For example, SQL Server 2005 was considered a developer release, while SQL Server 2008 was viewed as a release for database administrators.