Blog

  WHAT   SQL Server 2014 introduced native compiled stored procedure. In this process code are converted to machine code that stored into DLL files stored in a specific folder of SQL Server. Memory optimized Machine codes can be directly executed by processor without further compilation or interpretation. So it...

SQL Server’s Query Store, introduced in SQL Server 2016, helps to troubleshoot query performance by capturing a range of information about query usage, CPU, memory consumption, I/O and execution time, and retaining every Execution Plan for analysis. Much of this information is available through queries. It looks set to be...

What is Query Store? Query store has introduced for performance troubleshooting process. Queries having multiple plans: Store the history of query plans in the system Execution Plans and runtime statistics Stores the insight information of each queries i.e. Resource usage, database usage Identify queries that have “gotten slower recently” Identify...

Hi Friends it’s our first step is to get knowledge on the Machine learning. Is it Possible to make a machine knowledgeable ? Is not so funny ? How the concept is differ from our traditional software development practice i.e. Web development, Application development or IoT based apps . Let's...

<div class="MsoNormal" style="margin:0 0 8pt;">The article describe the ETL process of integration service. Learning objectives:</div><div class="MsoListParagraphCxSpFirst" style="margin:0 0 0 48pt;text-indent:-.25in;">1.       Retrieve data from text file </div><div class="MsoListParagraphCxSpMiddle" style="margin:0 0 0 48pt;text-indent:-.25in;">2.       How to use temporary tables in SSIS</div><div class="MsoListParagraphCxSpLast" style="margin:0 0 8pt 48pt;text-indent:-.25in;">3.       Life Cycle of SSIS.</div><div class="MsoNormal" style="margin:0 0...

<div style="margin:0 0 8pt;">WHAT</div>In-memory OLTP is a memory-optimized database engine integrated with SQL Server engine. It optimized OLTP operations. It massively improve performance and scalability of databases and by that applications will be speed up. <div style="margin:0 0 8pt;">Its main mechanism is that it allows you to declare a table...

Active Directory Active Directory a directory service created by Microsoft for Windows domain networks to gives you out-of-the-box functionality needed to centrally configure and administer user accounts, computer accounts, groups, and all related credential information used by windows and SharePoint.For details: http://msdn.microsoft.com/en-us/library/windows/desktop/aa772217(v=vs.85).aspx  Server Farm Server farm is group of computers...

How To Create A Blog Using Jekyll

2020-02-02 How to Create a Blog Using Jekyll and GitHub Pages on Windows Written on April 30th, 2020 by Sabina Akter Jekyll has no admin interface , only source files that you can build using a CLI (command line interface) to create a static website. Simply write your blog posts...

Explore Always Encrypted

What is Always Encrypted? Always Encrypted is a data encryption technology that helps protect sensitive data at rest on the server, during movement between client and server, and while the data is in use, ensuring that sensitive data never appears as plain text inside the database system. Type of Always...

Explore SQL Server Contained Database

What is Contained Database ? Contained database is a features that is isolated database from the SQL Server instance and other databases located in the same instance. It was introduced in all edition of SQL Server 2012 having few special features. Key objectives of Contained database is to enable isolation...

SQL Server Data Compression 

What is Data Compression ? Data compression is a very effective technique to reduce the size of data in the database. Less I/O processes happens due to processing of compressed data and increases the load on CPU requirements. Compression is a great way to get more mileage out of your...

Explore Row Level Security

What is Row Level Security ? It is introduced in SQL Server 2016, row-level security feature allows users to have access to a table but restricts them to accessing specific rows within that table. Prior to SQL Server 2016, this required custom stored procedures to be written for the provision...

Resource Governor

What is RG ? Resource Governor (RG) is a mechanism by that specific resources are allocated to resource groups, where we can define groups based on applications or users and therefore limit how much resources are used. Think a situation, where application and reporting use same database server.Request are coming...

Database Design Step by Step

Database Design Life Cycle The database development life cycle has a number of stages that are followed when developing database systems. But on small database systems, the database system development life cycle is usually very simple and does not involve all of the steps. Data Modelling Data Model is like...

Difference between Log Shipping,Mirroring & Replication

In this article,we’re going to explored what why when to use of Log Shipping,Mirroring & Replication. Architecture of Log Shipping and Mirroring : Architecture of Replication :   Explanation Point Log Shipping Mirroring Replication What In Log shipping mechanism, periodically take log backups of the primary database, copy the backup...

SQL Server Audit

What is Auditing ? Auditing is used for tracking and logging events on a single instance or individual database .Through server audit specifications server level events and database audit specifications for database level events are captured into event logs or audit files. Components : audit is the combination of several...

Explore Dynamic Data Masking

DDM is a very simple security feature that can be fully built using T-SQL commands which we are familiar with, easy to use and also flexible to design. Masking masks the sensitive data “on the fly” to protect sensitive data from non-privileged users using built-in or customized masking functions, without...

Temporal Table

What is Temporal Table ? In a traditional table we can keep data along with CRUD operation but can’t view the history of data contained in tables.On the other site, temporal tables allow to automatically keep history of the data in the table A system-versioned table allows you to query updated and...

Always Encrypted

