Software And Architecture

This shows the number of connections per each DB: SELECT DB_NAME(dbid) as DBName, COUNT(dbid) as NumberOfConnections, loginame as LoginName FROM sys.sysprocesses WHERE dbid > 0 GROUP BY dbid, loginame And this gives the total: SELECT COUNT(dbid) as TotalConnections FROM sys.sysprocesses WHERE dbid > 0 If you need more detail, run: sp_who2 'Active'

In order to find a decimal number has fractional part in it,we can use the following check. decimal price=1.2334; if(price %1==0) // a whole number else // a fraction. A cute little piece of code that does the trick.

When using Newtonsoft. Json to serialize objects, we can avoid few properties from being included in the output for some use case and the same property be included in the serialized output in other cases. There's a feature in the Newtonsoft.Json.NET library, that lets us  determine at runtime whether or not to serialize a particular property of a class / object. During the process of creating a class, we have to include a public method named ShouldSerialize{MemberName} returning a boolean value. Json.NET will call that method during serialization to determine whether or not to serialize the corresponding property of the class. If this method returns true, the property will be serialized; otherwise, it will be ignored. The following illustration shows how this can be achieved. The following is a data definition / class that may be serialized using Newtonsoft.Json.Net public class AuthTypeClaimMapViewModel {     [JsonIgnore]     public bool?...

The following is the script to restore any database from a .bak file without using Sql Server Management Studio -- The database name in the restored bak file should be the same as the one given here RESTORE DATABASE [authserver] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.LOCAL\MSSQL\Backup\database.bak' WITH FILE = 1, MOVE N'authserver' TO N'C:\Program Files\Microsoft SQL Server\MSSQL11.LOCAL\MSSQL\DATA\database.MDF', MOVE N'authserver_LOG' TO N'C:\Program Files\Microsoft SQL Server\MSSQL11.LOCAL\MSSQL\DATA\database.LDF', NOUNLOAD, REPLACE, STATS = 10 GO

An extrovertish view of the world around On the eve of a well started thursday, the penultimate day for a long work week, as often seen as this day 27th Feb 2014, I started my journey from my office working my way round to my home which stands farther from my office by approx 497kms. I made my way to the railway station, where we begin onboarding the train's to one's natives that are distant by approx 4hrs travel. My eldritch intuition began ringing within to pull off the strings from office to break for the week a day earlier and reach home to meet my lone parents. I reserved my berth in a train that get its ends loosened from the national capital a day before the ones that typically leave to my home town from my worktown, a sluggish way to get a confirmed birth. Though seemingly easy for an outsider, I have my painful way to kick-start off my travel by hurting myself for a two-and-a-half hour journey by scrambling for a seat to get me kinda comfortable for the next two-an...

As a protraction to the world peace day, I wish to present an extemporary propaganda. How about you making a wish now, for an ally or foe or a protagnoist (call it whatever) without an outlook. When you call it a day, just spare a couple of moments to ruminate on how was the day, had you experienced something good, be it a wish from someone. Had this wish bubble be kept springy, the world will ever require a day dedicated for world peace.

Recently on encountering a issue where in the images / CSS / js and others being rendered with status as 200 (OK). But when looked in the browser, the content was not displayed. The static modules were enabled in windows features along with the MIME type mapping. Finally, when checking in the IIS Server, it was found that the Static module was missing in the handler registration. Updating that fixed the issue.

When an application is deployed in the server and if it throws the could not load library exception, we can enable the x86 support in application pool. In case any assembly was built targeting the x86 platform, this would be the right fix to make the site available. However, it is strongly advised not to target specific platform unless a firm reason be found.

