Server

Project Server 2013 - Queue job - Waiting to be processed

18 Feb 2016 by Mandanna AN

Project Server 2013 - Queue job - Waiting to be processed

Creating Windows Server 2012 R2 VirtualBox VM for SharePoint 2016

18 Jan 2016 by M Faheem Zafar

This tip explains how to install Windows Server 2012 R2 Server on Oracle VirtualBox VM Server.

Improving SQL query performance using JOIN

29 Nov 2015 by Krishna P Seetharaman

Faced slow performance in certain stored procedure, which caused timeout error. This was improved using WITH clause and JOINs

ASP.NET

SQL Server Data Tools to Visual Studio 2013 - Database Reverse Engineering

30 Oct 2015 by JoaoSousa23

SQL Server Data Tools to Visual Studio 2013 - Database Reverse Engineering

Create a Simple Web Server in Java (2) - HTTPS Server

24 Oct 2015 by Andy Feng

Create a simple and flexible HTTPS server using JDK to process GET/POST requests

Create a Simple Web Server in Java (1) - HTTP Server

15 Oct 2015 by Andy Feng

Create a simple Http Server using Java SDK and process GET/POST requests

Troubleshooting High-CPU Utilization for SQL Server

13 Sep 2015 by Member 10986954

Troubleshooting High-CPU Utilization for SQL Server

Dynamic Pivot Query in SQL Server

22 Jul 2015 by Chetan Naithani

Transforming dynamic row-level data into columns

SQL Server Health Check Up

22 Apr 2015 by Shivangi_K

SQL Server health check up

Native Auditing in MS SQL Server 2008

3 Apr 2015 by SatyLepide

MS SQL Server, a popular database management system from Microsoft, is widely used by organizations to store their data and to fetch them when required.

auditing

SQL CLR Functions

20 Mar 2015 by Sreekanth Mothukuru

SQL CLR functions

CLR

Find progress of a database restore using sys.dm_exec_requests

15 Jan 2015 by Liju Sankar

Find progress of a database restore using sys.dm_exec_requests

T-SQL

sp_who2 to find dead locks in SQL Server

8 Jan 2015 by Liju Sankar

Find deadlocks in SQL Server using sp_who2 (an undocumented and thus unsupported stored procedure)

lock

Pivot Table Using Linq Entity and SQL Server 2008 R2 for Dynamic Columns

20 Nov 2014 by Avinash Narnaware

How to create Pivot Table in SQL Server 2008 R2 and in C# Linq to Entity Framework in a step by step manner with two different instances.

Windows 7 Files

12 Nov 2014 by Alexandros Pappas

Lists the files that are installed with Windows 7 on a Virtual PC

Windows

My experience with ASPOSE

22 Oct 2014 by D. Forbes

Switching from native Word to Aspose's .Words component stabilized our server, and improved the speed of our product.

MS-Word

third-party

Implementing Custom ASP.NET State Management using Redis and ASP.Net MVC5 – Part 1

10 Oct 2014 by Mathew Soji

A walkthrough on installing Redis server and implementing a custom ASP.NET State Management using Redis and ASP.NET MVC5.

Nodejs EventEmitter Simplified

26 Aug 2014 by Siddharth Chandra

nodejs advance topic simplified

COALESCE and ISNULL in SQL Server

1 Aug 2014 by Uppuluri Aditya

COALESCE VS ISNULL in SQL Server - Part1

Arbitrary parameters in SSIS for OLE DB

1 Jul 2014 by Ryszard Dżegan

How to get around restrictions for parameters in OLE DB connection type while working with SSIS and BIDS.

Real-time Tracing With SQL Server Express

11 Jun 2014 by Pete_H

This tip explains how to do tracing with SQL Server Express using a desktop application written in C#, .NET 4.

Use C# to get JSON Data from the Web and Map it to .NET Class => Made Easy!

12 Feb 2014 by Mikhail-T

Easy steps on how to get JSON formatted data from a web service, deserialize it, and map it to custom local class for further usage

RSA SecurID Tokens – Setup on Amazon EC2

26 Nov 2013 by Mumtaz Tariq

Setup RSA SecurID on Amazon EC2 Server

Transaction Log Full Issue in SQL Server

8 Oct 2013 by Kareem.S

This tip discusses about the transaction log full issue in SQL Server

Simple Calendar

1 Oct 2013 by Emerald kwekowe

Simple PHP code to display a calendar.

PHP

Dev

How to Take Backup from SQL Azure using Database Deployment Technique

1 Oct 2013 by P_Dash

Taking a SQL Azure database backup to Local instance from an SQL Azure instance using Deployment Technique

Unified Dimensional Model (UDM)

23 Sep 2013 by coded007

A word about Unified Dimensional Model we use in analysis services.

Simple Method to Save Image in Database

29 Aug 2013 by Ankit R Goud

This tip shows you how to insert image in database.

How to Find Various Day, Current Week, Two Week, Month, Quarter, Half Year and Year in SQL Server

2 Aug 2013 by KISHANHR

Describes how to find various days, current week, two week, month, quarter, half year, and year in SQL Server which are required in most applications.

Windows

User Permissions in SharePoint-hosted App

8 May 2013 by neham_2000

This tip demonstrates user permissions in SharePoint-hosted apps in SharePoint 2013 with attention to a multiple user scenario.

Multithreaded, Customizable SysLog Server - C#

27 Mar 2013 by metastruct

Multithreaded, customizable SysLog server in C#.

Create a local server in C#

28 Oct 2012 by Thomas Daniels

A tip about how to create a local server in C#.

Connecting SQL Server 2012 Express from SharePoint 2013 Configuration Wizard