Always Encrypted is a data encryption technology that helps protect sensitive data at rest on the server, during movement between client and server, and while the data is in use, ensuring that sensitive data never appears as plaintext inside the database system. The following illustration depicts the Always Encryption process....

Effective Usage of TempDB

TempDB is a system database in Microsoft SQL Server used as a store of internal objects, row versions, work tables, temporary tables, and indexes. TempDB is available for use to all participants connected to a SQL Server instance (it is a global resource). TempDB is shared across all databases and...

Transaction Control

Applications control transactions mainly by specifying when a transaction starts and ends. This can be specified by using either Transact-SQL statements or database application programming interface (API) functions. The system must also be able to correctly handle errors that terminate a transaction before it completes. By default, transactions are managed...

Explore Dynamic Management Views (DMV)

What is DMV ? “DMVs” are query structures built into SQL Server that deliver details about server and database health/performance. DMVs provide a common mechanism to extract “all things SQL” as well as Windows OS performance data Dynamic management views and functions return internal, implementation-specific state data. Their schema and the data they return may change in...

Explore Table Partition in SQL Server

What Is SQL partitioning? Using this technique a large table can be split into more manageable pieces without create multiple tables. Partition function is used for splitting into multiple pieces. Each individual partition can be physically stored ,accessible and maintainable separable .Partitioning allows tables, indexes, or index-organized tables to be...

Insight of Query Execution

It’s good to know how a MS SQL Server query is processed by SQL Server database engine.There are six steps by that a query is executed.It’ll help to get idea on few matters Dirty Pages Read SQL Server Query execution Plan Isolation and Locking Following steps get idea of query...

Get started with Power BI Part-3 "Building a Data Model using Power BI Desktop"

Explore Column Stored Index

What is a column store index? A columnstore index is a type of data structure that’s used to store, manage and retrieve data that is stored in a columnar-style database. Why Column Store Index is used ? Best for queries that scan/aggregate large sets of data. IO Statistics - dramatically reduces...

Performance improvements in TempDB

Starting with SQL Server 2016 (13.x), TempDB performance is further optimized in the following ways: Temporary tables and table variables are cached. Caching allows operations that drop and create the temporary objects to execute very quickly and reduces page allocation contention. Allocation page latching protocol is improved to reduce the...

Machine Learning Using Python With SQL Server 2017

Microsoft has announced it's latest SQL Server 2017 CTP 2.1 version on 17 May 2017 which is available both in Windows and Linux. This blog will focus on Machine learning capabilities using Python in SQL Server 2017 CTP 2.1 . In SQL Server 2017 R and Python languages can be used for...

Index in SQL Server

What is Index ? SQL Indexes are used in relational databases to quickly retrieve data without reading the whole table. Similar to indexes of the books whose purpose is to find a topic quickly. Alternatively Indexes are special data structures associated with tables or views that help speed up the...

Best Practice of tempBB

SQL Server instance, use it to hold temporary objects that users, or the database engine, create.SQL Server recreates the tempdb database each time the SQL Server service starts.  tempdb is a temporary store.It is common for tempdb memory requirements to exceed the capacity of the buffer pool in which case,...

Introduction to ASP.NET Core

What is ASP.NET Core? ASP.NET Core framework is a Next generation of ASP.NET framework which is Free and open-source web framework Complete rewrite that unites the previously separate ASP.NET MVC and ASP.NET Web API into a single programming model. Despite being a new framework, it does have a high degree...

Get started with Power BI Part-6 "Managing Gateways and On-premises Data"

Get started with Power BI Part-2 "Extracting and Transforming"

Get started with Power BI Part-1

What is a Power BI ? Power BI is a self service business intelligence suite.The question will come in mind that what it will ? Why it is required ? "Want to make GOOD Business Decision" "Explore Insight of Business" "Visualization of data and Share " Grow your business faster...

First general availability (GA) release of SSDT for Visual Studio 2017 (15.5.0)

First general availability (GA) release of SSDT for Visual Studio 2017 (15.5.0) has published.Now design and deploy SQL Server content type :Database Projects, Schema Compare, Data Compare, SQL Server Object Explorer and more in way like develop an application in Visual Studio.Analysis Services and Reporting Services BI project types is...

Explore Power BI Components

  Power Query: It can be used to search, access, and transform public and/ or internal data sources. Power Pivot: It is used in data modeling for in-memory analytics. Power View: You can analyze, visualize and display data as an interactive data visualization using Power View. Power Map: It brings data to life with...

Get started with Power BI Part-4 "Designing and Publishing Reports & Dashboards"

Let’s start our tour at the dashboard and look at the tiles the CMO has chosen to pin. We see information about our market share, sales, and sentiment. And we see that data broken down by region, time, and competition.+ The number tiles down the left column show industry sales...

Microsoft's SQL Operations Studio - free open source Data Management tool

What is Microsoft’s SQL Operations Studio (SOS)? SQL Operations Studio is a free open source Data Management tool .It enables you to work with SQL Server, Azure SQL DB and SQL Data Warehouse . It is lightweight and comes with great color themes. Workspaces with full Git integration and Find In Files support...

Let’s Start with Power BI Report Server

At a Glance  Introduction What Why How… Installation Configuration Introduction The Power BI Report Server is a new, standalone product that allows organizations to host Power BI Reports on an on-premises report server. Additionally, the Power BI Report Server is built upon the same architecture as SQL Server Reporting Services,...

