sqlserverimpressions.blogspot.com
SireeS SQL Server Impresssions: November 2008
http://sqlserverimpressions.blogspot.com/2008_11_01_archive.html
SireeS SQL Server Impresssions. Thursday, November 27, 2008. SQL Server 2008 MERGE. MERGE statement performs insert,update or delete operations on target table based on the results of a join with source table. Here is a simple example. Update rows when matched. Insert if rows donot exist in the target table. Delete if rows donot exist in the source table. Update rows when matched. Insert if rows donot exist in the target table. Delete if rows donot exist in the source table. Update rows when matched.
sqlserverimpressions.blogspot.com
SireeS SQL Server Impresssions: June 2009
http://sqlserverimpressions.blogspot.com/2009_06_01_archive.html
SireeS SQL Server Impresssions. Tuesday, June 16, 2009. SQL Server 2008 Resource Governor. Resource Govenor enables to manage SQL Server workload and resource utilization. Resource Pool – It is a collection of physical resources. SQL Server 2008 has two built in pools, default and internal. It allows to create maximum of 18 user defined pools. Workload Group –. Limited to only CPU bandwidth and memory management. Only one instance of SQL Server can be managed. Create resource pool to be used. REQUEST MAX...
sqlserverimpressions.blogspot.com
SireeS SQL Server Impresssions: May 2009
http://sqlserverimpressions.blogspot.com/2009_05_01_archive.html
SireeS SQL Server Impresssions. Saturday, May 30, 2009. SQL Server 2005 Pivots with Dynamic columns. Http:/ www.simple-talk.com/community/blogs/andras/archive/2007/09/14/37265.aspx. Report Development - Report Requirements Document. The purpose of report requirements document is to define the requirements for each report or group of reports. Here is a quick checklist of items to include in the report requirements documentation. Business need for the report. The selection and the filter criteria. There is...
tehremo.blogspot.com
tehremo: Internet For Beginners - from 1997 Martha Stewart Living
http://tehremo.blogspot.com/2008/12/internet-for-beginners-from-1997-martha.html
A C# NET Web Developer, just trying to make a living. Tuesday, December 30, 2008. Internet For Beginners - from 1997 Martha Stewart Living. While tossing some old magazines the other day my wife noticed an article in a 1997 Martha Stewart Living. Entitled "Internet For Beginners". Classic reading, so I had to share. I apologize for my scanning and PDF creation skills, but its readable. Enjoy. Internet For Beginners - PDF. Posted by Brandon Atkinson. Subscribe to: Post Comments (Atom). NET Web Forms FAQ.
tehremo.blogspot.com
tehremo: Layout Quirks - Disappearing Absolute Positioned Divs and Mysterious Line Breaks After Images
http://tehremo.blogspot.com/2009/08/layout-quirks-disappearing-absolute.html
A C# NET Web Developer, just trying to make a living. Monday, August 10, 2009. Layout Quirks - Disappearing Absolute Positioned Divs and Mysterious Line Breaks After Images. 2 cases in point below, which illustrate real world problems that sometimes present themselves, that have no obvious solution. 1 Disappearing Absolute Positioned DIVs. The problem ( described here. Is this: A div which is absolutely positioned may disappear if another div next to it has a float or clear on it. Get Custom Attribute Va...
tehremo.blogspot.com
tehremo: Using Javascript to check for ASP.NET page validations
http://tehremo.blogspot.com/2009/07/using-javascript-to-check-for-aspnet.html
A C# NET Web Developer, just trying to make a living. Wednesday, July 29, 2009. Using Javascript to check for ASP.NET page validations. This post could be titled, "How to simulate an UpdateProgress modal when you can't use AJAX.NET". It could also be titled, "Don't use 1&1 Web Hosting for .NET Development". I have a client who is on 1&1 and all they support is ASP.NET 2.0, with no AJAX. Its July 2009, and all they support is 2.0. Here is how to do it:. Undefined & Page Validators! Using Javascript to che...
tehremo.blogspot.com
tehremo: Get Custom Attribute Values With Javascript
http://tehremo.blogspot.com/2009/08/get-custom-attribute-values-with.html
A C# NET Web Developer, just trying to make a living. Monday, August 17, 2009. Get Custom Attribute Values With Javascript. I recently had the need to place custom attributes on individual drop down list items and then retrieve them via Javascript. There are a lot of Google posts out there that say this is not possible, which was surprising. It is possible and rather easy, if not very commonly used. Here is the code (in my case, I was sending the drop down list id as a parameter):. The Drop Down List.
tehremo.blogspot.com
tehremo: Ditch Setup Factory's Dependency Modules and use Visual Studio's prerequisites bootstrapper instead
http://tehremo.blogspot.com/2009/07/ditch-setup-factorys-dependency-modules.html
A C# NET Web Developer, just trying to make a living. Tuesday, July 14, 2009. Ditch Setup Factory's Dependency Modules and use Visual Studio's prerequisites bootstrapper instead. I really wished I could use the bootstrapper that Visual Studio produces to check for dependencies. After some testing, I found out I could. Here's how I did it:. Create a new Setup Project in Visual Studio. Set your Prerequisites as you normally would. In SUF, add both of these files to your Primer Files. CODE]Shell.Execute...
tehremo.blogspot.com
tehremo: Show "empty data" message with an ASP.NET Repeater Control
http://tehremo.blogspot.com/2010/02/show-empty-data-message-with-aspnet.html
A C# NET Web Developer, just trying to make a living. Friday, February 26, 2010. Show "empty data" message with an ASP.NET Repeater Control. I love the ASP.NET Repeater control. Its simple and very easy to use, and a great control for binding lists/arrays/etc to a page. However, sometimes you need to show a "No Data" message in the repeater, and here is a simple way to accomplish this:. Tr id="trNoData" runat="server" visible='. There is no data. Return list.Count = 0? True : false;. Consultant, MVP, and...
tehremo.blogspot.com
tehremo: Microsoft CDN for AJAX Library
http://tehremo.blogspot.com/2010/01/microsoft-cdn-for-ajax-library.html
A C# NET Web Developer, just trying to make a living. Tuesday, January 12, 2010. Microsoft CDN for AJAX Library. Just listening to the lastest Podcast on .NET Rocks, and heard about the new MS CDN service that provides caching support for AJAX libraries (including jQuery and ASP.NET AJAX). The service is available for free, does not require any registration, and can be used for both commercial and non-commercial purposes. Of course this brings up questions like:. What happens if it goes down?