SQL Server 2016 introduces two new string functions namely STRING_SPLIT and STRING_ESCAPE. This is Part 8 of 10 Part T-SQL Enhancements in SQL Server 2016 for Developers and DBAs. Click here to read it from the...
Ashish MehtaSQL Server SIMPLE Recovery Model Step by Step Tutorial with Examples
SIMPLE recovery model as the name suggests it is the most basic recovery model which is available in SQL Server. In this recovery model every transaction is written to the transactional log file and once the transaction...
Chetna BhallaHow to Configure a Contained Database Feature in SQL Server
Contained Databases is a new feature which was initially introduced in SQL Server 2012. A contained database is a database that will store all its metadata within the database thereby not storing any configuration...
PARTIAL Backup in SQL Server Step by Step Tutorial with Examples
As per MSDN “PARTIAL Backups are designed for use under SIMPLE recovery model; thereby to improve flexibility to backup very large database which contain one or more read-only Filegroups. They are useful whenever...
How to Fix PowerShell Execution Policy Error in Windows Server
There are instance when you execute your PowerShell scripts on server from your command prompt you will end up seeing below mentioned error message. Error Message File cannot be loaded because the execution of scripts...
How to Change SQL Server Database Auto Growth Settings
Introduction In this article we will go through the steps to change SQL Server Database Auto Growth Settings. It is always a best practice to set an appropriate auto growth setting for all Production database to a...
How to Identify CPU Bottlenecks in SQL Server Using Performance Counters
There are instance when you are facing CPU bottlenecks on your SQL Server Instance. In this article we will take look at How to Identify CPU Bottlenecks in SQL Server Using Performance Counters.The most common reason...
How to Enable and Refresh IntelliSense in SQL Server Management Studio (SSMS)
Introduction In SQL Server 2008, Microsoft had introduced IntelliSense feature in SQL Server Management Studio (SSMS). As a Developer or as a DBA you may face issues with IntelliSense feature not to be working or not...
DROP IF EXISTS T-SQL Enhancement in SQL Server 2016
SQL Server 2016 introduces a new DROP IF EXISTS statement to DROP objects such as tables, columns, indexes, stored procedures, schemas, triggers and user-defined functions. DROP IF EXISTS statement can be used to check...
How to Enable & Disable XP_CMDSHELL using SP_CONFIGURE in SQL Server
Introduction In this tip we will take a look at the step to follow to enable XP_CMDSHELL and how to diable XP_CMDSHELL using SP_CONFIGURE system stored procedure. In order to use XP_CMDSHELL you need to be a system...
How to Backup Analysis Services Database in SQL Server Using SQL Server Management Studio
In this article we will take a look at the steps which a database administrator needs to follow to backup an analysis services database. The steps mentioned below are applicable on SQL Server 2005 and higher versions...
How to Get SQL Server Instance Information
In this article we will take a look at different ways in which a DBA or a Developer can Retrieve System and SQL Server Information. The method mentioned is applicable for SQL Server 2005 and all higher versions. Below...
Does SQL Server Database Use Any Enterprise Edition Features?
One of the most common tasks performed by the DBA is to moving user databases across different editions of SQL Server especially during Disaster Recovery Situations. There are some Enterprise Edition only features which...
SQL Server SELECT DISTINCT Clause T-SQL Tutorial with Examples
The SELECT DISTINCT Clause is used to fetch distinct values in a specific column of a given table. This is Part 3 of 40 Part SQL Server T-SQL Tutorial. Click here to read it from the beginning…. SELECT DISTINCT Syntax...
2 Signs you need to migrate to SharePoint 2016 and how to nail the upgrade
Reasons to Migrate to SharePoint 2016? Debates on migrating SharePoint solutions to its 2016 version started even before the version was officially released. All the stir is basically about the assertive promotion of...
How to Backup Database in SQL Server
How to Create a Full Backup of Database in SQL Server This article explains the steps you need to follow to take a FULL Backup of Database in SQL Server Using SQL Server Management Studio and by using TSQL Scripts. The...
How to Attach SSAS Database in SQL Server
This article explains How to Attach Analysis Services Database in SQL Server. The steps mentioned in this article are applicable on SQL Server 2008 and Higher Versions. Different ways in which an Analysis Services...
SQL Server BULK-LOGGED Recovery Model Step by Step Tutorial with Examples
When a database is configured to use a BULK-LOGGED Recovery Model then SQL Server will log minimal amount of information for operations such as SELECT INTO, BULK INSERT, BCP, CREATE INDEX, ALTER INDEX, and REBUILD INDEX...
COMPRESS and DECOMPRESS T-SQL Enhancement in SQL Server 2016
SQL Server 2016 introduces two new system functions namely COMPRESS and DECOMPRESS. This is Part 7 of 10 Part T-SQL Enhancements in SQL Server 2016 for Developers and DBAs. Click here to read it from the beginning…...
How to Repair Database in Suspect Mode in SQL Server
There are times when you connect to an SQL Server Instance you will find the database being marked as SUSPECT. In such a scenario, you will not be able to connect to the database to read and write data. This article...
SQL Server Configuration Manager
How to Use SQL Server Configuration Manager to Manage SQL Server Services, Configure Network Protocols, and Network Connectivity Configuration SQL Server Configuration Manager is a tool that can be used to manage all...
