Sql Server Resources

Share

Related resources for Sql Server

Using Stored Procedures with ASP.NET11/9/2023 6:53:02 PM. This article helps you to create a stored procedure on SQL Server and tells you how to use them in your asp.net applications.
Use SQL Server 2017 in Docker Containers11/6/2023 6:07:14 PM. How to use SQL Server 2017 on Docker containers to automate deployment using VSTS
Introduction To SQL Server Dynamic Data Masking3/4/2021 11:33:45 AM. In this video, we will discuss SQL Server Dynamic Data Masking feature to hide\mask sensitive data.
What is new in Agular 10 release4/20/2020 9:31:53 AM. JS frameworks and headless CMS are a bit like cereal boxes. Eventually, you just got to pick one — the right ones, if possible.
Introduction To SQL Server Pagination1/22/2018 12:12:44 AM. In this video, we will look into retrieving records in page wise from SQL Server using OFFSET-FETCH statement.
Stored Procedures Vs User Defined Functions And Choosing Which One To Use1/16/2018 1:46:00 AM. In SQL Server, we usually come across queries, tables, views, stored procedures and functions. People often wonder what are the real differences between User Defined Functions (UDF) or simply function
Comparison Of Subquery And Joins1/15/2018 1:07:19 PM. Here, in this article, we are comparing the SQL Join and SQL Subquery.
Why Dynamic Query Is Bad1/15/2018 12:55:21 PM. In this article, we will be talking about Dynamic Query and why it is bad.
Look At SQL Server Encryption - Part I1/5/2018 1:08:46 AM. In this video, we will look at SQL Server encryption followed by a demo where we will encrypt a column in the table.
FILESTREAM Feature In SQL Server1/4/2018 12:06:55 PM. Today I am explaining what FILESTREAM is and how to use FILESTREAM in SQL server.
R Services In SQL Server 20171/2/2018 7:08:35 PM. Hello Everyone. In this article I will be demonstrating how to use R Services in SQL Server 2017. This article is intended for those who have a basic idea of R language. If you don't, still no wor
Configure Data Gateway With SQL Server Database Using Recommended Or Enterprise Mode12/23/2017 12:10:26 PM. In this article, we will discuss how we can configure Data Gateway for On-Premise SQL SERVER Database for Live Data Connection using Recommended Mode.
Export SQL Result To A Text File12/18/2017 12:30:57 PM. This article gives an overview of how to export SQL query results to a text file.
Remove Duplicate Rows In SQL Server Using CTE12/11/2017 7:26:50 PM. In this article, you will learn how to remove duplicate rows in SQL Server using CTE.
Audit Made Easy Without Audit Log - Part One12/7/2017 11:54:51 AM. In Microsoft SQL Server, the activity of each of the database table is tracked in the other table and that is called the Audit trail or Audit log of the database table.
How To Create A Stored Procedure In SQL Server Management Studio11/25/2017 1:13:40 PM. In this article you will learn about how to create store procedure in sql server’s SQL SERVER MANAGEMENT STUDIO and very informative information and interview questions and answers about store procedu
Introduction To SSIS11/24/2017 3:55:03 PM. SSIS stands for SQL Server Integration Services. It is one of the services of SQL Server and was introduced for the first time in SQL Server 2005. It’s a powerful replacement for the legacy DTS (Data
Introduction To SQL Operations Studio And Connecting It With SQL Server11/21/2017 5:44:31 AM. Learn how to use SQL Operations Studio (preview) to connect to SQL Server, and then use Transact-SQL (T-SQL) statements.
Creating A SQL Database And SQL Server On The Azure Portal11/20/2017 10:10:01 AM. This article shows how to create a SQL Database and Server on the Azure Portal and also the process of configuring the threat protection to our Database.
Always Encrypted In SQL Server 2016 - Step By Step Guide - Part Three11/16/2017 11:03:33 PM. This is part three of "Always Encrypted In SQL Server 2016 - Step By Step Guide" series. In this article, we are going to see how to search on encrypted column and how to deploy a certificat
Auto Complete with ngTagInput using Web API in AngularJS11/16/2017 10:54:11 AM. AutoComplete,ngTagInput,Web API,AngularJS,AutoComplete in AngularJS using Web API
SSMS 2016 - Enhanced Scrollbar11/15/2017 5:56:25 AM. Detailed description with screenshots of the enhanced scroll bar introduced in SSMS (SQL Server Management Studio) 2016.
DROP IF EXISTS In SQL Server 201611/13/2017 3:18:31 PM. With this very small but handy tip, we’ll check the enhancement that has been made to DROP statement in SQL Server 2016. Earlier, we used to write additional checking logic to make sure that the objec
Masking Sensitive Data With SQL Server 201611/11/2017 5:59:13 AM. SQL Server 2016 has many features which you can use to make your data and application more secure, more maintained and easily retrieved as per your requirements. It has introduced both client side sec
Introduction Of New Useful Features In SSMS 201611/10/2017 12:25:37 PM. This article is an effort to list out a few exciting improvements that have been made to SQL Server Management Studio 2016. I believe, most of these new features can help improve the speed of our work
Configuring SQL Server 2016 Express On LAN For C# Connection String11/8/2017 11:26:20 AM. In this article I will share my experience about configuring SQL Server 2016 Express on LAN for SQL connection using my C# application’s connection string
ASP.NET Web API And SQL Server11/7/2017 5:39:00 AM. In this article, you will learn about ASP.NET Web API and SQL Server.
Step By Step Guide To Setup Sample SSAS Multi Dimension Cube11/6/2017 11:28:31 PM. Create one Windows account and give full access to that account to read OLTP database or add an account on which SSAS Service is running and give full permission to that account for OLTP Database.
SQL Server 2016 - How To Detect The Current Cumulative Update/Service Pack That Was Installed11/6/2017 11:33:52 AM. In this article, I will explain how to detect the current Cumulative Update / Service Pack installed on your SQL Server.
User-Defined Types In SQL Server10/29/2017 6:08:58 AM. When we are working with any programming language, we create user defined types as per our requirement. It is a better idea to have this feature in the SQL server.
Always Encrypted In SQL Server 2016 - Step By Step Guide - Part Two10/14/2017 5:42:54 AM. This is part two of "Always Encrypted In SQL Server 2016 - Step By Step Guide" series. In this article, we are going to see the sample queries on encrypted columns and Limitations of Always
T-SQL - Retrieve Task Hierarchy In Project Server10/12/2017 11:10:01 AM. In this article, we will show how to get the Task Hierarchy for a Specific Project in Project Server Database using SQL
Always Encrypted In SQL Server 2016 - Step By Step Guide - Part One10/6/2017 1:40:39 PM. Lets say, we have a requirement to encrypt the PII data for an existing ASP.NET web application. Data needs to be encrypted at rest as well as on transit. Considering the existing PROD data, we need t
How To Secure PII Data In SQL Server Using CLE (Column Level Encryption)10/3/2017 5:35:21 PM. PII (personally identifiable information) which is used to identify individual identity such as SSN, DOB, Bank Account Number etc. When you are working with financial application you face the scenario
Data mining and SQL Server 200510/3/2017 6:24:09 AM. Data mining is a key member in the Business Intelligence (BI) product family in SQL Server 2005 . Data mining is about analyzing data and finding hidden patterns using automatic or semiautomatic means
Data mining and SQL Server 200510/3/2017 6:24:09 AM. Data mining is a key member in the Business Intelligence (BI) product family in SQL Server 2005 . Data mining is about analyzing data and finding hidden patterns using automatic or semiautomatic means
Concept Of Views In SQL Server9/23/2017 12:31:13 AM. In this article you will learn about the concept of views in SQL Server.
How To Secure PII Data In SQL Server Using .NET Assembly9/21/2017 11:53:17 PM. PII (Personally Identifiable Information) is used to identify individual identity markers such as SSN, DOB, Bank Account Number etc. When you are working with financial applications you face a scenari
35 Essential Basic-Advanced SQL Query-Questions Asked In Technical Interviews9/19/2017 2:12:56 PM. These are all query-based questions asked in tech interviews, including some simple looking tricky one liner SQL statements and joins.
Encrypt And Decrypt User Password In SQL Server DB Using C# Winform Application9/18/2017 5:10:07 PM. In this article we are going to learn how to maintain the user login details in sql server table with password encryption format and decrypt the user password and validate the credentials in login for
Convert Rows To Columns Using Dynamic Pivot In SQL Server9/17/2017 1:34:22 PM. In this article, we will show how to convert rows to columns using Dynamic Pivot in SQL Server.
Create Log Backup Maintenance Plan In SQL Server 20169/17/2017 1:25:00 PM. In this article, we will explain how to take log backups frequently by creating a Log Backup Maintenance Plan in SQL Server 2016
SQL Server DB Backup Using Stored Procedure In WinForm Application9/14/2017 11:13:59 AM. In this article we are going to learn how to get database backup using stored procedure in SQL server in C# Winform applications.
How Should We Store Images And Blob Files In SQL Server9/7/2017 4:04:38 PM. There is always a requirement from developers: How should I store images and BLOB files in SQL Server ? In this post let's explore the data types and methods used for storing Binary Large Objects
Find Out Creation And Modification Date Of Database Objects Like Tables And Stored Procedures9/7/2017 2:01:32 PM. Database Object refers to Table, Stored procedure, View, Function etc.; in other words, all the elements that are created for data storage and manipulation.
How To Consume Web API Through SSIS Package9/7/2017 1:22:01 AM. In this article, I have illustrated the purpose of SSIS with Web API. It shows how SSIS can use Web API to do certain operations, like updating the database table based on Service response, and proces
New String Function In SQL Server 20179/6/2017 4:43:54 PM. It requires one separator argument and a minimum of two arguments otherwise it raises an error. All the arguments are implicitly converted to string types and then they are concatenated.
How To Backup A Mirrored Database Using SQL Agent9/4/2017 4:57:00 PM. Database mirroring is a primarily software solution for increasing database availability. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery mode
Working With JSON In SQL Server 20168/28/2017 4:35:33 PM. JSON (JavaScript Object Notation) is a lightweight data interchange format. It is language independent, easy to understand and self-describing. It is used as an alternative to XML. JSON is a very popu
New Features In SQL Server 20178/28/2017 1:32:25 AM. There are many new features introduced with SQL server 2017 and also there is some performance improvement in existing features. Using the following links, we can learn more details about the new feat
Creating Login Form For Users With Image Uploading For Password Recall8/27/2017 10:53:05 AM. The article is an alternate method of creating a login form where the conventional way of giving a password hint will be given as a question. In this, you can add an image which can be your hint if yo
Load Twitter Data Into SQL Database8/15/2017 10:44:40 AM. The requirement is to extract the data from Twitter and load extracted data into SQL Database. For this demonstration I am going to read the Indian Film actor Kamal Haasan's tweets and load that
Record Table Changes Notification From SQL Server To WPF Client8/9/2017 1:10:56 AM. This article shows how to push record table changes to WPF clients using WCF Call Back Service.
Create SQL Server Database Project With Visual Studio8/8/2017 8:24:37 PM. In this article, we’re going to learn about how to we can manage our database scripts using Visual Studio’s SQL server database project.
Learn AWS With MS-SQL(DB) Using SQL Client8/8/2017 12:51:07 AM. You want to login to the AWS console here. If you have no login register new users in here. After registering amazon will provide one year free access.
How To Determine The Version And Edition Of SQL Server And Its Components8/6/2017 5:19:58 PM. For Business Intelligence features such as Integration Services, Reporting Services, and Analysis Services, you may have to install the latest service packs, cumulative updates, and hotfixes on the cl
Find The 3rd Or Nth Highest Salary In A Table Via SubQuery8/1/2017 2:03:54 AM. This article describes how to find the 3rd or Nth highest salary in a table. To find the Nth highest salary, we need to create a table in the database containing some data and to do this use the follo
Creating And Managing Stored Procedure In SQL Server 20087/27/2017 8:02:33 AM. In this article you will learn how to Create and Manage Stored Procedure in SQL Server 2008.
Combination Of Id-ParentId And HierarchyId Approaches To Hierarchical Data7/26/2017 11:09:41 AM. How to combine the Id-ParentId and HierarchyId approaches to keep and fetch the data in hierarchical and alphabetical order.
Creating An Azure SQL Database And Connecting Through SQL Server Management Studio7/23/2017 11:59:20 AM. This article demonstrates how to create an azure SQL Database, setting the Firewall rule and connecting through the SQL Server Management Studio.
Taking Script From Database In SQL Server In Different Mode7/17/2017 5:52:45 PM. This article explains how to take the script from database in SQL server in a different mode. Normally we take back up our entire database as “.bak, .mdf, .ldf” file but sometimes we need to alter, up
Create SSRS Drilldown Report7/17/2017 2:12:58 PM. Create SSRS drill down report, add link enable/disable based on specific condition, adding download links in reports.
Mirroring Database In SQL Server7/12/2017 12:17:06 PM. When there is any automatic failure we need another server that will monitor the principal server.
Creating And Using Azure SQL Server And Azure SQL Database7/9/2017 1:36:31 AM. This article helps you in creating and using SQL Server and SQL database.
Monitoring Our Database When Accessing From Outside Or Applications In SQL Server7/8/2017 12:36:26 PM. This article explains how to monitor our database when accessing from outside or any other applications in an easy way.
Difference Between Stored Procedure And User Defined Function In SQL Server7/6/2017 7:52:16 AM. This article describes the differences between Stored Procedures and User Defined Functions in SQL Server.
Installing SQL Server vNext On Linux - Part Two7/5/2017 12:27:10 AM. With the release of Microsoft SQL Server on Linux, it is a huge step towards gaining markets in Database Technologies giving competition to other RDBMS software. Microsoft SQL Server is not only on Wi
Row Number Function in SQL Server6/27/2017 7:11:59 AM. This article explains the row number function in SQL Server. Ranking functions provide a very good feature of assigning numbering to the records in the result set in SQL. Row_Number is one of these fu
Rank Function in SQL Server6/27/2017 7:11:17 AM. This article explains the Rank function. Ranking functions provide a very good feature of assigning numbering to the records in the result set in SQL. Row_Number is one of these functions available in
Triggers in SQL Server6/26/2017 6:51:18 AM. This article explains triggers in SQL Server. A trigger is a special kind of Stored Procedure or stored program that is automatically fired or executed when some event (insert, delete and update) occu
Indexes in SQL Server6/26/2017 5:01:31 AM. This article describes indexes in SQL Server. Indexes are used in relational databases to quickly retrieve the data.
Over Clause in Sql Server (Windows on Data): Part 16/26/2017 1:55:15 AM. This article explains how the Over clause works. Windowing in SQL Server is done by the over clause that was introduced in SQL Server 2005. Windowing of data in SQL Server or the window function is ap
Installation of SQL Server 20056/26/2017 1:38:08 AM. Using Windows 7 Ultimate, after installation of SQL Server 2005, an error occurrs regarding Connection. (Settings for Database Engine) Login failed for user Admin\vilas. (Microsoft SQL Server, Error :
Daily Shrink Database Log Automatically Using Jobs In SQL Server6/24/2017 11:40:26 AM. This article explains how to shrink database log daily using jobs in SQL server by step by step. We can shrink database logs automatically using jobs in SQL Server that we no need to run SQL Script ma
View in SQL Server6/23/2017 7:32:08 AM. In this article, I describe Views in SQL Server. Views are database objects which are like virtual tables that have no physical storage and contains data from one table or multiple tables.
Role in SQL Server6/23/2017 5:54:40 AM. In this article I described Role in SQL Server. Roles are a collection of permissions or access rights for providing permissions or privileges easily in a large database system with multiple users.
SQL Executer6/22/2017 4:30:26 AM. Here you will see how to use SQL Executer. The article is written for beginners, the methods to communicate with database are kept simple.
Automatic Daily Database Backup To Specific Database In SQL Server6/21/2017 6:12:46 PM. Automatic Daily Database Backup To Specific Database In SQL Server.
Xamarin.Android - List View Using SQL Server Database6/21/2017 6:07:59 PM. In this article you will create a Xamarin Android List View using SQL Server.
CRUD Operation Using Stored Procedure In ASP.NET GridView Real Time6/16/2017 4:19:40 PM. A GridView is a graphical control element that presents a tabular view of data.
To Get All File Details From Local File Into SQL Server6/15/2017 12:28:37 AM. TO Get All File Details From Local File Into SQL Server.
Concept Of Change Data Capture (CDC) In SQL Server - Part Three6/13/2017 11:36:49 AM. Concept Of Change Data Capture (CDC) In SQL Server.
Concept Of Change Data Capture (CDC) In SQL Server - Part Two6/12/2017 5:22:18 PM. Concept Of Change Data Capture (CDC) In SQL Server.
Concept Of "Change Data Capture" (CDC) In SQL Server - Part One6/9/2017 1:46:03 PM. Concept Of Change Data Capture (CDC) In SQL Server 2008.
Top Ten Things You Should Know About Optimizing SQL Server Performance - Part Two6/8/2017 11:26:13 AM. Top Ten Things You Should Know About Optimizing SQL Server Performance.
Top Ten Things You Should Know About Optimizing SQL Server Performance - Part One6/7/2017 12:10:18 PM. Top 10 Things You Should Know About Optimizing SQL Server Performance.
Pros And Cons Of Money DataType6/2/2017 6:14:41 PM. Pros And Cons Of Money DataType.
ALL In One DataBase Hero Script - Set One6/1/2017 11:07:34 AM. ALL In One DataBase Hero Script.
Time And Date Query Code And Analysis - Part One5/31/2017 5:37:34 PM. Time and Date query code and analysis.
Transparent Data Encryption In SQL Server5/31/2017 5:32:15 PM. Transparent Data Encryption in SQL Server.
Analyzing The Size Of Database And Size Of Table5/31/2017 4:33:55 PM. Analyzing The Size Of Database And Size Of Table.
How To Create Login Page In ASP.NET Web Application Using C# And SQL Server5/31/2017 12:44:02 PM. How to create login page In ASP.NET Web Application using C# and SQL Server.
How to Create Login Form in Visual Studio and Connect With SQL Server5/31/2017 4:18:20 AM. This article explains how to create a login form in Visual Studio and connect with SQL Server.
Select, Insert, Update, Delete Using Stored Procedure in SQL Server 20085/31/2017 2:38:59 AM. Here, we will see how to create select, insert, update, delete statements using stored procedure.
Identifying Relationship Between Columns In SQL5/30/2017 1:27:27 PM. Identifying relationship between columns in SQL.
How To Create A Solution And What Its Uses Are5/25/2017 6:35:36 PM. How to create a Solution and what its uses are.
All About Primary Key And Its Basics5/24/2017 12:27:49 AM. All About Primary Key And Its Basics
Google Map Using SQL Server Stored Procedure In ASP.NET MVC 55/23/2017 12:55:31 PM. I will show you how to show markers on places like country, state, continent etc., using stored procedure.
Move SQL Server Database To Another Location - Lesson Learned5/22/2017 11:31:33 AM. Fix: Unable to open the physical file. Operating system error (Access is denied.). In this article, we'll learn the best practice of moving database to another physical location on the Server.
High Availability And Disaster Recovery In SQL Server - A Quick Note5/20/2017 12:36:29 AM. High Availability And Disaster Recovery - A Quick Note.

Topics