SQL Server

SQL Server

SQL Server recovery procedures for a catastrophic failure – (Part-2)

SQL Server recovery procedures for a catastrophic failure – (Part-2) Author: Basit A. Farooq To rebuild master follow the instructions below: Execute Setup.exe as follows: start /wait setup.exe /qn INSTANCENAME=instance_name REINSTALL = SQL_Engine REBUILDDATABASE=1 SAPWD=strongpassword Setup recreates the resource database and the master database. Install any necessary service packs. Attach any user databases or restore databases from backup. If the […]

SQL Server

Troubleshooting SQL Server 2014 Snapshot Replication

Troubleshooting SQL Server 2014 Snapshot Replication If you have problems with SQL Server 2014 snapshot replication, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because some SQL Server 2014 snapshot replication bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time […]

SQL Server

User-defined functions (UDFs) – Part-1

User-defined functions (UDFs) – Part-1 Author: Basit A. Farooq Editor’s Note: In this first of the two part article series, you’ll compare and contrast stored procedures for creating and using scalar valued functions, in-line table functions, and multi-statement table functions. You’ll learn about syntax and parameters of CREATE FUNCTION statement. User-defined functions (UDFs) are similar to system functions, except that […]

SQL Server

Troubleshooting SQL Server 2014 Roles

Troubleshooting SQL Server 2014 Roles If you have problems with SQL Server 2014 roles, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because many SQL Server 2014 roles bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time this article was […]

SQL Server

Applying Index, View, As Well As Full-Text Search Part 4

Applying Index, View, As Well As Full – Text Search Part 4 Instruction For Forming Extensible Markup Language (XML) Index An individual must think through the subsequent rules at the time of forming Extensible Markup Language (XML) index: · Extensible Markup Language (XML) index can be formed solely on the Extensible Markup Language (XML) columns or attributes. · Extensible Markup […]

SQL Server

SQL Server recovery procedures for a catastrophic failure – (Part 1)

SQL Server recovery procedures for a catastrophic failure – (Part-1) Author: Basit A. Farooq A database server is usually a mission-critical component. Having a recovery plan in place is essential to ensuring the business can continue to operate in the event of hardware failure, natural disaster, or other catastrophe. A backup or standby server is an option, but not always […]

SQL Server

Troubleshooting problems with SQL Server 2014 Profiler

Troubleshooting problems with SQL Server 2014 Profiler If you have problems with Microsoft SQL Server 2014 Profiler, review this troubleshooting checklist to find potential solutions. Note. Microsoft announcing the deprecation of SQL Server Profiler for Database Engine Trace Capture and Trace Replay, but SQL Server Profiler for the Analysis Services workloads is not being deprecated, and will continue to be […]