How to shoot milky way with Huawei P20 Pro

How to identify your SQL Server version and edition

Execute following on SQL Server Management studio.

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

source : http://support.microsoft.com/kb/321185

Shrinking the Transaction Log in SQL Server

Shrinking the Transaction Log in SQL Server 2000 / 2005 with DBCC SHRINKFILE

SQL Server 2000

1.	Run this code: DBCC SHRINKFILE(pubs_log, 2) NOTE: If the target size is not reached, proceed to the next step.
2.	Run this code if you want to truncate the transaction log and not keep a backup of the transaction log. Truncate_only invalidates your transaction log backup sequence. Take a full backup of your database after you perform backup log with truncate_only: BACKUP LOG pubs WITH TRUNCATE_ONLY -or- Run this code if you want to keep a backup of your transaction log and keep your transaction log backup sequence intact. See SQL Server Books Online topic "BACKUP" for more information: BACKUP LOG pubs TO pubslogbackup
3.	Run this code: DBCC SHRINKFILE(pubs_log,2) The transaction log has now been shrunk to the target size. Source : http://support.microsoft.com/kb/907511/en-us

SQL Server 2005

1. Back up the transaction log file to make most of the active virtual log files inactive. Therefore, the inactive virtual log files can be removed in a later step. To do this, run a Transact-SQL statement that is similar to the following Transact-SQL statement.

BACKUP LOG TO DISK = ''

Note In this statement, is a placeholder for the name of the database that you are backing up. In this statement, is a placeholder for the full path of the backup file.
For example, run the following Transact-SQL statement.

BACKUP LOG TestDB TO DISK='C:\TestDB1.bak'

2. Shrink the transaction log file. To do this, run a Transact-SQL statement that is similar to the following Transact-SQL statement.

DBCC SHRINKFILE (, ) WITH NO_INFOMSGS

Note In this statement, is a placeholder for the name of the transaction log file. In this statement, is a placeholder for the target size that you want the transaction log file to be. The target size must be reasonable. For example, you cannot shrink the transaction log file to a size that is less than 2 virtual log files.

3. If the DBCC SHRINKFILE statement does not shrink the transaction log file to the target size, run the BACKUP LOG statement that is mentioned in step 1 to make more of the virtual log files inactive.

4. Run the DBCC SHRINKFILE statement that is mentioned in step 2. After this operation, the transaction log file should be similar to the target size.

Source : http://support.microsoft.com/kb/907511/en-us

Running IIS and SQL server in same machine with diferent IP and Same Port

Introduction

In this artical I will explain how to configure IIS and SQL server 2005 in same maching diferent IP and same port.

IIS web site need to start on 

IP : 192.168.10.105  Port : 6666

SQL server need to start on

IP : 192.168.10.28 Port : 6666

Configuring Net work Connection

First we need to assign 2 ip addresses to the NIC. Go to Network connections TCP/IP properties and configure as follows.

Configuring IIS

Go to Web site properties from IIS manager and change settings as follows.

Then use HttpCfg.exe to configure IIS lisning IPs. In windows 2003 this tool can be found SUPPORT\ folder on installation CD. for more informantion click here

type floowing commands in command prompt. By default httpcfg.exe winn install on "c:\program files\Support tools\"

By default iis will listen for all ips configured to machine. using following command will delete entry for all ip listening. 

httpcfg delete iplisten -i 0.0.0.0

Then add the IP we need to listen using following command

httpcfg set iplisten -i 192.168.10.105

then restart the IIS / Web site from IIS manager.

you can user netstat (netstat -an -p tcp) command to see how the ports are listening.

Configuring SQL Server 2005

Go to Sql Server Configuration Manager. and select correct Sql server instance and double click on TCP/IP appear in right pan.

Then change the settins as follows.

After changes are done re start SQL server.

Again you can user netstat (netstat -an -p tcp) command to see how the ports are listening.

netstat will display as follows.

Model Popup (Ajax Control Toolkit) and ASP.MVC