SQL Server 2017 Launch with Great features

Microsoft’s shift towards being a more open source-oriented company. The Linux distributions supported include RedHat Enterprise Linux, SuSE Enterprise Linux and Ubuntu. You can also run SQL Server 2017 in Docker containers, which is an option many development shops may consider for rapid deployment of development databases.The database engine binaries...

How I Rest From Work

Fam locavore snackwave bushwick +1 sartorial. Selfies portland knausgaard synth. Pop-up art party marfa deep v pitchfork subway tile 3 wolf moon. Ennui pinterest tumblr yr, adaptogen succulents copper mug twee. Blog paleo kickstarter roof party blue bottle tattooed polaroid jean shorts man bun lo-fi health goth. Humblebrag occupy polaroid,...

The Best Organizer Software

Church-key blog messenger bag, selfies umami man braid mlkshk. Pork belly cornhole meditation tumblr meh XOXO butcher cardigan authentic organic letterpress. Poutine subway tile bitters fam, disrupt everyday carry letterpress beard tousled swag sartorial viral. Retro af 3 wolf moon heirloom, pork belly man bun DIY chillwave. Shoreditch ennui stumptown,...

How To Start Programming

Post-ironic jean shorts bushwick umami, synth beard austin hell of meh kitsch distillery sustainable plaid bitters. Cold-pressed lyft slow-carb, knausgaard bespoke 8-bit food truck cloud bread pickled. Taiyaki bitters trust fund heirloom craft beer single-origin coffee. Readymade fam vape blue bottle cold-pressed, flannel polaroid. Aesthetic four dollar toast semiotics af...

10 Tips To Improve Your Workflow

Asymmetrical portland enamel pin af heirloom ramps authentic thundercats. Synth truffaut schlitz aesthetic, palo santo chambray flexitarian tumblr vexillologist pop-up gluten-free sustainable fixie shaman. Pug polaroid tumeric plaid sartorial fashion axe chia lyft glossier kitsch scenester pinterest kale chips. Blog etsy umami fashion axe shoreditch. Prism chambray heirloom, drinking vinegar...

Conference on Javascript

Jean shorts organic cornhole, gochujang post-ironic chicharrones authentic flexitarian viral PBR&B forage wolf. Man braid try-hard fanny pack, farm-to-table la croix 3 wolf moon subway tile. Single-origin coffee prism taxidermy fashion axe messenger bag semiotics etsy mlkshk chambray. Marfa lumbersexual meditation celiac. Pork belly palo santo artisan meggings vinyl copper...

Exploring Power BI

Always it’s very much important to know the status where is me , product sales status ,financial status customer feedback ,service status,project progress,…. ???                 Predefined reports generated form system help us to know the answer of all questions. But problem raise when...

Launch Microsoft Power BI Report Server - June 2017 GA

WOW ! it’s really exciting matter that Microsoft Power BI Report Server - June 2017 GA is now available. Power BI Report Server is the on-premises solution you can use today.It’s on premises solution. Now you can deploy PowerBI Reports with your firewall means your local webserver. PowerBI is a no-code solution...

How do I become a data scientist?

It’s important to know the steps how any one become a data scientist .If you are interested to become a data scientist then it’ll be hopefully help you though tons of articles are on the web. Business Applications are now in matured stage. Every day man, machine, IoT devices, click stream...

Architecture and Overview of Machine Learning Services

What is Machine Learning ? Machine learning is closely related to computational statistics, which also focuses on prediction-making through the use of computers. It has strong ties to mathematical optimization, which delivers methods, theory and application domains to the field. What is Microsoft Machine Learning Services ? The goal of...

Installing the SSIS Package on Ubuntu 17.04

It’s Great news that now SQL Server Integration service’s  Linux version SSIS is available in CTP 2.1.It’s initial step to toward platform independence .According to the Microsoft Program Manager Leo Li  “SQL Server Integration Services CTP 2.1 and try it out on your Linux machines or VM by command lines.Run SSIS...

Ubuntu 17.04 VM creation on Azure

You have an option to get an Azure account with 200$ free credit for limited time. Click Here To explore the SaaS, PaaS & IaaS and cloud based services. To any kind of professional job virtual Machine price starts from 13$ per month. It’s “Pay only for what you use” model....

Remote Desktop to connect to a Microsoft Azure Ubuntu VM

Xrdp is an open source RDP server, which allows you to connect your Linux server with Remote Desktop from a Windows machine. It performs much nicer than VNC (Virtual Network Computing). VNC has this streak of “JPEG” quality and slow behavior, whereas RDP is fast and crystal clear. We will...

Install Microsoft SQL Server On Ubuntu 17.04

Exciting mater is that we’re going to install Microsoft SQL Server on Ubuntu Linux. I’ve been working on SQL Server from last fourteen years. Many times, I’m to face many common words “Is your Application database can be installed on Linux platform?”, need additional licensing cost to buy OS for...

On-premises Power BI Report Server

WOW Power BI is going to be on-Premises .It’s not that Power BI running embedded in reporting Services.It’s new Power BI Report Server which is an on-premises server that enables users : Publish Power BI reports and manage them on-premises (Power BI Report Server) without requiring per user licensed model and can...

