Thursday , December 14 2017

sql server query pagination

From SQL Server 2012, Microsoft introduced a couple of T-SQL Enhancements. One of them is Query Pagination. In most of the applications, a common requirement is how to fetch the data from the database servers as page wise. In earlier versions of SQL Server like SQL Server 2005/2008/R2, we can implement …

Read More »

Visual Studio 2017 Poster

Visual Studio thought it would be fun to put together a poster(Visual Studio 2017 Poster) that shows off some of favorite parts of Visual Studio 2017. You’ll also see some helpful tips and tricks to improve your productivity! Visual Studio 2017 Poster: download Visual Studio download poster as pdf   …

Read More »

How to find locked tables in sql server

Locked Tables

In multiuser environments, sql server ensures the integrity of the data by setting write locks on all the tables(Locked tables) when you are updating. This prevents other users from making changes to the same tables. if the table is locked we cannot do any CRUD(insert/select/update/delete) operations on table until it …

Read More »

What’s New in Visual Studio 2017

what's new in visual studio 2017

What’s new in Visual Studio 2017: Microsoft happy to announce the release of Visual Studio 2017. This release brings a new lightweight and modular installation experience which can be tailored to your needs. by using Visual Studio 2017 to develop apps for Android, iOS, Windows, Linux, web, and cloud. Code …

Read More »

sql server Startup Options in SSMS

sqlserver_startupoptions

Normally, after opening up SSMS and once logged in we will Open up a new query window manually to write our scripts but by configuring SSMS startup options we can open new query window or object explorer etc after logged into SSMS immediately Under the Options -> Startup -> At …

Read More »

Free ebook: Creating Mobile Apps with Xamarin.Forms

Xamarin ebook

Xamarin is a Microsoft-owned San Francisco, California-based software company founded in May 2011 by the engineers that created Mono, Mono for Android and MonoTouch, which are cross-platform implementations of the Common Language Infrastructure (CLI) and Common Language Specifications (often called Microsoft .NET). With a C#-shared codebase, developers can use Xamarin tools to …

Read More »

dbForge Studio for SQL Server – Ultimate SQL Server Manager Tool from Devart

dbForge-Studio-for-SQL-Server

dbForge Studio for SQL Server is a powerful IDE for SQL Server management, administration, development, data reporting and analysis.The tool will help SQL developers to perform complex database changes, version-control database changes in popular source control systems, and speed up routine tasks. dbForge Studio for SQL Server Features Overview: Devart’s …

Read More »
Page 1 of 12
1 2 3 12