Model popup is another usefull tool in web applications. Therefore I thought to create easy way to include Model popup in ASP.NET MVC Projects as Stephen Walther (ASP.NET MVC Tip #36 – Create a Popup Calendar Helper) did for Calender Control. 

Added Following Class ModelPopupExtensions

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53

using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Web.Mvc; namespace AjaxControlToolkitMvc { public static class ModelPopupExtensions { public static string ModelPopup(this AjaxHelper helper, string BackgroundCssClass, string CancelControlID, string DropShadow, string OkControlID, string OnOkScript, string PopupControlID, string PopupDragHandleControlID, string dynamicServicePath, string id, string elementId) { var sb = new StringBuilder(); // Add Microsoft Ajax library sb.AppendLine(helper.MicrosoftAjaxLibraryInclude()); // Add toolkit scripts sb.AppendLine(helper.ToolkitInclude ( "AjaxControlToolkit.ExtenderBase.BaseScripts.js", "AjaxControlToolkit.Common.Common.js", "AjaxControlToolkit.DynamicPopulate.DynamicPopulateBehavior.js", "AjaxControlToolkit.RoundedCorners.RoundedCornersBehavior.js", "AjaxControlToolkit.Compat.Timer.Timer.js", "AjaxControlToolkit.DropShadow.DropShadowBehavior.js", "AjaxControlToolkit.Compat.DragDrop.DragDropScripts.js", "AjaxControlToolkit.DragPanel.FloatingBehavior.js", "AjaxControlToolkit.ModalPopup.ModalPopupBehavior.js" )); // Perform $create string properties = ""; properties = string.Format(@"""BackgroundCssClass"": ""{0}"", ""CancelControlID"": ""{1}"", ""DropShadow"": {2}, ""OkControlID"": ""{3}"", ""OnOkScript"": ""{4}"", ""PopupControlID"": ""{5}"", ""PopupDragHandleControlID"": ""{6}"", ""dynamicServicePath"": ""{7}"", ""id"": ""{8}""", BackgroundCssClass, CancelControlID, DropShadow, OkControlID, OnOkScript, PopupControlID, PopupDragHandleControlID, dynamicServicePath, id); properties = "{ " + properties + " }"; sb.AppendLine(helper.Create("AjaxControlToolkit.ModalPopupBehavior", properties, elementId)); return sb.ToString(); } } }

Added New overloaded method to the AjaxExtensions class. This method takes an extra parameter for properties.

1 2 3 4 5 6 7 8 9 10

public static string Create(this AjaxHelper helper, string clientType, string properties, string elementId) { var sb = new StringBuilder(); sb.AppendLine("<script type='text/javascript'>"); sb.AppendLine("Sys.Application.add_init(function(){"); sb.AppendFormat(@"$create({0}, {1},null,null,$get('{2}'))", clientType, properties, elementId); sb.AppendLine("});"); sb.AppendLine("</script>"); return sb.ToString(); }

Microsoft ASP.NET MVC Frame Work And LINQ to Entity

I have started to learn Microsoft ASP.NET MVC framework and LINQ to entity. I thought to create working example with above. 

I am not going to explain what ASP.NET MVS is and What LINQ To Entities are, But I will explain how I have do a order form with using those two.

You can refere following urls to find out more on ASP.NET MVC and LINQ to SQL.

www.asp.net/mvc

http://weblogs.asp.net/scottgu/archive/2007/10/14/asp-net-mvc-framework.aspx

http://www.hanselman.com/blog/ScottGuMVCPresentationAndScottHaScreencastFromALTNETConference.aspx

This example will show how to create a Order form with ASP.NET MVC and Linq To Entity.

1.  Starting Fresh ASP.NET MVC Project.

1. You need to install ASP.NET MVC Framework (Beta).  http://www.asp.net/mvc
    Create a MVC Project by Selecting "ASP.NET MVC Web Application"

   

Solution Explorer will look like as follows.

The freash MVC project will have pages to login, change password etc. 

2.  Database Design

Table Name                                   Description

------------                                    -----------------------------------------

Item Item Master Table

Customer Customer Master Table

Order Order Header Table

OrderDetail Order Detail Table

Tempdata This table will use to save orders temporary until finished adding new Items. Because order can have maney Items.

3.  Creating Business Layer (dll) with LINQ to Entity

Add  a new Project (Type Class Library)  names "LM.Core". In this project will handle business layer functionalities.

Solution explorer after adding "LM.Core" Project.

In "LM.Core" there will be a Class called "Class1" (Class1.cs). Delete "Class1.cs" from "LM.Core", we can add necessory classes later as required.

No we can add ADO.NET Entity Model. Right click on "LM.Core" Add-> New Item.

Item name will be LMModel.

A wizard will begin just after click "Add" Button. Wizard steps will be as follows.

Step 1

Step 2 - Choose Data Connection

Step 3 - Select Tables

Solution Explorer after adding Entity Model to "LM.Core" Project.

LMModel.edmx will show following diagram.

We can extend the Linq to entity classes to add our own methods as follows.

Extending Item Class

Add a new class to LM.Core named Item (Item.cs). I have added twi new methods "GetItem()" and "GetByID()"

Customer, Order, OrderDetail and TempData classes need to be extended as required.

4.  Create Order Form

Order Form UI need to be created on Application project. According to ASP.NET MVC framework we need to add Controller and views for the order.

Add new Item named OrderController to the Controllers Folder located in application project.

and also add another class called BaseController to the Controller folder.

BaseController is inherited from "System.Web.Mvc.Controller"

Originally OrderController class wil inherited from "System.Web.Mvc.Controller", change it to "BaseController" (which we created).

Sorry .........., Still Updating ........................

Even though I am still updating this blog,  you can help me to improve the quality of this blog by providing your valuble comments.