Geekswithblogs.net

Truth, Equality, and the Meaning of Null

There’s been some discussion recently about whether it’s proper for a language to support null values or not. My guess is that the people having these discussions are a whole lot smarter than myself, so ...

Consume Third-Party Services at Windows Azure Store

It has been long time didn’t blog anything since last November. There are many exciting things happened during this period. I attend Microsoft TechED 2012 China and provided a session about Node.js and ...

TFS Lab Infrastructure Planning / Scaling

I’ve been working with a lot of clients over the past couple years helping them adopt TFS Lab Management. One discussion that always comes up is how to architect the infrastructure required to run TFS ...

Variations on a Repository Pattern: Part II

In my previous post I laid out my current pet project and began showing the framework I set up to isolate CSLA business objects from the data access code. I listed (sans code comments for brevity) the ...

Getting Started with MongoDB presentation (C#, MVC4)

Another NoSQL presentation, this time on MongoDB. This was my first run at it….hopefully will present again at Carolina Codecamp, Codestock, and MADExpo…Inshallah! As with each attempt, hopefully the style ...

Website Authentication with Social Identity Providers and ACS Par...

This is the second in a series of articles looking at using Windows Azure Active Directory Access Control (formally Windows Azure Access Control Service), to integrate the authentication services provided ...

Super-Fast Failover with VM Guest Clustering in Windows Server 20...

My good friend and colleague, Matt Hester, recently wrote a great article on Hyper-V Host Clustering as part of our latest article series, Become a Virtualization Expert in 20 Days! In this article, I’ll ...

APress Deal of the Day 22/Mar/2013 - .NET Test Automation Recipes

Today's $10 Deal of the day offer from APress at http://www.apress.com/97814... is .NET Test Automation Recipes"This book presents practical techniques for writing lightweight software test automation ...

SQL Server: I need to get to a remote server and management stud...

Try using osql . It can be a life saver. Here's an example of the most common usage:osql -E -S myMSSQLServerName /* This uses windows authentication to connect to a server */osql -? /* lists all the switches ...

SQL Server: Is there a query I can use that generates similar out...

Yes! This query will return very similar information to what activity monitor returns--including the text of the query the process is running (when applicable). -- Query version of Activity Monitor SELECT ...

Windows Azure IT Roadshow Lab I

This lab was created for the Windows Azure IT Roadshow in Florida (first session). It covers the basics of creating a Windows Server 2012 virtual machine, a SQL Server 2012 virtual machine and a SQL Database. ...

Accelerating the Cloud with Windows Server 2012 BranchCache

Traditional file sharing protocols, such as Server Message Block ( SMB ) in Windows Server 2012, are primarily designed for low-latency, high-bandwidth scenarios commonly found in Local Area Networks ( ...

Thanks Nokia Australia & Microsoft

Just recently I entered into a Windows Phone App Download and one of my app came in the top 10 app download to win a lovely new “Lumia 920”. These days I spend nearly all my leisure time in the Windows ...

SQL Server Agent:: I Can't Edit a Job Step because of the error ...

The immediate workaround to this problem is to open up a new SSMS session, then navigate to the SQL Agent Job you want to edit. At that point, you will be able to make the edit and save the changes.For ...

Using MSBuild to publish a VS 2012 SSDT .sqlproj database project...

Post and code updated on March 21, 2013, and again on March 22, 2013. We recently upgraded from VS (Visual Studio) 2010 to VS 2012, and with it had to upgrade our .dbproj database project to a .sqlproj. ...

Be careful setting up disc for SQL Server

Been going through different setup for SQL server setup. One problem I ran into was that I ran into this error "{FileName}.mdf is Compressed But Does not Reside in a Read-only Database or Filegroup. The ...

Tried making a striped volume out of my old hard drives

Brought in 2 perfectly working 400GB SATA drives and needed to set up a spare drive at work to keep the SQL files. Was on my merry way to create a striped volume, and bang, bang, bang, bang. Just can't ...

Shared resources and stopped services

A hypervisor is like a bank. It is offering inexistent CPU cycles and HDD I/Os up to 150% of real capacity. In normal situation VMs consumes about 20% of declared (maximum) RAM, CPU and disk IO, and business ...

SQL Server 2012: How do I set "Edit top" rows to a different numb...

right click the results or your "Edit Top 999 Rows" query in SSMS. There's an option called: "Pane -> SQL" If you look at it, this show you the sql--you can edit that and narrow down the rows you are ...

SQL Server–Find Nth Largest/smallest entry in a table

We could find the maximum and minimum value in a table by using the SQL inbuilt aggregate functions MAX() and MIN() respectively. But, many times there comes a scenario when we need to find the second ...

Solving Performance Problems with nHibernate (or any ORM)

I’ve spent a bunch of time lately with clients helping them understand why their applications are so slow and how to improve performance. This often comes down to their use (or misuse) of ORM frameworks ...

Streetlight Store–Part IV: Relational Entities and Product ...

In Part III, we started creating a very basic MVC application to host our store. We also created a simple table to store products and methods to perform CRUD transactions and validate data. Now we we introduce ...

List of Software on TFS Service Hosted Build

A couple of weeks back I had posted a blog post on getting a list of software installed on the build agent by simply customizing the build process template. Building on top of the same solution, I have ...

Streetlight Store - Part III: Implementation in an MVC 4 Applicat...

To keep things simple, I am going to retain the default security framework created by Visual Studio when I created the application. However, I am going to change the database name to something more meaningful. ...

Streetlight Store - Part II: Black Boxing Products and Improved A...

In Part I, I introduced the concept of the Streetlight Store and the architecture. In this segment, we will walk through the creation of a data contract for products, interfaces for managing transactions, ...

Reseed Identity column in SQL Server

Use the below SQL command to reset the seed on the identity column -DBCC CHECKIDENT('TABLE_NAME', RESEED, 'RESEED_VALUE')The following example forces the current identity value in the AddressTypeID column ...

SQL Server - get last executed SQL statement

We all know the usage of sp_who2 command in SQL server, its life-saver when you need to know what's causing your query take longer time to execute or in other words who's blocking you r query.But, SQL ...

SQL server - get list of active connections to each database

Many times, we want list of all users who are connected to the SQL server - to determine it use the below query. It returns the Database, Number of open connections and logged-in user credentials.SELECT ...

Tuning Sql Server 2012 & SharePoint 2013 (MVA)

SharePoint stores most of its data in SQL Server, optimizing the overall SharePoint user experience has focus on how these products are integrated. During this Jump Start, two of the industry’s most popular ...

GridView–Implementing Cascading DropDownList on Edit Mode

Introduction: This question has been asked many times at the forums (http://forums.asp.net) and definitely there are already bunch of different solutions provided. Most of the examples from the web are ...

Exporting XML Comments to Your Application

Recently I blogged about adding SQL Doc Documentation to you Application. This makes it easy to keep your documentation visible and more likely current. I wanted to do the same thing with my code documentation. ...

SQL Server Management Studio crashed - recover unsaved sql query

If for some reasons SQL server instance dies or it crashes and if you had an unsaved query - you could still recover it from the backup files that sql server creates whenever it crashes unexpectedly.The ...

Check Out the New Windows Azure Hub on Channel 9

Several weeks ago we launched a new hub for Windows Azure on Channel 9. This hub will serve as an index and entry point for all video content related to Windows Azure. Since the launch we have already ...

Adding SQL Doc Documentation to your Project

In a recent blog post, we talked about using SQL Doc to stream line documenting your database. This tool makes it a lot easier to put the documentation close to the source so that it is more likely to ...

DMV to figure out unused and missing Indexes on table in SQL serv...

MS SQL Server 2005 onwards provides quite a lot of views and functions which can be used to keep a tab on the database engine and also gives you statistics which helps you in making informed decision about ...

SET DATEFORMAT in SQL

Some times, you may want the database to interpret the date value as per the format you have provided rather than using the default database level format (which is mostly set to mdy as default US date ...

Microsoft SQL Server Webcast Series

Highly recommended top shelf free to attend presentation material: Microsoft SQL Server webcast series ...

Problems getting Lightswitch HTML Client Preview 2

I finally downloaded the html client preview 2 to give it a run, had not had a chance to look at Lightswitch since last summer… http://blogs.msdn.com/b/lig... ...

SQL Server Identity Quirks

If you’ve worked with SQL Server for any length of time odds are that you’ve used the IDENTITY property to create a surrogate key for a table. These auto-incrementing primary keys can be very handy, but ...

Sample Pricing Comparison: On-Premise vs. Private Hosting vs. Clo...

Last week I blogged about some of the basic pricing differences between Amazon AWS and Microsoft’s Windows Azure (http://wblo.gs/da7) and concluded that while there was a price difference, it was important ...

MCSD - Web Applications (.NET 4.5)

IT Professionals working in Web Applications Dot Net can gain their MCSD: Web Applications certification by following this post. I passed these 3 exams in Feb 2013.I) Exam 70-480: Programming in HTML5 ...

What is Database Cardinality

I have found very nice definition of Cardinality and its types.DefinitionIn SQL (Structured Query Language), the term cardinality refers to the uniqueness of data values contained in a particular column ...

Sample Pricing Comparison: Amazon AWS and Windows Azure

As my journey to the cloud continues, many people have asked me whether or not Amazon AWS was more expensive than Windows Azure. As you can imagine comparing pricing alone can be very deceiving because ...

Azure Roadshow for IT Pros in Florida

Hi – this is HUGE!!! Microsoft (Blain Barton) is planning a roadshow in Florida starting in March 2013 until June 2013. We will visit many cities (twice), so if you haven’t signed up yet, now is the time! ...

Upgrading to Visual Studio 2012 Update 2 CTP3

Last week I upgraded my TFS 2012 test environment to CTP3 to try out the new features rolled out in preview as part of the Visual Studio 2012 Upgrade 2 CTP. In this blog post, I’ll walk you through the ...

How to backup the TFS 2012 databases

Team Foundation Server Backups - You need to install the ‘Visual Studio Team Foundation Server 2012 Update xx Power Tool’ on the application-tier for Team Foundation Server. The tool can schedule backups ...

tfs backup console - adminpthelper.exe has stopped working

I got this message from the 2012 version of the console after installing the Power Tools found here:http://visualstudiogal... problem was that ...

MCSA: Sql Server 2012 Certification

IT Professionals working in Sql Server can gain their MCSA: SQL Server 2012 certification by following this post. I passed these 3 exams in August 2012.I) Exam 70-461: Querying Microsoft SQL Server 2012II) ...

Do You Use SQL Doc from Red Gate?

Do you have a database? Then you should be using SQL Doc! http://www.red-gate.com/pro... SQL Doc scans the data dictionary and associated metadata to produce the documentation ...