Browse by Tags

Tagged Content List
  • Wiki Page: T-SQL Script Detach, Move, and Attach Database

    One of my tasks recently involved moving the physical files from a set of MSSQL databases from one partition to another. These databases were part of a Sharepoint Farm. There were a number of databases so I created the following script in order to detach, move and re-attach the databases. This...
  • Wiki Page: How to Create Query Shortcuts in SQL Server Management Studio

    You can create shortcuts for frequently used queries in Management Studio, some of the shortcuts are predefined, like pressing "Ctrl + 1" will execute "sp_who". You can create shortcuts for your own queries or change the existing shortcuts. To create a new shortcut, go...
  • Wiki Page: Rebuild and Re-index Database Gradually

    I had a problem in our live environment - the database was fragmented - badly. A solution had to be written to defragment the database, whilst providing the least downtime - and the script below was born. I create a function that will defrag the top X (in this case 20) indexes and created a SQL...
  • Wiki Page: SSRS (Matrix): How to Repeat Headers on Each Page and Keep Headers Fixed while Scrolling

    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...
  • Wiki Page: SSRS: Multi-valued Parameter as Stored Procedure Input

    Few months back I wrote an article on Multi-valued Parameter as Stored procedure Input, which will work only for single character multi-valued input parameter . Now let us see an example for SSRS report with Multi-valued Parameter as Stored procedure Input, which will work in all cases. ...
  • Wiki Page: Operations Manager Management Pack Authoring - Monitoring Scripts

    This document is part of the Operations Manager Management Pack Authoring Guide . The Microsoft System Center team has validated this procedure as of the original version . We will continue to review any changes and periodically provide validations on later revisions as they are made. Please feel...
  • Wiki Page: Crop Image

    Description: This code try to demonstrate how to return a crop image, from a original one, passed as parameter. Code: using System.Drawing; public Image ManualCrop(Image image, int cropMargin) { Rectangle cropRect = new Rectangle(cropMargin, cropMargin, image.Width - cropMargin...
  • Wiki Page: Resize Image

    Description: This post try to explain how to resize an Image, that is passed as parameter. Code: using System.Drawing.Imaging private static Image resizeImage(Image imgToResize, Size size) { int sourceWidth = imgToResize.Width; int sourceHeight = imgToResize.Height; float...
  • Wiki Page: Convert Image to Black & White

    Description: This post explain how to converts an image to black and white 1bpp indexed format Code: System.Drawing.Drawing2D private static Bitmap ConvertToBW(Bitmap src, int luminanceCutOff) { int width, height; Bitmap dest; Rectangle rect; BitmapData data; IntPtr...
  • Wiki Page: Mahout on Windows Azure - Machine Learning Using Microsoft HDInsight

    Introduction One of the Microsoft HDInsight key components is Mahout, a scalable machine learning library that provides a number of algorithms relying on the Hadoop platform. Machine learning supports a wide range of use cases from email spam filtering to fraud detection to recommending books...
  • Wiki Page: Windows Server 2008 R2 Failover Cluster PowerShell Command Reference

    CommandLet Add-ClusterDisk Description Make a new disk available for use in a failover cluster. The disk (LUN) must be exposed to all nodes in the failover cluster, and should not be exposed to any other servers. Example 1: C:\PS>Get-ClusterAvailableDisk | Add-ClusterDisk ...
  • Wiki Page: Adding more comment lines to POP Purchase Orders

    Just recently, I was asked by a customer to address an issue with their line item comments truncating at 4 lines. In essence, the customer wanted the ability to print more than 4 lines of comments at the line item level on their purchase orders. My customer happens to be in the Nuclear Waste Management...
  • Wiki Page: Message Dialog in Metro Style App

    After the release of Windows 8 i.e. 26th October developers have gone crazy about developing Metro style applications. I have been developing for Windows previously also and MessageBox was the most used control, but in Metro style apps I didn't find it, so this is simply an article to guide you...
  • Wiki Page: Add a Settings Panel in Charm Bar in Windows 8 - Privacy Policy

    This article is also published in http://www.c-sharpcorner.com/UploadFile/shubham0987/add-a-settings-panel-in-charm-bar-in-windows-8-privacy-pol/ The Charm Bar is a brand new feature of Windows and is seen for the first time, it can be referred to as a universal toolbar and thus you can access...
  • Wiki Page: Ubicación API en Windows Phone 8 (es-ES)

    Tabla de Contenidos Resumen Introducción Tecnologías de localización proveedor A la ubicación actual en Windows Phone 7.5 Capacidades Geolocalizador en Windows Phone 8 Seguimiento de la ubicación de fondo Resumen Este artículo presenta las características de ubicación de...
  • Wiki Page: Coded UI Testing Extensibility Points. Writing to Text Files, Visual Studio & the Event Log.

    Synopsis: Writing textual information throughout the progression of an automated test library off to a file, perhaps with the variables that were being used or timestamp information etc. is of use and demanded by most testing type people at one time or another. Here’s how you do a lot of it. ...
  • Wiki Page: Hyper-V: Script to Check IC Version

    Table of Contents Script Not Detected Community Resources Here is a script for checking the version number of your VM integration components created by Microsoft software developer Stefan Wernli. Script # Test if the IC version is up to date param( [string]$vmName = $(throw "Must...
  • Wiki Page: Hyper-V: How to Find the Host of a VM

    There are several ways you can determine the virtualization host (server with the Hyper-V role enabled), also called the physical host, that a VM is running on. If the host OS is Windows Server 2008 R2, and the virtual machines on it are using the R2 integrations services, then you can query the following...
  • Wiki Page: Fixing Missing Data Based on Prior Row Information

    One of the commonly asked problems in the Transact-SQL forum is how to provide missing information based on the information in the first prior row that has data (or alternatively in the next row (by date)). One of the examples where this problem was discussed is this thread . In this thread...
  • Wiki Page: Custom Styling the Alternate Rows inside ListView/GridView

    To style the items inside ListView/GridView based on item index we will use StyleSelector to define custom styling for each item. To implement this, we will define the class derived from StyleSelector as shown below. Inside this class we are just returning the style which will apply...
  • Wiki Page: Generate a Report for installed Hotfix for Bulk Servers using PowerShell

    Function Get -ComInfo { param( ## Computers $computers ) "#" *80 "Server HotFix Report" "Generated $(get-date)" "Generated from $(gc env:computername)" "#" *80 Get -HotFix -ComputerName $computers } ...
  • Wiki Page: SharePoint 2010: Freeze Header Row of SharePoint List View

    When a SharePoint list contains lots of data then it becomes hard to understand the data when you scroll down and header row is not visible , every time you have to scroll up to see what data in this particular cell is, you tend to check the column in the header. It will be easy to understand the data...
  • Wiki Page: SharePoint 2010: Fixer l'entête de la première ligne d'une vue de liste SharePoint (fr-FR)

    Note : Cet article est une traduction de l'article SharePoint 2010: Freeze Header Row of SharePoint List View . Lorsqu'une liste SharePoint contient beaucoup de données il devient alors difficile de traiter les données lorsque vous défilez vers le bas, la ligne d'entête n'étant...
  • Wiki Page: Unit Testing of Singleton Objects

    Overview Over the years, there has been a bustling debate among software developers on the use of the singleton pattern. Some would say it is better in the sense that it has complete control of the object instantiation and ensures that there is one and only one instance of the class, but others...
  • Wiki Page: BizTalk Developer Interview Questions and Answers - Helper Class

    Table of Contents Introduction Questions and Answers Author Contributors See Also Introduction This article intends to cover the answers to the developer related questions on Helper classes with BizTalk, which a BizTalk developer can face during an interview. Questions and Answers What...
Page 5 of 45 (1,105 items) «34567»
Can't find it? Write it!