I ran into a situation today wherein I was required to debug the Google Authentication middleware built on top of OWIN. I already had the code checked out from Katana project in CodePlex. However, when I tried to use, it was the latest bits [dev channel]. My app was using the version 2.1 and the dev version was in 3.0. Tired of searching the tag for the version 2.1, I came to know that the symbols for the various open source projects are made available from SymbolSource.org Given this piece of information, I read the steps on how to configure the symbol server in Visual studio and then upon successful source registration, I was able to step through the middlewares and do the debugging stuff. Things that I did were, Grab the public [authentication less uri access] from Symbol Source [ http://srv.symbolsource.org/pdb/Public] Go to Tools -> Options -> Debugger -> General. Uncheck “Enable Just My Code (Managed only)”. Uncheck “Enable .NET Framework source stepping”. ...

To   Create a new Repository in Github from the gitbash command line interface, follow the steps below, touch README.md git init git add README.md git commit -m "first commit" git remote add origin https://github.com/saravanandorai/GitURL.git git push -u origin master To   push existing code to a Repository in Github from the gitbash command line interface, follow the steps below git remote add origin https://github.com/saravanandorai/GitURL.git git push -u origin master Additional Reference: See here

May be this post is kind of well known to many. I have encountered this couple of days back, while working with a custom authorization server. Hence posted here. There are two types of digital certificate, 1. .pfx, an archive kind of certificate which contains a public key, private key and other public keys like the CA(certifying authority) public keys. 2. .cer, which contains only the public keys. Pfx certificates are meant to be only on the server, whereas the car or cert files are meant to be shared with the client's that will talk to the server. In authorization server, the server uses pfx files and the clients use the .cer or the .cert files.

In order to debug the application that is run in IIS Express in visual studio, following are the steps 1. Run the application /s in IIS express configured in visual studio 2. In the system tray or task bar near by the system clock, IIS express icon will be shown. Click on it and click on "show all application" 3. All the application hosted in IIS express will be shown along with the corresponding process ids. 4. In visual studio, go to Tools > Attach to process > in the processes, order by the process I'd and choose the correct process I'd to debug the application. 5. If the process is not listed there, pick on the "show process from all user account" check box in the bottom left corner of the window. 6. Leave a break point in the source and that's it. Hope this helps.

The following is an image that illustrates the working internals of Active Directory Federation Services [ADFS]. This image was created out of reading lengthy text contents from various web pages.

Glad that Microsoft announced that it pursues open source technology through https://msopentech.com. Lot of projects are developed here which enables to serve as a bridge between Microsoft and non-microsoft technology. Looking forward for some very interesting proceedings in msopentech.

The following steps are required to perform the Copying a Database using SQL Server objects exposed to the .Net Framework by Microsoft. Net 1. Add reference to the project with the following DLL files, Microsoft.SqlServer.ConnectionInfo.dll Microsoft.SqlServer.Smo.dll Microsoft.SqlServer.SmoExtended.dll Microsoft.SqlServer.Management.Sdk.Sfc.dll These dlls are found in the following folder C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies 2. Define a source Db and then the target DB, the source db will be scanned and then its contents [structure & data] string sourceDB = "cs_notification_test"; string targetDB = "cs_notification_test1"; SqlConnectionStringBuilder connStringBuilder = new SqlConnectionStringBuilder(System.Configuration.ConfigurationManager.ConnectionStrings["ApplicationConnectionString"].ConnectionString); ServerConnection conn = new ServerConnection(connStringBuilder.DataSource, connStringBuilder.UserID, connStr...

Though this post has crossed the exact mark of the 25th Anniversary of Web evolution. I take this opportunity to thank every one who worked for weaving this beautiful web that links us today, esp. Tim Berners Lee. Thanks for weaving this web so gregariously and I am also proud to be on a node exploring its untamed beauty.

A Short Note on SaaS [Software As A Service]. IMHO, I am building upon a short post on SAAS, this is not exhaustive, but I encourage the readers to share their valuable comments to improve this post. SaaS is an abbreviation of Software As A Service.AKA Software on Demand, where the vendors develop, host and operate on the software and make it available on the internet for its consumers / customers. SaaS is the most mature category of cloud service, since it evolved from the application-service-provider model of software hosting. With SaaS, software applications are rented from a provider as opposed to purchased for enterprise installation and deployment. SaaS is the most mature category of cloud service, since it evolved from the application-service-provider model of software hosting. With SaaS, software applications are rented from a provider as opposed to purchased for enterprise installation and deployment. Users Can range from small group to multitude SaaS Considerat...

Following steps are to be followed so that the SQL Server can be accessed across machines or be accessed from a remote machine via Sql Server Management Studio [SSMS] Enable the following 1) TCP/IP, 2) Shared Memory 3) Named Pipes from all programs> sql 2012 > configuration tools > sql server configuration manager > expand sql server network configuration > protocols for sql2012r2de Now, in the “Run” command, put Services.msc and then choose the SQL Server and then enable the SQL Server Browser service Now try connecting from any remote machine. Trackback:  http://stackoverflow.com/questions/5956926/unable-to-connect-to-a-sql-server-database-remotely

I have an employees table and an EmployeeTerritories table. The employeeid in both these tables are in integer datatype.   I have to create a new unique identifier column in both these tables and then update them accordingly. 1. I created a newsequentialid column in the employees table that will create new ids for the employees 2. Next, i added a new column to the employee territories table and set it as a foreign key to the employees table 3. now, i am in need of a query that will fetch the new guid from the employee table and fill in the employee territories table 4. i need to have a single update statement that do the trick by making use of the existing numerical id values UPDATE EmployeeTerritories SET empid = Id FROM EmployeeTerritories INNER JOIN Employees ON Employees.EmployeeID = EmployeeTerritories.EmployeeID This update statement will update the empid in the territories table based on the id matching. This saves a lot of time in comparison to the manual m...

The following code snippet can be used to run the IIS Express [8.0] in my case to be run from the command line. The parameters are the path to the main directory, the target libraries [dll's] should be in a folder  called as “bin” inside this given path for the IIS to pick up and run. The other parameter is the “port” which specifies which port should IIS Express listen for the incoming request. It also logs in the requests and the response status etc in the command line. Sample : c:\Program Files\IIS Express>iisexpress.exe /path:”C:\Users\Saravanan\Documents\Visual Studio 2012\Projects\console_app_in_iis\console_app_in_iis” /port:8089

This post illustrates the compatibility of OWIN with the existing technologies MVC5 requires ASP.NET/IIS but can co-exist with OWIN components. MVC is tightly coupled to ASP.NET, hence not standalone with respect to OWIN WebApi is fully OWIN compatible In order to find out where your app is loaded from, use “AppDomain.CurrentDomain.SetupInformation.ApplicationBase”  The stage markers apply to OwinHttpModule, not OwinHttpHandler