No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Request a new Category
About Sql Server
No topic found
Refine by Author
Satyaprakash Samantaray (17)
Santhakumar Munuswamy (7)
Priyaranjan K S (6)
Pankaj Kumar Choudhary (5)
Pranav Mittal (4)
Amit Kumar (4)
Suvendu Shekhar Giri (4)
Tahseen Jamil (4)
Vimal Lohani (4)
Rafnas T P (3)
Piyush Pansuriya (3)
Pravat Kumar (2)
Vidyadharran G (2)
Anu V (2)
Kumari Reena (2)
Ashutosh Mund (1)
Ramesh Palanivel (1)
Deepak Rao Kumpala (1)
Gnanavel Sekar (1)
Md. Abdulrafay (1)
Vishal S (1)
Deepak Kaushik (1)
Vivek Kumar (1)
N Vinodh (1)
Vishal Jadhav (1)
Yashwant Vishwakarma (1)
Nilesh Sawardekar (1)
Raj Kumar (1)
Jignesh Trivedi (1)
Yogi S (1)
Manish Kumar (1)
Vignesh Ganesan (1)
Daniel Jones (1)
Nitin Pandit (1)
Kailash Chandra Behera (1)
Ahmad Anas (1)
Purushottam Rathore (1)
Jayesh Agrawal (1)
Maunash Jani (1)
Mahesh Chand (1)
Anupam Singh (1)
Prashanth Jayaram (1)
Rathrola Prem Kumar (1)
Nigel Fernandes (1)
Ravi M (1)
Akshay Phadke (1)
Related resources for Sql Server
No resource found
Aborting / Killing A Long Running Stored Procedure
4/28/2017 1:50:23 AM.
Aborting/Killing a Long Running Stored Procedure.
Filter And Get List Of Tables And Stored Procedures Created In The Database Using SQL Query
4/27/2017 12:41:42 PM.
sys.objects has a big role.
"Created Data Time And Collation Name" Of Table And Stored Procedure In SQL Server
4/27/2017 12:40:44 PM.
By executing a SQL query, we can get detailed information about what date and time the table and stored procedure were created.
"EXISTS" Condition In SQL Server To Check Existence Of Tables And Stored Procedures In Real Time Scenario
4/27/2017 12:39:18 PM.
The "exists" condition is used to check if there is any table and stored procedure with that name.
Taking Scripts From SQL Server
4/27/2017 11:19:10 AM.
In this article, you will learn about taking scripts from SQL Server.
Tips To Increase SQL Server Stored Procedure Performance
4/25/2017 4:11:03 PM.
This blog presents tips to increase SQL Server stored procedure performance.
SQL Server 2016 - Getting Started With Row Level Security Feature
4/25/2017 4:00:34 PM.
This article familiarizes you with SQL Server 2016 - Getting started with Row Level Security feature.
Get Database Backup And Restore The Backup File In SQL Server
4/25/2017 3:47:34 PM.
In this article, we are going to learn how to get database backup from SQL Server and how to restore the backup file in SQL Server.
Commonly Used Built In String Functions In SQL Server
4/25/2017 3:44:15 PM.
This article illustrates commonly used built in string functions in SQL Server.
Pivot Operator Using Stored Procedure In SQL Server
4/24/2017 6:07:16 PM.
Pivot is an operator in SQL Server.
Local And Global Temporary Tables Using Stored Procedure In SQL Server
4/24/2017 5:58:46 PM.
Temporary tables are created in TempDB database and are automatically deleted, when they are no longer used.
Case Statement Using Stored Procedure In Real Time Scenarios
4/24/2017 5:48:43 PM.
Case statement is mostly used in Real Time scenarios
Alter Table Columns And Datatypes Without Deleting The Table
4/24/2017 5:46:25 PM.
This article emphasizes that there is no need to delete a whole table. Instead, write SQL query to get this result.
UNPIVOT Operator Using Stored Procedure In SQL Server
4/24/2017 5:40:41 PM.
UNPIVOT operator is the reverse process of PIVOT operator.
SET NOCOUNT ON And SET NOCOUNT OFF Using Stored Procedure In SQL Server
4/21/2017 1:59:04 PM.
This blog illustrates SET NOCOUNT ON and SET NOCOUNT OFF, which are very useful in real time scenarios inside stored procedure in SQL Server.
INSTEAD OF DELETE Triggers And View
4/20/2017 11:13:16 AM.
INSTEAD OF DELETE TRIGGERS are used, to delete records from a view.
INSTEAD OF UPDATE Triggers And View
4/20/2017 11:07:06 AM.
INSTEAD OF UPDATE TRIGGERS correctly update a view.
Upgrading SQL Server When It Is Part Of Availability Group
4/20/2017 10:43:10 AM.
Upgrading SQL Server When It Is Part Of Availability Group.
Microsoft Announces SQL Server 2017, Launches Preview
4/20/2017 7:01:01 AM.
Microsoft today announced the next version of SQL Server named as SQL Server 2017, at the Microsoft Data Amp event.
Delete Duplicate Records From A Table In SQL Server
4/19/2017 5:37:01 PM.
This blog acquaints you with deleting duplicate records from a table in SQL Server, using ROW_NUMBER.
Check NULL Value In SQL Server
4/19/2017 5:34:12 PM.
In this blog, we will learn about NULL value in SQL Server.
INSTEAD OF INSERT Trigger And View In SQL Server
4/18/2017 5:12:21 PM.
INSTEAD OF triggers are usually used to correctly update views that are based on multiple tables.
RANK, DENSE_RANK And ROW_NUMBER Functions In SQL Server
4/18/2017 11:26:16 AM.
RANK, DENSE_RANK And ROW_NUMBER Functions In SQL Server.
Generate Backup And Script File In SQL Server 2014
4/18/2017 9:42:09 AM.
In this article, we going to see about how to generate database backup, create a script file without table value and with the value.
Fetch Only Common Records From Two Tables
4/17/2017 10:17:13 AM.
In this blog, we will see how to fetch common records from two tables in SQL Server, which means the matching records of both the tables will be shown.
Write A Query To Print 1 To 100 In SQL Server Using Without Loop
4/16/2017 9:25:16 AM.
In this blog, we will print 1 to 100 numbers in SQL Server without using while loop.
Occurrence Of Particular Character In String In SQL
4/16/2017 9:22:03 AM.
In this blog, we will calculate occurrence of a particular character in the string.
Using Trigger In SQL Server To Find Out Date, Time, And Host Name of Record Insertion
4/13/2017 11:04:10 AM.
This blog helps you to get the status about inserted records in the respective table by the user in your database.
Update Trigger To Find Out Which Host Name Update Records In What Date Time
4/13/2017 10:57:08 AM.
The trigger will be fired when the host in SQL Server will update any data.
Delete Trigger To Find Out Which Host Name Delete Records In What Date Time
4/13/2017 10:56:22 AM.
The records deleted what Date Time and the Host Name can be identified.
Triggers In SQL Server
4/13/2017 10:47:05 AM.
This article helps you understand the usage of triggers in SQL Server.
SQL Server - HA Technologies
4/13/2017 10:28:47 AM.
This article presents an overview of High Availability (HA), which is the solution\process\technology to make the Application\database available 24x7 under either planned or un-planned outages.
How To Create Simple SSRS Report
4/11/2017 7:00:45 PM.
This article presents an overview on how to create a simple SSRS report.
SQL Server - Services
4/11/2017 6:52:04 PM.
MS SQL Server provides services which are mandatory for database creation and maintenance. This article shows how to start and stop Services, using different types of methods.
Provision Of SQL Server And Connect By RM In Azure
4/11/2017 6:27:27 PM.
This article portrays provision of SQL Server and Connect by RM in Azure.
Configure SQL Server And Connect DB Engine From Another PC
4/11/2017 1:23:03 PM.
This article presents an overview of configuring SQL Server and connect DB Engine from another PC.
SQL Server - Assign Permissions
4/9/2017 12:04:04 PM.
This blog helps in providing permissions, which refer to the rules governing the levels of access.
SQL Server - Union Vs. Union All - Which Is Better For Performance
4/6/2017 5:30:29 PM.
This blog emphasizes the significance of Union vs. Union All.
Creating And Using SQL Server And SQL Database
4/1/2017 12:52:12 PM.
This article helps you in creating and using SQL Server and SQL database.
Server Side Pagination Using AngularJS, Web API And SQL Server
3/25/2017 12:10:19 AM.
In this article, we are going to learn how to do Server side pagination with the help of AngularJS, Web API and SQL Server.
Create, Configure And Use SQL Server Database Using Microsoft Azure
3/24/2017 7:59:47 AM.
In this blog I had explained how to create, configure and SQL Server database in Microsoft Azure.
Implementing Transparent Data Encryption In Always On
3/21/2017 3:31:14 PM.
Implementing Transparent Data Encryption In Always On.
Working With SQL Server R Services And R Scripts In SQL Server 2016
3/17/2017 6:06:43 PM.
Working with SQL Server R Services and R Scripts in SQL Server 2016.
Implement Column Level Encryption/ Decryption In SQL Server 2016
3/17/2017 1:18:42 PM.
This article familiarizes you with implementing column level encryption/decryption in SQL Server 2016.
Resolving "Cannot Install SQL Server 2014 Service Pack 2" Error
3/16/2017 4:43:17 PM.
Resolving "Cannot Install SQL Server 2014 Service Pack 2" Error.
Differentiate Connections With Colored Status Bars
3/15/2017 4:18:07 PM.
This is about an old but under utilized feature of SSMS to differentiate connections using colored status bars.
Importing FoxPro DBF File Data In SQL Server Database
3/15/2017 1:32:31 AM.
In this article, you will learn how to import FoxPro DBF File Data in SQL Server database.
Consume REST Service From PowerShell And Update The JSON Data To SQL Server Table
3/14/2017 4:16:25 PM.
Consume REST Service From PowerShell And Update The JSON Data To SQL Server Table.
Microsoft Releases ODBC Driver 13.1 For SQL Server
3/8/2017 2:19:36 AM.
This news elaborates about the release of ODBC Driver 13.1 for SQL Server, and its new features.
How to import Excel data in SQL Server 2014
3/7/2017 10:56:16 AM.
In this article, you will learn how to import data from Excel file into SQL Server database.
Getting Started With SSRS 2016 - Part Five
3/6/2017 2:56:52 PM.
In this article, we will discuss how we can create a Shared Data Sources in SQL Server Reporting Services 2016. We have already discussed how to create a Matrix report , using Report wizard, how to de
Configure SQL Server Session State In ASP.NET Core
3/3/2017 4:30:27 PM.
This article describes the steps required to enable SQL Server as a storage mechanism for session state in an ASP.NET Core MVC Application.
Getting Started With SSRS 2016 - Part Four
3/1/2017 1:24:16 PM.
In this article, we will discuss how we can create a Matrix report, using Report wizard in SQL Server Reporting Services 2016.
How To Restore Northwind Database In SQL Server In One Minute
3/1/2017 11:41:14 AM.
To use Northwind database in your SQL Server, you need to restore it. In this tutorial, I will explain all the restore database steps through the images.
How To Create A Shared Data Source In SSRS 2016
2/28/2017 11:15:20 PM.
In this blog, we will discuss how we can create a shared Data Source in SQL Server Reporting Services 2016.
Enhanced ScrollBar In SQL Server 2016
2/26/2017 5:47:08 PM.
In this blog, you will get acquainted with the enhanced scroll bar introduced in SSMS (SQL Server Management Studio) 2016.
SQL Server 2016 - Bulk Import JSON File Data To Table
2/25/2017 12:41:28 PM.
In this article, you will learn about how to bulk import JSON file data to tables in SQL Server 2016.
Retain Carriage Return And Line Feeds On Copy Or Save In SQL Server 2016
2/23/2017 1:10:49 PM.
Retain Carriage Return and Line Feeds on Copy or Save in SQL Server 2016 (SSMS) like earlier versions.
SQL Server Migration Assistant (SSMA) v7.3 Released
2/22/2017 11:22:13 AM.
Microsoft released the SQL Server Migration Assistant (SSMA) v7.3 using which users can now migrate their data more easily to MS SQL Server from a variety of databases.
Get Specific Column Name In All Databases Except System Database
2/21/2017 3:12:53 PM.
Get your particular column name in all the databases except System database.
Getting Started With SSRS 2016 - Part Three
2/21/2017 1:49:10 PM.
In this article, we will discuss how we can create a table report without using report wizard in SQL Server Reporting Services 2016.
Microsoft Releases Public Preview for SQL Server Management Packs Update (184.108.40.206)
2/21/2017 1:33:56 PM.
Microsoft has recently updated its SQL Server Management pack, and it is now available as public preview.
Create Or Alter In SQL Server 2016
2/19/2017 11:47:17 AM.
In this blog, you will learn how to create or alter in SQL Server 2016.
PowerShell Script To Configure SQL Server Reporting Services In SharePoint Mode
2/18/2017 1:30:51 AM.
In this blog you will learn about PowerShell Script to configure SQL Server Reporting Services in SharePoint Mode.
FirstValue In SQL Server 2012
2/17/2017 10:44:31 AM.
In this blog, you will learn about FirstValue in SQL Server 2012.
Introduction To Mount Point In SQL Server
2/17/2017 10:25:44 AM.
This article will give you brief information on SQL Server Mount Point and its benefits and you will learn how to set up a new partition.
Monitoring TempDB Space Usage On SQL Server
2/14/2017 4:49:48 AM.
In this blog, you will learn about monitoring TempDB space usage.
Getting Started With SQL Server 2016
2/12/2017 10:15:35 AM.
In this article, we will discuss in detail about SQL Server 2016, the list of features available in SQL Server 2016, prerequisites, setting up the environment, and more.
Most Asked SQL Server Interview Questions and Answers
2/10/2017 4:59:28 AM.
In this article you will learn about the most asked SQL Server Interview questions.
CUMEDIST Analytic Functions In SQL Server 2012
2/9/2017 1:30:15 PM.
In this blog, you will learn about CUMEDIST analytic functions in SQL Server 2012.
Get Distance Between Two Points
2/8/2017 11:29:05 AM.
In this blog, we will learn how to calculate the distance between two points on the Earth's surface.
Overview Of Table Variable In SQL Server
2/8/2017 11:23:22 AM.
In this blog, you will learn about table variable in SQL Server.
Create Database Diagram Using Stored Procedure And SQL Server 2012 In Your Real Time Project
2/7/2017 10:56:01 AM.
In this blog, you will learn how to create a database diagram, using stored procedure and SQL Server 2012 in your real time project.
Bind Data In WebGrid Control Using Stored Procedure In ASP.NET MVC 4.0 And SQL Server 2012
2/6/2017 11:38:57 AM.
In this article, you will learn how to bind the data in WebGrid control, using stored procedure in ASP.NET MVC 4.0 & SQL Server 2012.
Subscribing and Connect Microsoft Azure With SQL Server
2/5/2017 11:24:54 PM.
This brief article will show you how to connect with SQL Server Database in Microsoft Azure.
Microsoft Releases SQL Server Data Tools 17.0 RC 2
2/3/2017 1:57:37 AM.
SQL Server Data Tools 17.0 Release Candidate 2 (RC 2) has been released, and you can now easily download and install it.
Find Collation Name For DataBase And Columns In SQL Server
2/2/2017 3:16:02 PM.
In this blog, we learn how to get collation name of a particular database and columns of a table.
OFFSET- FETCH Clause In SQL Server 2012
2/2/2017 3:13:08 PM.
In this blog, you will learn about OFFSET-FETCH clause in SQL Server 2012.
Microsoft Releases Kerberos Configuration Manager For SQL Server v3.1
2/1/2017 11:25:41 AM.
Microsoft announces the general availability (GA) of its latest Kerberos Configuration Manger for SQL Server.
MySQL - Best Practices
1/30/2017 10:45:50 AM.
In this blog, you will learn about MySQL best practices.
Working With Identity Column After Table Creation In SQL Server
1/30/2017 10:11:05 AM.
In this article, you will learn about working with an identity column after table creation in SQL Server.
Auto Increment ID Column Using nvarchar DataType In SQL Server
1/29/2017 12:45:31 PM.
In this blog you will learn about Auto Increment ID Column using nvarchar DataType in SQL Server.
Getting Started With SSDT 2016 Using Visual Studio 2015
1/27/2017 12:37:43 AM.
In this article, we will discuss in detail about how to get started with SSDT 2016.
Getting Started With SSRS 2016 - Part One
1/27/2017 12:36:10 AM.
In this article, we will discuss how we can create an SSRS Report without using Report Wizard in SQL Server Reporting Services 2016.
SQL Server v.Next CTP Available Now
1/24/2017 3:04:09 PM.
SQL Server v.Next CTP 1.2 is available now.
SQL Server v.Next Early Adoption Program Announced
1/21/2017 3:20:23 PM.
The Microsoft SQL Server team has announced that it is starting a new SQL Server Early Adoption Program (SQL EAP) from January 2017.
Getting Started With OpenLayers 3 And Spatial Data
1/18/2017 12:47:01 AM.
In this article I am going to give you a jump start to visualize spatial data using OpenLayers. In the demo I will be using SQL Server 2008 and OpenLayers 3.
Resolving "100 percent CPU Usage" Problem In SQL Server
1/17/2017 1:14:17 PM.
In this blog, you will learn how to resolve the 100 percent CPU usage problem in SQL Server.
How To Backup And Replace Text In All Search String Matching Stored Procedure(S)
1/15/2017 12:16:47 PM.
In this blog, you will learn how to backup and replace text in all search string matching stored procedure(s).
Resource Heat Map In Project Server 2013
1/14/2017 3:09:46 PM.
In this blog, I will show you how to calculate working & non-working days of resources.
Recover Deleted Data On SQL Server
1/14/2017 3:09:09 PM.
In this blog, you will learn how to recover the deleted data on SQL Server.
Experiment With Nth Highest Or Lowest Salary Or Record In SQL
1/13/2017 11:33:05 AM.
In this blog, you will learn about the Nth highest or lowest record in SQL.
Certain Windows Updates Disable SQL Server Instances
1/12/2017 11:49:15 AM.
I have noticed that after doing a Windows Update in Windows 10 , it sometimes disables SQL Server instances. I have provided a fix for it.
Cycle Clipboard Ring In SSMS
1/12/2017 11:47:57 AM.
In this blog, we will learn about the Cycle Clipboard Ring feature of SQL Server Management Studio.
SSRS - Download All Report Files Or Single (RDL) From ReportServer
1/12/2017 11:23:30 AM.
In this blog, you will learn how to download all report files or single (RDL) from ReportServer.
MSSQL Extension For Visual Studio Code
1/11/2017 11:25:00 AM.
In this article, you will learn about MSSQL extension for Visual Studio Code.
How To Use Grouping In SSRS
1/10/2017 10:15:53 AM.
In this article, you will learn how to use grouping in SSRS.
Microsoft releases PHP Linux Driver 4.0 for SQL Server
1/10/2017 9:38:09 AM.
Microsoft announces PHP Linux Driver 4.0 for SQL Server.
Compile Queries And Execute SQL Queries Using LINQ To SQL
1/8/2017 11:18:03 PM.
In this article, you will learn how to compile queries and execute SQL queries, using LINQ to SQL.
MAXRECURSION Option In CTE
1/8/2017 2:15:10 PM.
In this article, you will learn about MAXRECURSION option in CTE.