ilovedata.ca
Martina Ponca's Blog
http://ilovedata.ca/page/2
Martina Ponca's Blog. Notes on database design, business intelligence, ETL, and enterprise reporting using Microsoft SQL Server. Transformation: Dates and Strings. April 30, 2010, 11:15 pm. Create Date declare @year int, @month int, @day int select @year = 2009, @month= 3, @day = 3; select dateadd(mm,(@year-1900)* 12 @month - 1,0) (@day -1) [Date]. Transformation: Create Dynamic Date Table (First Day of Month, Last Day of Month). April 30, 2010, 11:03 pm. Transformation: Rollup Rows or List to String.
dotnet-tips.com
Tips & Tricks: PORTQRY COMMAND TO TEST THE PORT LISTENING
http://www.dotnet-tips.com/2012/07/portqry-command-to-test-port-listening.html
ASPNET,VB.NET, C#, AJAX, SQL SERVER, SSIS Tips and Tricks. Tuesday, July 31, 2012. PORTQRY COMMAND TO TEST THE PORT LISTENING. P tcp -e 25. Http:/ support.microsoft.com/kb/832919. Subscribe to: Post Comments (Atom). Tools And Techniques to Identify Concurrency Issues. Cancel a web service call. Cancel web service call Sample. Http:/ ssisctc.codeplex.com/. List all the pending checked out team foundation. Tips about migrating from VS2005 to VS2008. Tools And Techniques to Identify Concurrency Issues.
dotnet-tips.com
Tips & Tricks: Tips to diagnose and Debug IIS web application crash issue with DebugDiag and Windbg
http://www.dotnet-tips.com/2014/03/tips-to-diagnose-and-debug-iis-web.html
ASPNET,VB.NET, C#, AJAX, SQL SERVER, SSIS Tips and Tricks. Friday, March 07, 2014. Tips to diagnose and Debug IIS web application crash issue with DebugDiag and Windbg. Evidence: In the window event log, there is warning message “A process serving application pool 'WebPortal' suffered a fatal communication error with the Windows Process Activation Service. The process id was '3000'. The data field contains the error number.”. Configuration Changes in IIS application pool. Select "Crash" and click Next.
dotnet-tips.com
Tips & Tricks: 08/01/2011 - 09/01/2011
http://www.dotnet-tips.com/2011_08_01_archive.html
ASPNET,VB.NET, C#, AJAX, SQL SERVER, SSIS Tips and Tricks. Friday, August 19, 2011. How to Install Webmin on Ubuntu 11.04. Recently I launched my own server and its the first time I have ever done this. Im running a Red Hat Linux server and I wanted to install Webmin, but I didnt really know how. Thus, I thought we would run through an installation guide of Wedmin, but this time on Ubuntu and the new Ubuntu 11.04. Edit /etc/apt/sources.list file. Sudo vi /etc/apt/sources.list. Add the following lines.
dotnet-tips.com
Tips & Tricks: 03/01/2014 - 04/01/2014
http://www.dotnet-tips.com/2014_03_01_archive.html
ASPNET,VB.NET, C#, AJAX, SQL SERVER, SSIS Tips and Tricks. Friday, March 07, 2014. Tips to diagnose and Debug IIS web application crash issue with DebugDiag and Windbg. Evidence: In the window event log, there is warning message “A process serving application pool 'WebPortal' suffered a fatal communication error with the Windows Process Activation Service. The process id was '3000'. The data field contains the error number.”. Configuration Changes in IIS application pool. Select "Crash" and click Next.
dotnet-tips.com
Tips & Tricks: 04/01/2011 - 05/01/2011
http://www.dotnet-tips.com/2011_04_01_archive.html
ASPNET,VB.NET, C#, AJAX, SQL SERVER, SSIS Tips and Tricks. Saturday, April 30, 2011. Ltdiv class="left-panel"><img src="myleftimage" /></div>. Ltdiv class="center-panel">Content goes here.</div>. Ltdiv class="right-panel"><img src="myrightimage" /></div>. Container .left-panel {. Container .right-panel {. Container .center-panel {. Thursday, April 21, 2011. Use a WCF Service with HTTP and HTTPS in C#. 160; . 160; serviceHostingEnvironment. 160; behaviors. Tools And Techniqu...
dotnet-tips.com
Tips & Tricks: 03/01/2012 - 04/01/2012
http://www.dotnet-tips.com/2012_03_01_archive.html
ASPNET,VB.NET, C#, AJAX, SQL SERVER, SSIS Tips and Tricks. Thursday, March 01, 2012. How to identify the sql server edition. The result will look something like:. 64-bit: Developer Edition (64-bit). Labels: ASP.NET and SQL SERVER. Subscribe to: Posts (Atom). Tools And Techniques to Identify Concurrency Issues. Cancel a web service call. Cancel web service call Sample. Http:/ ssisctc.codeplex.com/. List all the pending checked out team foundation. Tips about migrating from VS2005 to VS2008.
dotnet-tips.com
Tips & Tricks: SMTP Connectivity TEST
http://www.dotnet-tips.com/2012/07/smtp-connectivity-test.html
ASPNET,VB.NET, C#, AJAX, SQL SERVER, SSIS Tips and Tricks. Tuesday, July 31, 2012. Telnet your.server.com 25. Escape character is ' ]'. 220 your.server.com ESMTP. Mail from: user@yourdomain.com. Rcpt to: someone@aol.com. Here is a test message body text. Subscribe to: Post Comments (Atom). Tools And Techniques to Identify Concurrency Issues. Cancel a web service call. Cancel web service call Sample. Http:/ ssisctc.codeplex.com/. List all the pending checked out team foundation. Web Service Proxy Invoke.
dotnet-tips.com
Tips & Tricks: Specified argument was out of the range of valid values
http://www.dotnet-tips.com/2012/09/specified-argument-was-out-of-range-of.html
ASPNET,VB.NET, C#, AJAX, SQL SERVER, SSIS Tips and Tricks. Monday, September 10, 2012. Specified argument was out of the range of valid values. System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values. Parameter name: utcDate at System.Web.HttpCachePolicy.UtcSetLastModified(DateTime utcDate) at System.Web.HttpCachePolicy.SetLastModified(DateTime date) at Telerik.Web.UI.CombinedScriptWriter.WriteCombinedScriptFile() at Tele...Copy /b %i ,. Cancel a web service call.