Sql Server express download link

Reference : Credit  http://www.hanselman.com/blog/DownloadSqlServerExpress.aspx

There's a funny blog post about how to download SQL Server Express from Long Zheng. It surprisingly how complex some companies make downloading things. I've always thought that a giant Download Now button is the best way, but perhaps that's just me?

Downloading SQL Server Express is unnecessarily hard, and it's made harder by the new Microsoft Download Center "download multiple files" interface that doesn't include descriptions or primary file recommendations. It should be a list of links, and you should be able to right click and Save As.

Introducing http://downloadsqlserverexpress.com
(this short link goes directly to this post)

So, I've done the HTTP sniffing and work, and written this blog post in the hopes that it helps you (and I'm bookmarking it for myself, for the future).

DOWNLOAD SQL SERVER 2014 EXPRESS

• You likely just want SQL Server 2014 Express with Tools. This download includes SQL Management Studio.
  • SQL Server 2014 Express x64
  • SQL Server 2014 Express x86
• Here's just SQL Server 2014 Management Studio
  • SQL Management Studio x64
  • SQL Management Studio x86
• SQL Server 2014 Express with Advanced Services
  • Advanced Services x64
  • Advanced Services x86

DOWNLOAD SQL SERVER 2012 EXPRESS

• You likely just want SQL Server 2012 Express with Tools. This download includes SQL Management Studio.
  • SQL Server 2012 Express x64
• Here's just SQL Server 2012 Management Studio
  • SQL Management Studio x64
  • SQL Management Studio x86

DOWNLOAD SQL SERVER 2008 EXPRESS R2 SP2

• You likely just want SQL Server 2008 Express with Tools. This download includes SQL Management Studio.
  • SQL Server 2008 Express x64
  • SQL Server 2008 Express x86
• Here's just SQL Server 2008 Management Studio
  • SQL Management Studio x64
  • SQL Management Studio x86

You can get back here via downloadsqlserverexpress.com. Tell your friends.

https://www.microsoft.com/en-au/download/confirmation.aspx?id=25150

Flexi urls

For personal reference

 if any one move to versatile flexi, you should use 5906 flexi only

For Pondy Office : 192.168.1.116:5906
For Chennai Office : 114.69.235.39:5906

Move back to 5904 / 5905 once you move back to client flexi, please co operate.

WCF Service Trace log

https://coab.wordpress.com/2010/03/08/quickly-finding-wcf-serializationdeserialization-issues/

Quickly finding WCF Serialization/Deserialization Issues

Posted on March 8, 2010by floatingfrisbee

Once control leaves your code, and heads into the land of WCF serialization, or before it hits your code, when it is in the land of WCF deserialization, you usually don’t have much insight into what’s going on. Yes, you can write your own handlers and step into the process but in most cases, there is no need for that. All you need is a little bit of logging and some error messages to help you catch issues.

Fortunately, Visual Studio comes with a handy little tool called SvcTraceViewer.exe that can help you quickly find issues with serialization or deserialization of your DataContracts.

You need to do the following two steps to quickly find the issue:

Step 1

Tell WCF to start logging out into a file. You can do this by adding the following diagnostic section as a child of the <configuration> tag. But be careful, it has to be after the end of the<congifSections> tag. There are a lot of options and flexibility WCF provides around this tracing, and you can read all about it here. The section below will cause WCF to log out its activity to the file c:\wcf.svclog

<system.diagnostics>
    <sources>
        <source     name="System.ServiceModel"
                    switchValue="Information, ActivityTracing"
                    propagateActivity="true">
            <listeners>
                <add    name="traceListener"
                        type="System.Diagnostics.XmlWriterTraceListener"
                        initializeData= "c:\wcf.svclog" />
            </listeners>
        </source>
    </sources>
</system.diagnostics>

Source: http://msdn.microsoft.com/en-us/library/ms733025.aspx

Step 2

Now that you have set WCF to log out all its activity into c:\wcf.svclog, all you need to do it open that file using the utility SvcTraceViewer.exe. It ships along with Visual Studio (atleast VS 2008 Professional Edition that I have), and it lives in the following folder on my machine.

C:\Program Files\Microsoft SDKs\Windows\v6.0A\bin

Once you open the trace file in SvcTraceViewer.exe, you will see the log entries (activities). Something like this:

Here you can see that a number of activities are logged and also a couple of errors are pointed out in red.

When I click on one of those error entries, this is what I see on the right side of my SvcTraceViewer window:

As you can see, all the steps for processing that particular request are listed, and the step that failed is logged out in red. When I click on the step that failed, this is what I see in the bottom pane of my SvcTraceViewer window:

As you can tell from the “Message” field under the “Exception Information” section, the error is pretty clear. While attempting to fulfill a request, WCF ran into an interface that was actually implemented by a type it did not recognize (WLogicTree). I need to tell it about the type. I can do this by adding it to the ServiceKnownTypes list.

In short, once you know how to use tools like SvcTraceViewer, and understand some of WCF rules for serialization and deserialization, it is not very painful to catch most errors.

Happy debugging!

Custom Route Handler Sample

 public class CustomRouteHandler : MvcRouteHandler
    {
        protected override IHttpHandler GetHttpHandler(RequestContext requestContext)
        {
            var acceptValue = requestContext.HttpContext.Request.Headers["Accept"];

            if (true /* do something with the accept value */)
            {
                // Set the new route value in the
                // requestContext.RouteData.Values dictionary
                // e.g. requestContext.RouteData.Values["action"] = "Customer";
                SetPermission(requestContext, requestContext.RouteData.Values["controller"].ToString(), requestContext.RouteData.Values["action"].ToString());

            }
           // return new CustomHttpHandler();
            return base.GetHttpHandler(requestContext);
        }


        private void SetPermission(RequestContext requestContext, string controller, string action)
        {

            VIPEREntities db = new VIPEREntities();
            var permission = db.sp_GetAccessPermission(controller, action, "fbe5b60f-dfff-4384-808d-d212e4791c00");
          
        }
    }


    public class CustomHttpHandler : MvcHttpHandler  // IHttpHandler
    {
        public bool IsReusable
        {
            get
            {                return false;
            }
        }

        public void ProcessRequest(HttpContext context)
        {
            context.Session["SessionPermission"] = "2";
            base.ProcessRequest(context);
            //context.Response.Redirect("http://www.itfunda.com", true);
        }
    }

To create a deployment package using Octopus

Install OctoPack nugget to the project

Add the following section in the project

 
< propertygroup >
< runoctopack >true< / runoctopack > < octopackpublishpackagetofileshare >C:\MyPackages < / octopackpublishpackagetofileshare >
< / propertygroup >
 

   

on build of solution the package will created to the destined folder.
C:\MyPackages

We can upload the package to Octopus Server and create a release to deploy it in targetted environments

Fix Issue : Microsoft.Practices.EnterpriseLibrary.Data.Database, is an abstract class and cannot be constructed.

Server Error in '/' Application.

---

The current type, Microsoft.Practices.EnterpriseLibrary.Data.Database, is an abstract class and cannot be constructed. Are you missing a type mapping?

While deploying a web application which use Microsoft enterprise library for data access. If you get the above error. 

Please make sure all the dll is in bin folder and make sure to add the following section in web.config file 

   

       

       

     

 

   

     

     

   

 

SQL_NO_CACHE MySQl no cache

The mysql workbench return the cached value of data.

To get the latest data from db use the keyword SQL_NO_CACHE
 Select SQL_NO_CACHE * from UserDetail