This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.

This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.

SQL Server

//SQL Server

New Features in SQL Server 2005

By | September 16th, 2013|Database, SQL Server|

SQL Server 2000 provides Enterprise Manager to work with wizards and Query Analyzer to work with SQL queries. In SQL Server 2005, these two programs are combined into a single program called Management Studio. In today's connected world, data and the systems that manage that data must always be secure yet available to your users. [...]

Difference Between DB2 and SQL Server

By | January 4th, 2012|Database, SQL Server|

DB2 vs SQL Server Database systems are very important especially when dealing with great amounts of data that are very important. To handle these data, you would need to implement a Relational Database Management System or RDBMS. Two of the RDBMS in existence today are DB2 developed by IBM and SQL server which comes from Microsoft. [...]

SQL Server 2005 Clustering Best Practices

By | October 24th, 2011|Database, SQL Server|

In this section, I summarize all of the best practices you should follow if you want to install, configure, and maintain a solid SQL Server 2005 cluster. Think of this as a cluster checklist to success. Before You Begin Planning Planning in detail is essential! You should spend more time planning than you do in [...]

Un-Install a SQL Server Cluster: Step-by-Step

By | October 19th, 2011|Database, SQL Server|

If SQL Server Cluster Install ends up in errors and fails, consider doing a clean up of the cluster install and then re-start it. Here is a step-by-step process which gives a clean un-install of a SQL Server Cluster environment. Step-1 Execute sqlrem.bat Execute sqlrem.bat with following parameters on each node: Syntax: sqlrem.bat <sql install [...]

SQL Server Interview Questions & Answers – Part 6

By | July 20th, 2011|Database, SQL Server|

51). What is Identity? Identity (or auto number) is a column that automatically generates numeric values. A start and increment value can be set, but most DBA leave these at 1. A GUID column also generates numbers, the value of this cannot be controled. Identity/GUID columns do not need to be indexed. 52). What is [...]

SQL Server Interview Questions & Answers – Part 5

By | July 19th, 2011|Database, SQL Server|

41). What are the OS services that the SQL Server installation adds? MS SQL SERVER SERVICE, SQL AGENT SERVICE, DTC (Distribution transac co-ordinator) 42). What are three SQL keywords used to change or set someone’s permissions? GRANT, DENY, and REVOKE. 43). What does it mean to have quoted_identifier on? What are the implications of having [...]

SQL Server Interview Questions & Answers – Part 4

By | July 18th, 2011|Database, SQL Server|

31). Which command using Query Analyzer will give you the version of SQL server and operating system? SELECT SERVERPROPERTY(’productversion’), SERVERPROPERTY (’productlevel’), SERVERPROPERTY (’edition’) 32). What is SQL server agent? SQL Server agent plays an important role in the day-to-day tasks of a database administrator (DBA). It is often overlooked as one of the main tools [...]

SQL Server Interview Questions & Answers – Part 3

By | July 16th, 2011|Database, SQL Server|

21). What types of Joins are possible with Sql Server? Joins are used in queries to explain how different tables are related. Joins also let you select data from a table depending upon data from another table. Types of joins: INNER JOINs, OUTER JOINs, CROSS JOINs. OUTER JOINs are further classified as LEFT OUTER JOINS, [...]