14 Oct 2012 by Rakesh NITian

Connecting SQL Server 2012 Express from SharePoint 2013 Configuration Wizard

How to update a row with another row if column values are null in SQL

17 Aug 2012 by ManojKumar19

Update row column with another row column in same table SQL only if it is null.

Why is my web application slow?

19 Jul 2012 by Sudheer Reddy Battula

My perspective on “where to begin” to address this issue in a general sense for a Microsoft centric web application.

Interactive Analysis and Related Tools

27 Jun 2012 by stormpy

Interactive analysis is a cycle analysis procedure of assumption, validation, and adjustment to achieve the fuzzy computation goal.

Check For Updates - RemoteVersionChecker

22 Mar 2012 by Fabrizio Stellato

This code provides your application a - check for updates - feature

.NET

application

Output Clause - SQL SERVER, You Can Replace Some of Your Triggers

13 Mar 2012 by sabindas k s

Output Clause - SQL SERVER, You Can Replace Some of Your Triggers

Database Object Model

21 Feb 2012 by databaseobjectmodel

A Sample ORM project

Recycling IIS Apppools .

21 Feb 2012 by yudi19872001

net-App-To-Recycle-the-AppPools-of-IIS-using-WMIC

How to find a specific string from stored procedures, triggers and functions in database

7 Feb 2012 by Member 2077086

Simply add your search phrase and run to find jobs, Stored Procedures, Keys, Tables, Views, Indexes, Defaults, and Functions.set nocount on declare @Keyword as varchar(200)set @Keyword = 'Search prase'--

How to find a specific string from stored procedures, triggers and functions in database

4 Feb 2012 by RasikaLB

You can find queries to find a specific string from MSSQL Server

How to find a specific string from stored procedures, triggers and functions in database

27 Jan 2012 by jim lahey

Please see my alternative tip #2:Do the same thing with SMO[^]There's a Microsoft API for all this, it's been around for a while.

Download SQL Server Sample Databases including SQL Server 2012

7 Jan 2012 by Dhananjay Kumar Upadhyay

Download SQL Server Sample Databases including SQL Server 2012

How To Keep Online Data On Your Own System

4 Jan 2012 by Vijay Kr Sharma

web

Date & Day Name of Current Month in SQL Server Stored Procedure

26 Nov 2011 by Biswa Bhusan Dash

SQL Server Stored Procedure

General rules on selecting Data Types of SQL Server

23 Nov 2011 by Ahmed Naqibul Arefin

Create a simple SMTP server in C#

21 Nov 2011 by jim lahey

Please note I don't want to take anything away from roosrj's tip which displays infinitely more in depth knowledge about the SMTP protocol than I can - as a lazy man's alternative I've always used PostCast v2.6 to test anything mail related:...

SMTP

Create a simple SMTP server in C#

20 Nov 2011 by roosrj

A simple basic SMTP server for testing purposes

SMTP

Sorting column that contains string with numeric value

18 Nov 2011 by Md. Marufuzzaman

Sorting column that contains string with numeric value

Video Tip:- Improve SQL Server performance by using SQL server profiler

16 Oct 2011 by Shivprasad koirala

If you want to quickly get index suggestions and improve performance in SQL Server, then Profiler and tuning wizard is the first place to start.

Increment the string value letter by letter for every row using SQL server

5 Oct 2011 by chaitanya512

Using SQL Server, we can increment the string value letter by letter for every row

Increment the string value letter by letter for every row using SQL server

4 Oct 2011 by Pascal Ganaye

WITH tempTable(Column1)AS( SELECT 'chaitanya' [Column1] UNION ALL SELEC`T SUBSTRING(Column1,1,LEN(Column1)-1) FROM tempTable WHERE LEN(Column1)>0)SELECT * FROM tempTable ORDER BY LEN(Column1)Result:cchchachaichaitchaitachaitanchaitanychaitanya

Rebuild and Reorganizing the index on SQL Server

4 Oct 2011 by Ram Balak Sharma

Improve SQL server performance by rebuild and reorganizing the indexes

Steps to install Microsoft SQL Server 2008 Express Edition (Standard or with Advanced Services)

9 Aug 2011 by Jesus Carroll

This brief article show how to install quickly Microsoft SQL Server 2008 Express Edition Standard or with Advanced Services

Model System DB in Microsoft SQL Server

31 May 2011 by Keshav Singh

Model System DB in Microsoft SQL Server

Microsoft

Kill User Session in Sleep State

18 Apr 2011 by NilayMistry

Session Expiry when browser window is closed

28 Feb 2011 by Peace ON

Following is a one line solution when it is written within Session_End() method of Global.asax file.Session.Abandon()HTH

Session Expiry when browser window is closed

26 Feb 2011 by rajivpande86

When the browser window is closed, how does server react to the Session which was being active?

Concatenate two or more rows with comma (or any you want) in a single string

4 Oct 2010 by Sunasara Imdadhusen

SQL Server 2008 User Defined Table Types and Table-Valued Parameters

14 Jul 2010 by PIEBALDconsult

Simple demonstration of using UDTTs and TVPs to pass DataTables to SQL Server 2008

TVP

Using GetAncestor() in a join

26 May 2010 by Mycroft Holmes

GetAncestor() requires a slightly unusual outlook to get the required results

Some internal SQL Sever Queries

22 Feb 2010 by Gaurav Dudeja India

The following query uses the sys.objects catalog view to return all database objects that have been modified in the last 10 days.SELECT name AS object_name ,SCHEMA_NAME(schema_id) AS schema_name ,type_desc ,create_date ,modify_dateFROM sys.objectsWHERE modify_date >...