Truth, Equality, and the Meaning of Null Joe Mayo, January 1, 0001 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 ... Truth, Equality, and the Meaning of Null 0 0 0
Consume Third-Party Services at Windows Azure Store Shaun, January 1, 0001 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 ... Consume Third-Party Services at Windows Azure Store 0 0 22
TFS Lab Infrastructure Planning / Scaling Dylan Smith, January 1, 0001 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 ... TFS Lab Infrastructure Planning / Scaling 0 0 1
Variations on a Repository Pattern: Part II Justin Jones, January 1, 0001 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 ... Variations on a Repository Pattern: Part II 0 0 6
Getting Started with MongoDB presentation (C#, MVC4) David Green, January 1, 0001 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 ... Getting Started with MongoDB presentation (C#, MVC4) 0 0 5
Website Authentication with Social Identity Providers and ACS Par... Alan Smith, January 1, 0001 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 ... Website Authentication with Social Identity Providers and ACS Par... 0 0 1
Super-Fast Failover with VM Guest Clustering in Windows Server 20... KeithMayer, January 1, 0001 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 ... Super-Fast Failover with VM Guest Clustering in Windows Server 20... 0 0 2
APress Deal of the Day 22/Mar/2013 - .NET Test Automation Recipes TATWORTH, January 1, 0001 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 ... APress Deal of the Day 22/Mar/2013 - .NET Test Automation Recipes 0 0 0
SQL Server: I need to get to a remote server and management stud... Paula DiTallo, January 1, 0001 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: I need to get to a remote server and management stud... 0 0 0
SQL Server: Is there a query I can use that generates similar out... Paula DiTallo, January 1, 0001 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 ... SQL Server: Is there a query I can use that generates similar out... 0 0 4
Windows Azure IT Roadshow Lab I Herve Roggero, January 1, 0001 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. ... Windows Azure IT Roadshow Lab I 0 0 0
Accelerating the Cloud with Windows Server 2012 BranchCache KeithMayer, January 1, 0001 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 ( ... Accelerating the Cloud with Windows Server 2012 BranchCache 0 0 0
Thanks Nokia Australia & Microsoft Max, January 1, 0001 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 ... Thanks Nokia Australia & Microsoft 0 0 0
SQL Server Agent:: I Can't Edit a Job Step because of the error ... Paula DiTallo, January 1, 0001 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 ... SQL Server Agent:: I Can't Edit a Job Step because of the error ... 0 0 0
Using MSBuild to publish a VS 2012 SSDT .sqlproj database project... deadlydog, January 1, 0001 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. ... Using MSBuild to publish a VS 2012 SSDT .sqlproj database project... 0 0 0
Be careful setting up disc for SQL Server Kevin Shyr, January 1, 0001 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 ... Be careful setting up disc for SQL Server 0 0 0
Tried making a striped volume out of my old hard drives Kevin Shyr, January 1, 0001 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 ... Tried making a striped volume out of my old hard drives 0 0 0
Shared resources and stopped services Waclaw Chrabaszcz, January 1, 0001 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 ... Shared resources and stopped services 0 0 0
SQL Server 2012: How do I set "Edit top" rows to a different numb... Paula DiTallo, January 1, 0001 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 2012: How do I set "Edit top" rows to a different numb... 0 0 0
SQL Server–Find Nth Largest/smallest entry in a table Vipin, January 1, 0001 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 ... SQL Server–Find Nth Largest/smallest entry in a table 0 0 2
Notes Upgrading To Visual Studio 2012 Update 2 Ctp4 Tarun Arora [Microsoft MVP], January 1, 0001 Notes Upgrading To Visual Studio 2012 Update 2 Ctp4 0 0 0
Solving Performance Problems with nHibernate (or any ORM) Dylan Smith, January 1, 0001 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 ... Solving Performance Problems with nHibernate (or any ORM) 0 0 8
Streetlight Store–Part IV: Relational Entities and Product ... Doug Lampe, January 1, 0001 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 ... Streetlight Store–Part IV: Relational Entities and Product ... 0 0 0
List of Software on TFS Service Hosted Build Tarun Arora [Microsoft MVP], January 1, 0001 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 ... List of Software on TFS Service Hosted Build 0 0 0
Streetlight Store - Part III: Implementation in an MVC 4 Applicat... Doug Lampe, January 1, 0001 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 III: Implementation in an MVC 4 Applicat... 0 0 4
Streetlight Store - Part II: Black Boxing Products and Improved A... Doug Lampe, January 1, 0001 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, ... Streetlight Store - Part II: Black Boxing Products and Improved A... 0 0 3
Reseed Identity column in SQL Server Vipin, January 1, 0001 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 ... Reseed Identity column in SQL Server 0 0 3
SQL Server - get last executed SQL statement Vipin, January 1, 0001 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 last executed SQL statement 0 0 8
SQL server - get list of active connections to each database Vipin, January 1, 0001 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 ... SQL server - get list of active connections to each database 0 0 5
Tuning Sql Server 2012 & SharePoint 2013 (MVA) deepakpuri, January 1, 0001 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 ... Tuning Sql Server 2012 & SharePoint 2013 (MVA) 0 0 0
GridView–Implementing Cascading DropDownList on Edit Mode Vincent Maverick Durano, January 1, 0001 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 ... GridView–Implementing Cascading DropDownList on Edit Mode 0 0 0
Exporting XML Comments to Your Application Nick Harrison, January 1, 0001 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. ... Exporting XML Comments to Your Application 0 0 0
SQL Server Management Studio crashed - recover unsaved sql query Vipin, January 1, 0001 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 ... SQL Server Management Studio crashed - recover unsaved sql query 0 0 7
Check Out the New Windows Azure Hub on Channel 9 Clint Edmonson, January 1, 0001 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 ... Check Out the New Windows Azure Hub on Channel 9 0 0 1
Adding SQL Doc Documentation to your Project Nick Harrison, January 1, 0001 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 ... Adding SQL Doc Documentation to your Project 0 0 0
DMV to figure out unused and missing Indexes on table in SQL serv... Vipin, January 1, 0001 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 ... DMV to figure out unused and missing Indexes on table in SQL serv... 0 0 0
SET DATEFORMAT in SQL Vipin, January 1, 0001 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 ... SET DATEFORMAT in SQL 0 0 0
Microsoft SQL Server Webcast Series Compudicted, January 1, 0001 Highly recommended top shelf free to attend presentation material: Microsoft SQL Server webcast series ... Microsoft SQL Server Webcast Series 0 0 0
Problems getting Lightswitch HTML Client Preview 2 Dave Noderer, January 1, 0001 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... ... Problems getting Lightswitch HTML Client Preview 2 0 0 1
SQL Server Identity Quirks Jesse Taber, January 1, 0001 This blog post has moved:http://gruffcode.com/... ... SQL Server Identity Quirks 0 0 0
Sample Pricing Comparison: On-Premise vs. Private Hosting vs. Clo... Herve Roggero, January 1, 0001 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 ... Sample Pricing Comparison: On-Premise vs. Private Hosting vs. Clo... 0 0 0
MCSD - Web Applications (.NET 4.5) deepakpuri, January 1, 0001 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 ... MCSD - Web Applications (.NET 4.5) 0 0 4
What is Database Cardinality Saqib Ullah, January 1, 0001 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 ... What is Database Cardinality 0 0 5
Sample Pricing Comparison: Amazon AWS and Windows Azure Herve Roggero, January 1, 0001 EDIT: A blog post has been published, with updated pricing information as of August 2015. Click here to access this blog post. As my journey to the cloud continues, many people have asked me whether or ... Sample Pricing Comparison: Amazon AWS and Windows Azure 0 0 4
Azure Roadshow for IT Pros in Florida Herve Roggero, January 1, 0001 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! ... Azure Roadshow for IT Pros in Florida 0 0 0
Upgrading to Visual Studio 2012 Update 2 CTP3 Tarun Arora [Microsoft MVP], January 1, 0001 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 ... Upgrading to Visual Studio 2012 Update 2 CTP3 0 0 0
How to backup the TFS 2012 databases Tarun Arora [Microsoft MVP], January 1, 0001 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 ... How to backup the TFS 2012 databases 0 0 0
tfs backup console - adminpthelper.exe has stopped working Alex Bransky, January 1, 0001 I got this message from the 2012 version of the console after installing the Power Tools found here:http://visualstudiogal... problem was that ... tfs backup console - adminpthelper.exe has stopped working 0 0 0
MCSA: Sql Server 2012 Certification deepakpuri, January 1, 0001 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) ... MCSA: Sql Server 2012 Certification 0 0 0
Do You Use SQL Doc from Red Gate? Nick Harrison, January 1, 0001 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 ... Do You Use SQL Doc from Red Gate? 0 0 0