Category Archives: Database Administration

10 Most Important handy system stored Procedures for DBA

10 Most Important handy system stored Procedures for DBA This blog contains the most important system stored procedures which are supported by SQL Server and are used on a daily basis by DBA. These stored procedures are used commonly for … Continue reading

Rate this:

Posted in Database Administration, Sql Server | Tagged , , , , , , , , , , , , | Leave a comment

MS SQL Server Version History – Year Wise

MS SQL Server Version History – Year Wise MS SQL Server is a RDBMS (Relational Database Management System) which is developed by Microsoft. Here we will go through a series of different versions of SQL Server with specified year when … Continue reading

Rate this:

Posted in Database Administration, Sql Server | Tagged , , , , , , , | Leave a comment

AlwaysOn Pre-Requisites

AlwaysOn Pre-Requisites  1.Windows 2.SQL Server 3. Databases Hotfix for .NET 3.5 SP1 adds support to SQL client for AlwaysOn. Windows Requirement: The system should not be in a domain controller Windows server 2012 or later versions should be running on … Continue reading

Rate this:

Posted in Clustering, Database Administration | Tagged , , , , , , , , , , , , , | Leave a comment

Shift Handover importance in a DBA job- DBA Interview Question

One of my blog readers asked me about shift Handover in a DBA job and how to prepare it. What is the importance of it for a DBA? I am trying to reply and the best possible points to ponder. … Continue reading

Rate this:

Posted in Database Administration, Other, Q & A | Tagged , , , , , , , , , | 1 Comment

Always On – Interview Notes

Always On Always on Availability Groups is a solution which improves database availability and supports a failover environment for a discrete set of user databases. It is introduced in SQL server 2012. Benefits: With the release of Windows Server 2016, … Continue reading

Rate this:

Posted in Clustering, Database Administration | Tagged , , , , , , , , , , , | Leave a comment

Interview Questions

Basic interview questions and answers for my fresher technical friends: Q & A Which TCP/IP port does SQL Server run on? How can it be changed? SQL Server runs on port 1433. It can be changed from the Network Utility … Continue reading

Rate this:

Posted in Database Administration, Q & A | Tagged , , , , , , , | Leave a comment

SQL Injection

SQL Injection (SQLi) refers to an injection attack wherein an attacker can execute malicious SQLstatements (also commonly referred to as a malicious payload) that control a web application’s database server. Such attack affects any website or web application. An attacker can bypass a web … Continue reading

Rate this:

Posted in Database Administration, Other, Security, Sql Server, T-SQL, Uncategorized | Leave a comment

SQL Server 2012 Features:5: 5. Windows server core support

In continuation of previous blog- Server Core is a minimalistic Microsoft Windows server installation option. You can install SQL Server on a Server Core installation of Windows Server 2008 R2 SP1 or Windows Server 2012. This option of windows server 2012 provides a … Continue reading

Rate this:

Posted in Database Administration, Sql Server New Feature | Leave a comment

SQL Server 2012 Features:4: Contained Database

In continuation of previous blog: Contained Databases: A contained database includes all database settings and the metadata within itself which results no configuration dependencies on the instance of SQL Server. Therefore a contained database is a database that is isolated … Continue reading

Rate this:

Posted in Database Administration, Sql Server New Feature | Leave a comment

SQL Server 2012 Features:3: Pagination

In continuation of previous blog: Pagination: This feature focuses on the result set of T-sql. It divides the result set into different parts to view easily. We can do pagination by using ‘OFFSET’ and ‘FETCH’ commands. We can pull only … Continue reading

Rate this:

Posted in Database Administration, Sql Server New Feature, T-SQL | Leave a comment