What's New on SQL Server 2017 CTP 2.0

Cross-platform compatibility is increasingly important in our customers’ diverse and rapidly changing data estates. SQL Server 2017 will be the first version of SQL Server compatible with Windows, Linux, and Linux-based container images for Docker. In addition to running on Windows Server, the new version will also run on Red...

Get Ready SQL Server 2017 CTP 2.0 on Linux

Scott Guthrie - Executive Vice President, Cloud and Enterprise Group, Microsoft had announced the plan of Microsoft to bring the SQL Server to Linux which will enable SQL Server to deliver a consistent data platform across Windows Server and Linux also on-premises and cloud. Microsoft targeting the availability in mid-2017. Microsoft is...

Manage Session State of ASP.NET Core 1.0 Application by SQL Server 2016

Manage Session state of ASP.NET Core 1.0 Application by SQL Server 2016•……is a mechanism that enables to store and retrieve user specific data that can be stored for visitor’s session. Discount level they are entitled, name , ID ,User role or data that is repeatedly required. •Is a mechanism that...

What's New in SQL Server 2016

SQL Server 2016 delivers breakthrough mission-critical capabilities with in-memory performance and operational analytics built-in. Comprehensive security features like new Always Encrypted technology helps protect your data at rest and in motion, and a world class high availability and disaster recovery solution adds new enhancements to AlwaysOn technology. In-Memory OLTP In-Memory...

Simple Steps on SQL Server Reporting Service(SSRS)

Simple Steps on SQL Server Reporting Service

ASP NET CORE | .NET Core Architecture

What is ASP.NET Core? .NET Core is a new cross-platform (Windows, Mac and Linux) and open source version of .NET Targeting Cloud and Mobile scenarios. It is the basis of ASP.NET 5 and .NET UWP apps. Deployable on the cloud or run on-premises Why ASP.NET Core? Modular components with minimal...

Jump Start to Azure Stream Analytics

Azure Stream Analytics aims to extract knowledge structures from continuous ordered streams of data by real-time analysis.These streams might include computer network traffic, social network data, phone conversations, sensor readings, ATM transactions or web searches. Azure Stream Analytics is a fully managed, cost effective real-time event processing engine that helps...

Steps Towards Microsoft Business Intelligence

Overview, Business Intelligence (BI), SQL Server Analysis Service (SSAS), SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS) and Azure SQL Server. Presentation contain : Basic Concept of BI Introduce Data Warehouse Microsoft BI Technologies Data Warehouse Design Concept Microsoft SQL Server Analysis Service (SSAS) Demo Program: Step By...

Step by Step Table Partition in SQL Server 2014

Step by Step Table Partition in SQL Server 2014 What is Table Partition ? ¢    Partitioning is the database process or method where very large tables and indexes are divided in multiple smaller and manageable parts. SQL Server allows to partition tables using defined ranges and also provides management features...

Overview of Business Intelligence

“A broad category of applications and technologies for gathering, storing, analyzing, sharing and providing access to data to help enterprise users make better business decisions” -Gartner      . Why BI ? Performance management Identify trends Cash flow trend Fine-tune operations Sales pipeline analysis Future projections business Forecasting Decision Making Tools...

Step by Step Design Cube Using Analysis Service (SSAS)

A cube is defined by its measures and dimensions. The measures and dimensions in a cube are derived from the tables and views in the data source view on which the cube is based, or which is generated from the measure and dimension definitions: Details on : https://gallery.technet.microsoft.com/Design-Cube-in-SQL-Server-49ee6e1c

SQL Server Integration Service

Step By step: Creating a ETL process in MS SQL Server Integration Services (SSIS)   The article describe the ETL process of integration service. Learning objectives:   1.       Retrieve data from text file   2.       How to use temporary tables in SSIS   3.       Life Cycle of SSIS.   This...

SQL Server 2014 In-Memory OLTP

In-memory OLTP is a memory-optimized database engine integrated with SQL Server engine. It optimized OLTP operations. It massively improve performance and scalability of databases and by that applications will be speed up. Its main mechanism is that it allows you to declare a table to be stored in main memory...

Deep Drive on Big Data & Hadoop

Big Data hug amount of data that can’t be stored and processed with traditional approach within limited time frame. Big data is a collection of data sets so large, complex ,rapidly growing that becomes difficult to search, process, sharing, storage, transfer, visualization, querying, updating and information privacy using on-hand database...

Best Practices for Database Design-Development-Deployment

            1.1            Database Tables should be normalized. But you have to be remember that over-normalization will cause excessive joins across too many tables. 1.2            Tables name should be consistent and expressive. 1.3            Columns data type should be properly define. It is not better to store image files in tables. Instead...

How long time has taken for SQL Server database Backup or Restore?

<div class="MsoNormal" style="margin:0 0 8pt;">After restoring any database you can get information the time required for restoring database not before restoring  </div><div style="text-align:left;"></div><div style="text-align:left;">select session_id,</div><div style="text-align:left;"></div><div style="text-align:left;">convert(nvarchar(22),db_name(database_id)) as [database],</div><div style="text-align:left;"></div><div style="text-align:left;">case command</div><div style="text-align:left;"></div><div style="text-align:left;">when ‘BACKUP DATABASE’ then ‘DB’</div><div style="text-align:left;"></div><div style="text-align:left;">when ‘RESTORE DATABASE’ then ‘DB RESTORE’</div><div style="text-align:left;"></div><div style="text-align:left;">when ‘RESTORE VERIFYON’ then...

