Server 2012 Resources

Share

Related resources for Server 2012

Contained Database - No Need For Server Level Logins Anymore3/28/2024 10:34:38 AM. Starting in SQL Server 2012 and in Azure SQL Database, Microsoft introduced the concept of a contained database. A contained database is a database that is completely un-reliant on the instance of SQL
How to Install and Configure IIS 8 on Windows Server3/15/2024 6:51:03 AM. In this article, you will learn about how to install and configure IIS8 (Internet Information Services 8) on Windows Server 2012.
Bind Data In WebGrid Control Using Stored Procedure In ASP.NET MVC 4.0 And SQL Server12/7/2023 9:19:11 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.
Passing Table to a Store Procedure in SQL Server9/15/2023 9:32:59 AM. In this article, I described how to pass a table to a Stored Procedure parameter in SQL Server.
DATEADD Function in SQL Server9/14/2023 6:07:54 AM. In this article, I would like to show the Dateadd Function in SQL Server.
How To Configure SMTP O365 Migration Using TLS 1.2 For SQL Database Mail7/6/2023 4:49:23 AM. This article will explain to you how exactly you need to configure TLS 1.2 as a default protocol and setup SMTP O365 migration using SQL 2012 Database mail and above versions for Windows Server 2012 a
Copy Table With Data From One Database to Another in SQL Server 20122/28/2023 7:10:38 AM. This article demonstrates how to copy a table with data from one database to another in a SQL Server database.
Interesting Facts Behind the Origin of SQL Server Code Names2/15/2023 8:17:47 AM. This article will enhance your knowledge of some hidden names of SQL Server and where they came from.
Cast() and Convert() Functions in SQL Server1/20/2023 10:00:52 AM. In this article, we will see how to use the cast and convert functions in SQL Server 2012.
Cascading Referential Integrity Constraint in SQL Server1/17/2023 9:34:22 AM. This article will give you an idea of how to use SQL Cascading Constraint and also defines the situations where you can use it.
Magic Tables Used by Triggers in SQL Server 12/30/2022 10:12:06 AM. In this article I have described the magic tables and how to use magic tables in SQL Server.
Temporary Tables in SQL Server12/30/2022 1:14:26 AM. In this article, I am going to give a quick overview of temporary tables in SQL Server. local temporary table, global temporary table, drop temporary table.
Static Cursor in SQL Server12/21/2022 5:42:18 AM. In this article, you will see how to use a Static Cursor in SQL Server.
Grant and Revoke Command in SQL Server12/18/2022 6:10:42 PM. Grant SQL statement grants permissions on an object to a user. Revoke removes permissions on an object. In this article, learn about Grant and Revoke in SQL Server.
How to Create a New Group in Windows Server 201210/24/2019 3:17:48 AM. This article explains how to create a new group in Windows Server 2012.
On vs Where Clause in SQL Server 20127/18/2019 6:29:30 AM. Here, I will explain the difference between the On and Where clauses when used with a left join in SQL Server.
QUOTENAME Function in SQL Server 20127/18/2019 12:33:55 AM. QUOTENAME Function is used to add square brackets to the starting and ending of a string and how to store strings in various formats in SQL Server.
Creating Check Constraint on a Table in SQL Server 20127/17/2019 3:45:44 AM. This article will give you an idea of how to use the SQL Server Check Clause and also defines where you can use it.
Static Cursor, Dynamic Cursor, and Keyset-Driven Cursor in SQL Server7/15/2019 6:34:56 AM. In this article, I describe Static Cursor, Dynamic Cursor, and Keyset-Driven Cursor.
Calculating Factorial of a Number in SQL Server 20127/15/2019 4:16:13 AM. Here, I have constructed a query that provides a solution in SQL Server to determine the factorial of a specified number.
UNICODE and NCHAR Functions in SQL Server 20127/15/2019 12:10:13 AM. Here, I am going to explain some basics of UNICODE data types and functions in SQL Server.
Full Text Indexing in SQL Server 20127/14/2019 11:58:24 PM. In this article, we will see how to set up a full-text search index for SQL Server database.
Stuff and Replace in SQL Server 20127/11/2019 5:45:16 AM. Here, we will have a look at how to use the Stuff and Replace functions in SQL Server 2012.
Using Having Clause in SQL Server 20127/11/2019 2:28:40 AM. In this article, I will try to highlight all the major points related to the Having clause in SQL Server.
Using GO and Semi-Colon in SQL Server 20127/11/2019 1:49:50 AM. This article contains the most commonly used GO command and Semi-Colon in SQL Server with examples.
Ranking Functions in SQL Server 20127/10/2019 4:53:23 AM. Here, we will take a look at how to use Ranking Functions in SQL Server 2012. Learn ROW_NUMBER, RANK, DENSE_RANK, NTILE.
Schema in SQL Server 20127/10/2019 4:31:05 AM. In this article, I describe schemas in SQL Server 2012. A SQL schema is like a container that contains database objects like tables, views etc. So let us learn about schemas, creation of schemas, how
Count All vs Count Distinct in SQL Server7/8/2019 9:53:12 AM. In this article, you will see the SQL aggregate function count in two forms, Count All and Count Distinct.
Creating Duplicate Table With New Name From Existing Table in SQL Server 20127/8/2019 6:21:17 AM. In this article, you will see how to create a duplicate table with a new name using a script in SQL Server.
How to Change Password in SQL Server 20127/8/2019 5:42:46 AM. Here, we will see how to change the password visually and programmatically in SQL Server 2012.
Sum of Columns of Two Tables Into One Column in SQL Server 20127/8/2019 5:35:02 AM. This article will give you an idea of how to add columns of two tables into one column and also defines how to handle a null value in SQL Server.
Retrieving Column Names of a Table in SQL Server 20127/8/2019 5:24:39 AM. In this article, I would like to show how to get the name of all columns of a table in SQL Server.
If and While Statement in SQL Server7/4/2019 6:35:08 AM. In this article, we will see how to use If and While statements in SQL Server.
Some Useful System Stored Procedures in SQL Server 20127/2/2019 6:30:16 AM. This article provides a brief introduction to various system Stored Procedures in SQL Server.
Dropping All the Tables in Database in SQL Server 20127/2/2019 1:34:55 AM. In this article, I describe how to drop all the tables in a particular database.
SP_MSFOREACHDB Stored Procedure in SQL Server 20127/2/2019 1:17:37 AM. In this article I describe the Sp_msforeachdb System Stored procedure in SQL Server 2012.
Display Stored Procedure Output Parameter Value With Query Window in SQL Server 20127/2/2019 1:05:32 AM. In this article, I am showing you how to display return value from stored procedure output parameter in Query Window in SQL Server 2012.
Offline Install .NET Framework 3.5 On Windows Server 2012 R26/25/2019 8:52:32 AM. In this article, you will learn about the offline installation of .NET Framework 3.5 on Windows Server 2012 R2.
Adding Subquery in a Select Statement in SQL Server 20126/20/2019 6:09:57 AM. Today, I have provided an article showing you how to add a subquery to a select statement in SQL Server 2012.
Formula For Computed Column Specification Property in SQL Server 20126/20/2019 5:35:54 AM. This article will give you an idea of how to use formula child property of computed column specification property in SQL Server.
Patindex Function and Charindex Function in SQL Server 20126/20/2019 5:00:38 AM. In this article, I will show you how to use the Charindex and Patindex functions to search text columns and character strings.
Introduction of Trigger in SQL Server 20126/20/2019 4:20:47 AM. In this article I am going to explaining about trigger in SQL server 2012.
Passing Table to a Function Parameter in SQL Server 20126/17/2019 11:55:08 PM. In this article, I describe how to pass a table to a function parameter in SQL Server.
Using CLR With SQL Server 20126/11/2019 6:36:18 AM. In this article, I’ll cover the SQL CLR in SQL Server 2012.
A Simple Use of Case Statement in SQL Server 20126/11/2019 5:05:23 AM. This article will give you an idea of how to use a Case expression in SQL Server.
How to Create Database Backup in SQL Server 20126/11/2019 4:46:24 AM. In this article, I am going to explain how to create a database backup in SQL Server 2012.
Using Case With Select and Update Statement in SQL Server 20126/11/2019 4:05:52 AM. In this article, I would like to show the most commonly used case expressions with update statements in SQL Server. 
Joining Three or More Tables in SQL Server 2012 6/7/2019 6:27:14 AM. This article will give you an idea of how to join three or more tables and also defines the join in SQL Server.
Removing the First and Last Character From a Table Column in SQL Server 20126/7/2019 4:04:40 AM. In this article I provide a quick overview of the various Queries to remove the first and last character from a string in SQL Server.
How to Use @@FETCH_STATUS Function in SQL Server 20126/6/2019 1:15:09 AM. In this article I am going to explain how to use the @@FETCH_STATUS function in SQL Server 2012.
Calculating Age in Years, Months and Days in SQL Server 20126/6/2019 12:10:54 AM. In this article, I would like to show the difference between two dates in years, months and days in SQL Server.
How to Create Scalar Value Function in SQL Server 20126/4/2019 3:38:08 AM. In this article I am going to explain how to create scalar value functions in SQL Server 2012.
How to Restore Database Backup in SQL Server 20126/4/2019 2:30:07 AM. In this article, I am going to explain how to restore a database backup in SQL Server 2012.
Commit and Rollback Commands in SQL Server6/3/2019 4:39:44 AM. In this article I describe Commit and Rollback Commands in SQL Server.
Over Clause in Sql Server6/2/2019 8:02:02 AM. SQL Over. This article explains how SQL Over clause works. Windowing in SQL Server is done by the over clause that was introduced in SQL Server 2005.
Maximum Limit Value For Integer Data Type in SQL Server 201211/25/2018 11:38:26 PM. In this article, I described how to calculate the maximum range of various integer data types in SQL Server. TINYINT, SMALLINT, INT and BIGINT are all number data types. The difference between these d
Select Query Using Like Clause in SQL Server 20129/5/2018 1:46:08 AM. In this article, we will see how to use the Select Query Using Like Clause in SQL Server 2012. The percent sign (%), Underscore (_), Bracket ([]), Caret (^) are wildcard characters in SQL Server.
How To Remove IIS On Windows Server 20121/31/2018 5:14:14 AM. In today's article you will learn how to remove Internet Information Services 8 (IIS8) on Windows Server 2012.
If The Boot Configuration Data For Your PC Is Missing Or Contains Errors11/6/2017 4:25:10 PM. The Boot Configuration Data (BCD) is a firmware-independent database for boot-time configuration data. It is used as new Windows Boot Manager. It replaces the "boot.ini" file that was used i
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.
Fix Corrupt User Profile / Temp Profile in Windows Server 2008/ 20125/25/2017 7:54:35 AM. You will see here how to fix a corrupt user profile or temp profile in Windows Server 2008/2012
Configuring Active Directory Certificate Services In Server 20126/26/2016 12:08:09 PM. This article will teach you how to configure Active Directory Certificate services in Windows Server 2012.
Configuring Active Directory Domain Services In Server 20126/24/2016 4:47:17 PM. In this article, you will learn how to configure an Active Directory Domain Service (AD DS) in Server 2012.
Active Directory Configuration & Creating A New Domain User In DNS (Windows Server 2012 R2)4/20/2016 11:53:40 AM. In this article I will explain how to create a new domain user account in Windows Server and what prerequisites for configuration are required .
SharePoint 2016 Server Installation On Windows Server 2012 (VM)4/16/2016 11:00:21 AM. In this article you will learn how to install SharePoint 2016 Server on Windows Server 2012 (VM).
SQL Server 2012 Installation Step By Step1/5/2016 2:33:30 PM. In this article we’re going to see how to install SQL Server 2012.
Top 10 Exciting New Features of SQL Server 201212/23/2015 4:08:06 AM. In this tutorial I will discuss 10 exciting new features related to developer and SQL Server enhancements.
How To Generate A Script In SQL Server 201212/19/2015 2:51:29 AM. In this article I will show you how to generate a script with schema and data and create a new database in SQL 2012.
Steps To Resolve .NET Installation Error In Windows Server 201212/8/2015 12:13:41 AM. In this article you will learn how to resolve dotnet not getting installed error in Windows Server 2012.
COUNT_BIG Function In SQL Server 201211/18/2015 6:02:51 AM. In this article you will learn about COUNT_BIG function In SQL Server 2012.
New DateTime Function In SQL Server 201211/15/2015 4:52:07 AM. In this article you will learn new DateTime Function in SQL Server 2012.
Generate Database Script In SQL Server 201210/1/2015 6:36:31 AM. In this article we are learning how to generate database script in SQL Server 2012.
SQL Server 2012 Data Quality Services (DQS)2/5/2015 11:47:54 AM. This article introduces Data Quality Services (DQS) in SQL Server 2012.
Install SQL Server 20121/27/2015 1:06:24 PM. This article explains how to install SQL Server 2012.
Extended Events in SQL 201212/3/2014 7:36:58 PM. In this article you will learn how to work with Extended Events in SQL 2012.
Problem and Solution - SharePoint 2013 Prerequisites Installation on Windows Server 2012 R28/31/2014 8:25:06 AM. This article describes SharePoint 2013 prerequisites installation on Windows Server 2012 R2.
Create the Configuration Database For Standalone Installation with Local Account - SharePoint Server 20138/30/2014 8:41:55 PM. In this article you will learn how to create the Configuration Database for standalone installation using a Local Account .
SQL Server 2012 System Databases8/28/2014 5:00:26 PM. This article explains the System databases in SQL Server 2012.
Database Mail in SQL Server 20125/22/2014 12:06:23 AM. This article describes Database Mail, how to configure and manage Database Mail, and what permissions are needed to use database mail in SQL server 2012.
DateTime Functions in SQL Server 20123/18/2014 11:58:58 AM. This article describes all the new DateTime functions introduced in SQL Server 2012 with examples.
EXECUTE Statement Enhancement WITH RESULT SETS in SQL Server 20122/20/2014 2:07:36 PM. This article explains the EXECUTE atatement enhancement in SQL Server 2012, "WITH RESULT SETS".
SEQUENCE in SQL Server 20122/19/2014 3:53:43 PM. This article explains the SEQUENCE value in SQL server 2012.
OFFSET and FETCH in SQL Server 20122/18/2014 12:56:51 PM. SQL Server 2012 has introduced two new keywords for doing pagination of the result sets: OFFSET and FETCH.
Lead and Lag Function in SQL Server 20122/17/2014 3:13:27 PM. This article explains the SQL Server 2012 two new analytical functions LEAD and LAG.
How to Install SQL Server 2012 on Windows 8.11/13/2014 4:02:22 PM. This article explains how to easily install SQL Server 2012 in Windows 8.1.
Union & Union All Operators in SQL Server 201211/25/2013 2:44:48 AM. In this video you will learn about the use and difference's between Union and Union All Operators in SQL Server 2012 .
How to Take Backup From SQL Azure10/28/2013 12:55:42 PM. This article describes how to take a backup from SQL Azure.
Throw in SQL Server 201210/8/2013 10:56:47 AM. Throw keyword is introduced with SQL server 2012. Throw is used to raises exception and transfers execution to a CATCH block in SQL server.
New Functions in SQL Server 201210/8/2013 3:32:33 AM. In this article I will be covering the most commonly used new functions in SQL Server 2012.
New Conversion Function in SQL Server 201210/3/2013 5:32:35 PM. SQL Server 2012 introduced the four new conversion functions: TRY_CAST, TRY_CONVERT, PARSE and TRY_PARSE.
New Logical Function in SQL Server 201210/1/2013 4:06:19 PM. SQL Server 2012 introduces two new logical functions: CHOOSE and IIF.
New Date Functions in SQL Server 20129/27/2013 12:35:23 PM. This article explains 7 new date functions in SQL Server 2012..
New String Function in SQL Server 20129/25/2013 5:26:17 PM. SQL Server 2012 introduced two new string functions: Concat and Format.
Creating One Way Incoming Forest Trust For Both Side of Trust7/21/2013 4:55:10 PM. In this article I will create a one-way incoming Forest Trust for both sides of a trust.
Creating Two Way Realm Trust For Both Side of Trust7/21/2013 4:41:36 PM. In this article I will create a two-way Realm Trust for both sides of a trust.
Add Delegate Control in the Active Directory Sites and Services7/19/2013 4:37:04 PM. This article explains about how to add a Delegate Control in the Active Directory Sites and Services.
Adding a New Site in Active Directory Site and Services7/19/2013 4:22:30 PM. This article explains how to add a new site to Active Directory Site and Services.
Install SQL Server 2012 Reporting Services Add-in For SharePoint 2010 and Sharepoint 20137/18/2013 2:11:17 PM. This article explains how to install SQL Server 2012 Reporting Services Add-in for SharePoint 2010 and Sharepoint 2013.
Import the Server Authentication Certificate Through IIS Manager7/17/2013 5:21:49 PM. This article explains how to import a certificate using IIS Manager.
Import the Server Authentication Certificate From a File to Ad FS7/14/2013 5:20:28 PM. This article explains how to import the Server Authentication Certificate from a file to AdFS.

Topics