(Steven Smith) Code analysis is one way you can keep your code clean and your technical debt low. One of the simplest ways to achieve this is to minimize blocks of duplicate code, usually the result of cut-and-paste coding. Atomiq is an inexpensive, simple-to-use tool that detects duplicate blocks o
Other News
Paging in ASP.NET using jTemplate, jQuery & JSON 22retweet
(Aamir Hasan) This article demonstrates how to apply paging in ASP.NET using jTemplate, jQuery and JSON. When working with a large dataset, it’s not a good idea to show all the records at once as it leads to performance issues in your website if a large number of visitors visit your site. Thus pagin
SQL Server: WAITFOR Statement
(Dhananjay Kumar) The WAITFOR statement is used to delay execution of the T-SQL command for a specified period of time. This can be used to block the execution of a batch statement, a stored procedure or a T SQL command for a specified time.
How to defragment Windows SharePoint Services 3.0 databases and SharePoint Server 2007 databases
This article describes how to defragment the following Windows SharePoint Services 3.0 databases and Microsoft Office SharePoint Server 2007 databases:
Informix DBA: More Musings on Informix 11.7
(Lester Knutsen and Art Kagel) First of all I would like to welcome Art Kagel, who is co-writing with me for this issue. Art and I have worked together for many years and in January 2010, he joined Advanced DataTools to focus on Informix database development, support, and training.
SQL SERVER – MSQL_XP – Wait Type – Day 20 of 28
(Pinal Dave) In this blog post, I am going to discuss something from my field experience. While consultation, I have seen various wait typed, but one of my customers who has been using SQL Server for all his operations had an interesting issue with a particular wait type.
Web Scale Data Storage
Query Plan Caching Workshop – Tomorrow Don’t forget to sign up for the Query Plan Caching Workshop by Kalen Delaney. It will be well worth your time. Today is the last day to register. So, Click Here to Register Now! Web Scale Data Storage Stephen brought up a few areas of concern when using non-relational kinds of storage. What does […]
OTLT Put To Bed and Unfinished Business
OTLT Put to Bed Yesterday we reviews some of the developer issues resulting in the use of OTLT (One True Lookup Table). Today I just want to talk briefly about the opportunity available for a tool to manage the contents and distribution of Lookup Tables. There are number of tools today doing a great job of comparing database table contents, […]
Error message when you use SSL for connections to SQL Server: ‘The certificate received from the remote server was issued by an untrusted certificate authority’
Consider the following scenario: –You configure the Secure Sockets layer (SSL) protocol to encrypt connections to a Microsoft SQL Server which version are listed in “APPLIED TO” section. –A trusted certificate is not installed on the computer on where SQL Server is installed.
SQL Server 2008 Service Broker – Conversation Priorities
(Arshad Ali) SQL Server Service Broker (SSBS) is a new architecture (introduced with SQL Server 2005 and enhanced further in SQL Server 2008 and SQL Server 2008 R2) that allows you to write asynchronous, decoupled, distributed, persistent, reliable, scalable and secure queuing/message-based applicat