Performance Consideration of joining TABLES in Microsoft SQL Server

<ol><li>Performance is to limit how many rows need to be Joined.</li><li>Each of the joined columns have their own indexes. </li><li>the columns used for the joins are not naturally compact, then considering adding surrogate keys to the tables that are compact in order to reduce the size of the keys.</li><li>Plan to...

Database design and keys in SQL Server 2014

1. Foreign key (FK) is a single column or combination of columns that establish and enforce a link between the data in two tables2. Link is created between two tables when the column or columns that hold the primary key value for one table are referenced by the column or...

Windows Azure Web Sites

<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-collapse:collapse;width:634px;"><tbody><tr style="height:29.2pt;"><td style="background-color:transparent;border:1pt solid white;height:29.2pt;padding:.05in .1in;width:6.6in;" valign="top" width="634">Using this feature you can easily migrate your existing website or build a new website on the Windows Azure platform. To deploy you need to have the option like FTP, Git, WebDeploy, or TFS. Advantage:<div style="margin-left:.5in;text-indent:-.25in;">1.      It’s scalable...

Windows Azure Services Platform

Microsoft intends its new Windows Azure Services Platform to be a serious cloud computing platform for a broad range of developers and scenarios, from lone developers starting up a new Web-based company on a shoestring to large teams of enterprise developers looking for high-performance, highly available, and scalable Web sites,...

Step by Step Guide line of Web Load Testing using Visual Studio Ultimate 2013

To create a load test we will define user load, specify the web performance tests to use, the type of network and browser simulation to use, and the performance counters and other metrics that we want to collect for the duration of the test.Select Project | Add Load Test from...

Step by Step Guide line of Web Performance Testing using Visual Studio Ultimate 2013

<div class="separator" style="clear:both;text-align:center;"></div><h2>Introduction</h2>Performance testing determine how a application act under a specific workload .To measure, validate or verify responsiveness and stability of the application and resource usage for smooth operation.<h2>Background</h2>Performance testing is used to uncover performance problems that can result from lack of server-side resources, inappropriate network bandwidth, inadequate data- base capabilities, faulty or...

BCP Commands

How the “Team Foundation Server” do stores data that require for Project Reporting?

 <div align="LEFT" dir="LTR">For Creating customize reports we need to know the data source and how to work the data source. Also access to the databases may influence your decision. To refreshing Excel reports, you must grant more extensive permissions to the data warehouse. </div><div align="LEFT" dir="LTR">Business reports that users share...

How to create new work item type in Process Template of TFS?

Work item type is important it enable you to define work item type. To create new on <div class="MsoNormal" style="margin:0 0 10pt;">You need to do as below:</div> Steps 1: Go to Process template Folder –> “WorkItem Tracking” –><div class="separator" style="clear:both;text-align:center;"></div> <div class="MsoNormal" style="margin:0 0 10pt;">Open WorkItems.xml file using visual Studio...

What is Process Template in Team Foundation Server (TFS)? Anatomy of Process Template.

Process is a series of actions or operations designed to achieve a result, product or service. Software development is run on a process may differ based on company to company. But a process framework is required to increase productivity. It is better to formalized process and process guidance to help...

Linking between Work Items In TFS

<div class="MsoNormal" style="margin:0 0 10pt;">A work item is a single unit of work which needs to be complete. Microsoft defines a work item as database record that Team Foundation uses to track the assignment and progress of work.</div>Identification and establish relationship between tasks is highly important to make effective planning....

How to create a new Team Project Collection in TFS2010 step by step ?

<div class="MsoNormal" style="margin:0 0 10pt;">Steps 01:</div><div class="MsoNormal" style="margin:0 0 10pt;">Select “Team Foundation Administration Console”  by navigating below steps</div>Start –> All Programs –> Microsoft Team Foundation Server 2010 –> Team Foundation Administration Console                                      <div class="MsoNormal" style="margin:0 0 10pt;">Steps 02:</div>Now you will see the below screen and you need to expand the...

Think before implementation of Team Foundation Serve (TFS)

<div class="MsoNormal" style="margin:0 0 10pt;">In an organization multiple development project or business unit are exists they need isolation in the context of security, manageability, schedule maintenance and administration backup restore etc. TFS Server can have one or more Team Project Collections. Team Project Collection can contain one or more Team...

Why TFS is required in Software development?

<ol><li>TFS has tightly integrated collaboration functionalities for Development team.</li><li><div>Version controlling using state of the art technology. </div></li><li><div align="LEFT">TFS has powerful features like atomic check-ins, branching and merging, shelving, labeling, concurrent check-outs, check-in policies, and the association of check-ins with work items.</div></li><li><div align="LEFT">Agile and CMMI process model is available. </div></li><li><div align="LEFT">Project...

SQL SQL Server 2012 Features Part-1

AlwaysOnAlways on feature provide high availability and disaster recovery solution. AlwaysOn maximizes the availability of a set of user databases for an enterprise and improve resource use. SQL Server 2012 provide option to make group set of database called Availability group which will be treated as individual entity.SQL Server 2012...

