Browse by Tags

Table of Contents Introduction Taking Flight Code Sample Introduction Test Driven Development (TDD) is highly recommended approach to software development. In TDD, we first write unit tests, generate skeleton code so that the solution builds. Obviously all tests will fail initially since we have...

Table of Contents Introduction How to Enter Categories Microsoft Azure BizTalk Forefront Identity Manager SharePoint 2010 / 2013 Small Basic SQL BI & Power BI SQL Server General & Database Engine System Center Transact-SQL Universal Windows Apps Visual Basic Visual C# Windows PowerShell Windows...

Table of Contents Introduction How to Enter Categories Microsoft Azure BizTalk Forefront Identity Manager SharePoint 2010 / 2013 Small Basic SQL BI & Power BI SQL Server General & Database Engine System Center Transact-SQL Universal Windows Apps Visual Basic Visual C# Windows PowerShell Windows...

Table of Contents Introduction Case Overview Solution requirement Solution design Code logic Code Introduction The FIM Windows Azure Active Directory (WAAD) connector uses the SourceAnchor field as the identifier of the Azure object. The SourceAnchor field is derived in WAAD via attribute flow...

Introduction This article aims to make available images for use in promotions and disclosures in the awards, blogs and TechNet Wiki articles. Downloads Download Image Pack – TechNet Gallery Images – Awards - Logo TechNet Guru Award - Logo TechNet Wiki Contributors...

Table of Contents Introduction Node.js Fabricated Scenario Basic API Extending the Basic API See Also Introduction This Wiki Article explores some of the capabilities of Azure Mobile Services API that might be of interest in some scenarios. Note: this article assumes some familiarity with Azure...

Table of Contents Introduction How to Enter Categories Microsoft Azure BizTalk Forefront Identity Manager SharePoint 2010 / 2013 Small Basic SQL BI & Power BI SQL Server General & Database Engine System Center Transact-SQL Universal Windows Apps Visual Basic Visual C# Windows PowerShell Windows...

Windows phone has various media related classes which have proven to be very confusing for new developers. This article will try to shed some light on the matter and hopefully answer most questions beginners might have. But before that, we need to define some terminology. The media library is defined...

In this post I have consolidated few of the methods to remove leading and trailing zeros in a string . Here is an example : DECLARE @BankAccount TABLE (AccNo VARCHAR (15)) INSERT @BankAccount SELECT '01010' INSERT @BankAccount SELECT '0010200' ...

This article is the outcome of my answer to this question in the SSRS forum. Consider this sample data DECLARE @sample_data table ( [ Year ] varchar (5), Emp_id varchar (30), Name varchar (30), Accomplishments varchar (30) ) insert @sample_data...

This article is an outcome of my answer to this question on MSDN SSRS forum . Previously I wrote similar article on SSRS: How to Repeat Headers on Each Page and keep headers fixed while scrolling for a table. In this article , let us see an example on how to repeat headers on each page and keep headers...

The need often arises to create or recreate the indexes for all tables in a database, especially in development and testing scenarios. This article presents a script to generate Index Creation Scripts for all tables in a database using Transact-SQL (T-SQL). The code block below will generate Index...

When data is imported from Excel to SQL Server table using SSIS and if the destination table has column of data type VARCHAR, we will end up with error "Cannot convert between unicode and non-unicode string data types" . As far as my knowledge, I know there are two solutions: i)...

This article shares the information on how to compare two versions of the same report . Sometimes we might be in a need to compare the changes in two versions of the same report. We can observe the changes easily on the report if it is a color modification or something like this, What if...

Introduction One of the important factors to be considered and taken care in SSRS report designing is Ordered display of report: Order of rows in tables Order of columns in matrices Order of labels in X-axis of charts Order of series groups in stacked charts In this article, let us see examples...

This article is about the impact of renaming a column of a table . Table of Contents Introduction Scripts to Identify all Referenced Objects affected by Column Rename Ways of Renaming a Column of a Table Error Number - 207 Scripts to Identify Referenced Objects that are affected by Column Rename...

Table of Contents Introduction File Checkout: File Check In CopyTo MoveTo Publish File Delete File Get File Path Get document Author Name Get document Modified By Name Introduction This article demonstrates how to use various methods/properties associated with SPFile object using client object...

Table of Contents Introduction Performing the test Conclusion about re-created/rebuild Understanding Recovery Model in Tempdb Performing test to understand Recovery model Conclusion about Recovery Model Owner of Tempdb Summary Suggested Readings See Also Credits ↑ Back to top Introduction...

This article explains fonts for the GraphicsWindow object in Microsoft Small Basic. Table of Contents What is a Font? What is a Glyph? Font Properties FontBold FontItalic FontName FontSize Recommended Fonts Sample Programs Recommended Fonts 0.3 Fonts Sample 0.1 See Also Other Resources Other Languages...

This page is carefully and closely monitored. Any changes you make will be evaluated and then quickly accepted, refined, or reverted. NOTE: Small Basic 1.1 was replaced with a newer version. To download the latest version, please see Download Microsoft Small Basic . Table of Contents...

This article lists all Small Basic articles that participated in the TechNet Guru Contributions Small Basic category. Table of Contents 2015 August 2015 May 2015 April 2015 March 2015 February 2015 January 2015 2014 December 2014 November 2014 October 2014 September 2014 August 2014 July 2014 June...

Table of Contents Scope Factorization Prime numbers Fundamental Theorem of Arithmetic Check for primality Wrap it up Requesting input Calculate primality Spotting factors Showing results Source code PNF on SmallBasic.com Bibliography See Also Scope In this brief article, we'll consider a...

Table of Contents Introduction SQL Connectivity - Single Point of Failure Strategy Procedure Introduction Get notified when System Center Operations is down! System Center Operations Manager can’t monitor itself. When (not if) it goes off-line it cannot generate an Alert notifying you it...

Table of Contents Introduction What is Denormalisation? Default Value Adding Logic Performance Minimising Joins Avoiding Correlated Subqueries Pre Aggregation Reducing Skill Threshold Data Redundancy vs. Denormalisation Data Warehouse/Mart Caching Business Server Cache Local Cache Many courses cover...

Table of Contents Introduction SAP Crystal Reports Microsoft Reports MS Access Transforms - XSLT / XSL Jquery T4 Template Word Mail merge Open Source ReportingCloud My-FyiReporting Paid Third Party Telerik Reporting DevExpress Universal Reporting DevExpress Snap Windward Autotag Banded Reports ...