What will be the benefits we can get by integrating SharePoint with TFS (Team Foundation Server)?

Microsoft introduced Team Foundation Server (TFS) to fulfill the collaboration activity of software development life cycle. This activity includes source control, data collection, reporting, and project tracking. We can use TFS by itself or can be collaborate with Visual studio team system. Team Explorer of TFS is a tool which...

What are the pains can be reduced by using TFS?

1.       How different team members organize test cases (unit, system and integration testing)? 2.       How can I manage code whenever concurrent development and realize need to be perform? 3.       How can a developer incorporation bug solution in a specific realize? 4.       What is the status to release at the end...

Team Foundation Server (TFS) Architecture

Team Foundation Server Logically works in 3-tier architecture that includes client tier, the application tier and the data tier. <div class="MsoNormal" style="line-height:normal;margin:0;">Clint Tire :</div><div class="MsoNormal" style="line-height:normal;margin:0;">Clint tire communicates with application tier for creating and managing projects and access project’s items. In this tier TFS has no user interface it exposes...

What is Team Foundation Server?

<div align="left" dir="ltr">What is Team Foundation Server?</div><div align="left" dir="ltr"></div><div align="left" dir="ltr">Team Foundation Server (commonly abbreviated to TFS) is a collaboration platform. You Collaborate different phases of Microsoft’s application life cycle such as source control, team build , project tracking ,testing ,data collection and reporting, team project portal and shared service.It...

How to compare two different tables attributes of two databases in a server?

How to compare two different tables attributes of two databases in a server?use masterGOif ( select count(*) from sysobjects where id = object_id(N’sp_CompareDbTables’) ) > 0 drop proc sp_CompareDbTablesGOcreate proc sp_CompareDbTables@dbA_Name sysname, @dbB_Name sysname, @TableNameLike varchar(100) = null – null = All Tables, ‘IBTA%’ = Tables like ‘IBTA%’, @CompareOnlyDifference int...

What's New in CSS3 ?

The members of the CSS&FP Working Group have decided to modularize the CSS specification. This modularization will help to clarify the relationships between the different parts of the specification, and reduce the size of the complete document. It will also allow us to build specific tests on a per module...

What’s New in HTML5?

The HTML 5 draft reflects an effort, started in 2004, to study contemporary HTML implementations and deployed content. The draft: <ol type="1"><li class="MsoNormal" style="color:black;line-height:normal;margin:0 0 10pt;">Defines a single language called HTML 5 which can be written in a “custom” HTML syntax and in XML syntax. </li><li class="MsoNormal" style="color:black;line-height:normal;margin:0 0 10pt;">Defines detailed processing...

Explore Windows 8 What’s new ?

<div class="MsoNormal" style="line-height:normal;margin:0 0 10pt;"><div class="separator" style="clear:both;text-align:center;"></div>The charms bar:</div><div class="MsoNormal" style="line-height:normal;margin:0 0 10pt;">The start screen converted to a new vertical toolbar known as the charms bar.  You can access charms bar by using touchscreen, or pointing the cursor for accessing system and app-related functions to search, sharing, device management, settings...

Explore Windows Server 2012 What’s new?

1. Multitenant environment with tools which can provide the resource uses tracking. 2. Highly scalability and performance for Cloud solution. 3. Connectivity to cloud services 4. Easy-to-manage multi serve platform 5. Diverse Storage Choice for flexible data storage 6. High availability services 7. Having improves data security, control, and compliance...

What's new in business intelligence in SharePoint Server 2013 Preview

Excel BI   Excel BI provides the capabilities to analyze and visually explore data of any size, and to integrate and show interactive solutions. In SharePoint Server 2013 Preview, Excel BI offers certain new features to support business intelligence applications. These include the following:<div class="section"></div><div class="unordered">In-Memory BI Engine (IMBI): The...

How can we set Unique column in SharePoint 2010 list ?

In SharePoint 2010, we have the built in functionality to enforce the uniqueness of the field. But yes do remember that the field must be indexed first before you want to set it as a primary key.Create a list in SharePoint 2010 site and then create a field that you...

SQL Server 2012 Enhancements for SharePoint

SQL Server 2012 Enhancements for SharePoint “1. Disaster Recovery and Resiliency Improvements - Always On – this was the big one. At the SharePoint Conference they showed an automatic failover of a 14 TB database in less than one minute. There’s a ton in here. Improvements to combining the best...

Social computing in SharePoint Server 2013

In SharePoint 2013 introduced Social Networking feature introduced community site and My Site feature. community site template has option to categories discussion among broad group of people. Its deployment helps the end user to make communication and exchange views on specific area among the people. It provides additional benefit to...

What is Azure SQL Database ? SQL Azure Architecture

Microsoft SQL Azure Database is a cloud-based relational database service that is built on SQL Server technologies and runs in Microsoft data centers on hardware that is owned, hosted, and maintained by Microsoft. SQL Azure Database does not support all of the features and data types found in SQL Server...

Cloud App Model in SharePoint 2013

Cloud App Model has made it possible to build new dimensional apps that combine web technologies and cloud services. It can be hosted on cloud; it enables faster deployment, up gradation facility and easy maintainability option. Now developer have the ability to publish and sell apps through a new Office...

SharePoint 2013 Top New Features

     1.     Add third party apps<div class="MsoListParagraphCxSpFirst" style="margin:0 0 0 .5in;text-indent:-.25in;">      SharePoint 2013 has much easier facility to add third party apps. Dreamweaver, Microsoft Expression Web, or some other HTML editor can be used as branding tools.</div><div class="MsoListParagraphCxSpMiddle" style="margin:0 0 0 .5in;text-indent:-.25in;">2.    WEB 2.0 api</div><div class="MsoListParagraphCxSpMiddle" style="margin:0 0 0 .5in;">WEB...

Sub Component of Requirement Development

Sub Component of Requirement Development <div class="text_exposed_root text_exposed">Elicitation: involves the actions we go through to understand users and discover their needs.</div><div class="text_exposed_root text_exposed"> </div><div class="text_exposed_root text_exposed">Good Practices :-1.Define requirements development process 2.Define vision and scope3.Identify user classes4.Select product champions5.Establish focus groups6.Identify use cases7.Identify system events and responses8.Hold facilitated elicitation workshops9.Observe users performing their...

Why Requirement Analysis and it's types?

Why Requirement Analysis and it’s types?                                                                                              To develop quality software – on time and on budget – that meets customers’ real needs. Project success depends on good RAM.The earlier in the cycle the defect is corrected -Cost -Delay +Profit +Customer satisfaction Cuddling customer confidenceBusiness RequirementBusiness requirements represent a kind of “why”...

What Is Requirement ?

What Is Requirement ?A capability that the system must deliver A capability needed by the user to solve a problem to achieve an objective What requirement Are Not ?project planning information design or implementation details or testing information Why Requirement Analysis ?The earlier in the cycle the defect is corrected...

Installation SharePoint 2013 Step by Step

PrerequsitWnidows Server 2008 R2 64bit with service pack or Wnidows Server 2012SQL Server 2008R2 or SQL Server 2012 Windows Identity Foundation v1.1 Microsoft Information Protection and Control Client Microsoft WCF Data Services Windows Management Framework 3.0 Application Server Role Web Server (IIS) Role Microsoft .NET Framework 4.0 Update for the .NET Framework...

Microsoft Virtualization Technologies

Windows Server 2008 R2 Hyper-V and System Center - provide SharePoint architects with a flexible toolset that can be used to reduce hardware and energy costs, increase the performance of SharePoint farms, and provide a level of design and management flexibility that is not possible with traditional physical deployment approaches....

Installing Microsoft SQL Server 2012 on Windows 2012 Server

  Prerequisite<div class="MsoListParagraphCxSpFirst" style="margin:0 0 0 .5in;text-indent:-.25in;">1.   OS:</div><div class="MsoListParagraphCxSpMiddle" style="margin:0 0 0 .5in;">Windows 7, Windows Server 2008 R2, Windows Server 2008 Service Pack 2, </div><div class="MsoListParagraphCxSpMiddle" style="margin:0 0 0 .5in;">Windows Vista Service Pack 2.</div><div class="MsoListParagraphCxSpMiddle" style="margin:0 0 0 .5in;text-indent:-.25in;">2.    .NET 3.5 SP1 is a requirement</div><div class="MsoListParagraphCxSpMiddle" style="margin:0 0 0 .5in;text-indent:-.25in;">3.     Install.NET...

Deploy an ASP.NET MVC Mobile Web Application on Windows Azure Web Sites

You will learn: • How the ASP.NET MVC 4 templates use the HTML5 viewport attribute and adaptive rendering to improve display on mobile devices. • How to create mobile-specific views. • How to create a view switcher that lets users toggle between a mobile view and a desktop view of...

5 min Before Deploy Apps to Windows Azure

Thinks need to be aware before deploy application on Windows Azure: Application develop in house can’t be deployed on Azure.Storage structure in Azure is different ,Windows Azure storage can keep non relational data SQL Azure work on relational data but it is quite differing from SQL Server. Web role instance...

Application on Windows Azure

At the top level Windows Azure provide two services platform to run application and storage facility to store data. In Windows Azure environment application’s each instance running on an individual virtual machine .Virtual machine runs 64 bit Windows 2008 and they provided by Hypervisor which is specially designed for Cloud...

Azure Service Platform

First we have to identify what is service platform? To run an application on cloud it needs different services to run. In the context of service Microsoft Azure different group of services they provide specific service. Cloud service platform Windows Azure Service: Windows Azure service provides windows based environment and...

Risks And Benefits in Cloud Computing

RISKS Vendor lock-in There are a small number of platform-as-a-service vendors today, and most have interests rooted in building a binding relationship through a comprehensive offering. Vendors such as Microsoft have been doing this for decades, and if the vendor remains viablea and relevant and responds to the user community,...

Windows Azure Environment

Application running on cloud is quite like that it is running on a virtual machine that running on Windows. Windows Azure assist for making a deployment environment so that   applications can be more reliable, more scalable, and require less administration cost. But Windows Azure application environment isn’t exactly the same...

SQL Server Table Partition

What is Table Partition ? ¢    Partitioning is the database process or method where very large tables and indexes are divided in multiple smaller and manageable parts. SQL Server allows to partition tables using defined ranges and also provides management features and tools to keep partition tables in optimal performance....

The Windows Azure Service Model

A Windows Azure application is called a “service”<div class="O1" style="direction:ltr;line-height:120%;margin-bottom:0;margin-left:.81in;margin-top:4.8pt;text-align:left;text-indent:-.31in;unicode-bidi:embed;vertical-align:baseline;">–Definition information</div><div class="O1" style="direction:ltr;line-height:120%;margin-bottom:0;margin-left:.81in;margin-top:4.8pt;text-align:left;text-indent:-.31in;unicode-bidi:embed;vertical-align:baseline;">–Configuration information</div><div class="O1" style="direction:ltr;line-height:120%;margin-bottom:0;margin-left:.81in;margin-top:4.8pt;text-align:left;text-indent:-.31in;unicode-bidi:embed;vertical-align:baseline;">–At least one “role”</div><div style="direction:ltr;line-height:120%;margin-bottom:0;margin-left:.38in;margin-top:5.76pt;text-align:left;text-indent:-.38in;unicode-bidi:embed;vertical-align:baseline;">•Roles are like DLLs in the service “process”</div><div class="O1" style="direction:ltr;line-height:120%;margin-bottom:0;margin-left:.81in;margin-top:4.8pt;text-align:left;text-indent:-.31in;unicode-bidi:embed;vertical-align:baseline;">–Collection of code with an entry point that runs in its own virtual machine</div><div style="direction:ltr;line-height:120%;margin-bottom:0;margin-left:.38in;margin-top:5.76pt;text-align:left;text-indent:-.38in;unicode-bidi:embed;vertical-align:baseline;">•There are currently three role types:</div><div class="O1" style="direction:ltr;line-height:120%;margin-bottom:0;margin-left:.81in;margin-top:4.8pt;text-align:left;text-indent:-.31in;unicode-bidi:embed;vertical-align:baseline;">–Web...

Windows Azure Services Platform

Microsoft intends its new Windows Azure Services Platform to be a serious cloud computing platform for a broad range of developers and scenarios, from lone developers starting up a new Web-based company on a shoestring to large teams of enterprise developers looking for high-performance, highly available, and scalable Web sites,...

Windows Azure and Components

Windows Azure is a cloud based operating system which act as a service provider for cloud platform based application .It provides a cloud based fabric which hosted on Microsoft data center for managing, deploying and distributing application and service .Windows Azure has two main areas of functionality computing and storage.Cloud...

Microsoft SQL Server 2012 New Features Part-2

EOMONTH We have to face problem whenever we are going to identify the end date of month no built in function was there but now that problem has over in SQL Server 2012, EOMONTH return the date of the monthSELECT EOMONTH (‘05/02/2012’) ‘EOM Processing DateOutput: 2012-02-29You can specify number of...

Microsoft SQL Azure

Microsoft SQL Azure Database is a cloud-based relational database service that is built on SQL Server technologies and runs in Microsoft data centers on hardware that is owned, hosted, and maintained by Microsoft. SQL Azure Database does not support all of the features and data types found in SQL ServerSimilarities and Differences<ol><li>Similar...

Multi-tenant Architecture Consideration in Windows Azure

In multi-tenant application single instance is used by users of different organization. Failure impacts all users, Windows Azure reduces the risk giving the facility to deploy multiple, and identical copies of your application into multiple Windows Azure role instances.ScalabilityScalability of web application depends running on Windows Azure mainly depend on...

Windows Azure and cloud computing

Windows Azure is Microsoft’s public cloud computing platform. It’s a place to run your applications out on the internet, at scale. With geographically distributed datacenters worldwide, applications can be built, hosted and managed around the world. With Windows Azure, you can extend and even move your datacenter services off-premises or...

Single-Tenant Vs Multi-Tenant SaaS

In single-Tenant architecture user use dedicated instance of application software hosting on a server and database not shared. In case where same application software is used by different companies having same functionality but do not share same instance and database. Each company uses it’s own instance and database. SAP is...

Cloud Computing Service Model

Cloud computing service model describe what types of service is provided to customer according to their business requirements. Cloud service provides different types of service, there are no hard and fast rules governing these service offerings. Most common services model are as below:IaaS (Infrastructure as a Service) PaaS (Platform as...

Cloud service deployment

Cloud service deployment depends on the business requirement, organizational structure and location. Four deployment models are usually distinguished, namely public, private, community and hybrid cloud service usage.Private Cloud:The cloud infrastructure has been deployed, maintained and operated for a specific organization. The operation may be in-house or with a third party...

Virtualization and Cloud Computing

The Traditional Server Concept In an organization there are many more server resides according to their functionality i.e Active directory Server., Application Server ,Database server ,Mail server ,File server so on … Though there are many types of risk involved there Power fail, Hardware fail, Maintainability problem and Natural disaster....

Plan virtual architectures (SharePoint Server 2010)

<div class="text_exposed_root text_exposed">This article discusses key considerations for planning virtual architectures by using Microsoft SharePoint Server 2010 server roles. This article does not include performance or capacity planning data or recommendations. It describes general guidance for planning virtual environments and includes example architectures for small, medium, and large size farms....