Author: sqlschool

Difference Between SQL & SQL Server

SQL Server is an RDBMS just like oracle,DB2 from Microsoft

Structured Query Language (SQL), pronounced “sequel”, is a language that provides an interface to relational database systems. It is an open, vendor-independentIt was developed by IBM in the 1970s for use in System R. SQL is a de facto standard, as well as an ISO and ANSI standard. SQL is used to perform various operations on RDBMS

SQL is the basic ANSI standard for accessing data in a relational database. When you see “MSSQL” it is referring to Microsoft SQL Server, which is the entire database architecture and not a language. T-SQL is the proprietary form of SQL used by Microsoft SQL Server. It includes special functions like cast, convert, date(), etc. that are not part of the ANSI standard.

You will also see things like plSQL, which is Oracle’s version of SQL, and there are others as well (mySQL has its own version, for example, and Microsoft Access uses Jet SQL.)

It is important to note the the ANSI standard for SQL has different releases (for example, 92 or 99, representing the year it was released.). Different database engines will advertise themselves as “mostly ANSI-92” compliant or “fully ANSI-99” compliant, etc, and any exceptions will usually be documented.

So although “SQL is SQL”, every engine uses its own “flavor” of it, and you do have to do a little reading on the particular platform before you just dive in.

A further note – the SQL extensions, like T-SQL, are generally considered full-fledged programming languages, complete with looping, if/then, case statements, etc. SQL itself is limited to simply querying and updating data and is not considered a true programming language.

For More Information Please Click On This Link : SQL & SQL Server, T-SQL

SQL is the BEST language for Job Market: 2016

SQL is the TOP technology stream for Job market in 2016.

SQL School Training Institute is an ISO Certified Organization and Microsoft Learning Partner offering real-time, practical trainings exclusively on SQL Server Technologies including SQL Server Development (SQL Dev), SQL Database Administration (SQL DBA), Microsoft Business Intelligence and Datawarehousing (MSBI / DWH) Training. Versions: SQL Server 2016, SQL Server 2014. Register Today for free demo

 

Ref:

http://www.codingdojo.com/blog/9-most-in-demand-programming-languages-of-2016/

 

Reach us today for a free demo!

+91-9666440801 (India)
+91-9542916779 (India)
+91-(0)40 64577244 (India)
+1-510-400-4845 (USA/Canada)

 

DBCC Commands @ SQL Server

DBCC (Database consistency checker) act as Database console commands for SQL Server to check database consistency.

They are grouped as:

Maintenance

Miscellaneous

Validation

A brief description of the DBCC command categories is given below.

Maintenance: Maintenance tasks on a database, index, or filegroup.

Miscellaneous: Miscellaneous tasks such as enabling trace flags or removing a DLL from memory.

Informational: Tasks that gather and display various types of information.

Validation: Validation operations on a database, table, index, catalog, filegroup, or allocation of database pages.

Uses Of DBCC:

DBCC give details in form of statistics about the SQL Server. They can be used for Maintenance of database, index, or filegroup. DBCC Commands can be used to perform validation operations on a database, table, index, catalog, filegroup, or allocation of database pages.

They can perform miscellaneous tasks such as enabling trace flags or removing a DLL from memory. DBCC INDEXDEFRAG, DBCC ERRORLOG, DBCC CACHESTATS are one of the few DBCC commands

List of frequently used DBCC Command

  1. DBCC CHECKCATALOG

Used to perform consistency check for a table/catalog for a particular database.

  1. DBCC CHECKCONSTRAINTS

Used to check integrity of a particular constraint or all constraints on a particular table for a database.

  1. DBCC CHECKALLOC

Used to check page usage and allocation of a database.

  1. DBCC CHECKTABLE(tablename)

Used to verify data page integrity, page offsets, data page links, page pointers, index pointers, index sort order for a specified table.

  1. DBCC SQLPERF(logspace)

Displays T-log size and space used % for all databases.

  1. DBCC SHOWFILESTATS

Display Extent information for a database.

  1. DBCC CHECKIDENT(tablename)

Used to check identity information or to return current identity value for a particular table.

  1. DBCC TRACEOFF

Used to disable tracing

  1. DBCC TRACEON

Used to enable tracing.

  1. DBCC TRACESTATUS

Displays the trace status.

  1. DBCC USEROPTIONS

Displays the active SET options for a particular database

  1. DBCC INPUTBUFFER(sessionid)

Used to get the last statement sent by session to SQL server.

  1. DBCC SHRINKDATABASE(databasename)

Used to shrink data and log files for a particular database. It release the free space to OS.

  1. DBCC SHRINKFILE(file_id)

Used to shrink individual database files.

  1. DBCC LOGINFO

Displays virtual log file information contained in a T-log file.

  1. DBCC HELP(<dbcc command>)

Displays the syntax of a DBCC command. To know syntax of DBCC SQLPERF, execute

  1. DBCC MEMORYSTATUS

Displays SQL Server memory allocation status.

  1. DBCC Cleantable

Used to reclaim space from dropped variable length columns in tables/indexed views

  1. DBCC Opentran

Displays information about oldest active transaction and oldest distributed and non-distributed replication transaction

For more commands, please log on to: http://sqlschool.com/SQL-DBA-Course.html

or email to our trainer: saiphanindrait@yahoo.com
We offer free technical support for this type of informational queries.

SQL Server FETCH & OFFSET Statements

OFFSET 10 ROWS
FETCH NEXT 20 ROWS ONLY
Constants for the OFFSET and FETCH NEXT can be dynamic.

— OTHER EXAMPLE WITH CTE, OFFSET:

WITH C AS
(
SELECT ROW_NUMBER() OVER(ORDER BY OrderDate, SalesOrderID) AS rownum,
SalesOrderID, OrderDate, CustomerID, SalesPersonID, SubTotal
FROM Sales.SalesOrderHeader
)
SELECT SalesOrderID, OrderDate, CustomerID, SalesPersonID, SubTotal
FROM C
WHERE rownum BETWEEN 1 AND 10
ORDER BY OrderDate, SalesOrderID;

— OTHER EXAMPLE WITH CTE, OFFSET, PARAMETERIZATION:
DECLARE
@pagenum AS INT = 2,
@pagesize AS INT = 10;

WITH C AS
(
SELECT ROW_NUMBER() OVER(ORDER BY OrderDate, SalesOrderID) AS rownum,
SalesOrderID, OrderDate, CustomerID, SalesPersonID, SubTotal
FROM Sales.SalesOrderHeader
)
SELECT SalesOrderID, OrderDate, CustomerID, SalesPersonID, SubTotal
FROM C
WHERE rownum BETWEEN (@pagenum – 1) * @pagesize + 1 AND @pagenum * @pagesizeORDER BY OrderDate, SalesOrderID

SQL DBA Training from Jan 16th

SQL DBA Training from Jan 16th

SQL DBA Online Training (LIVE, Instructor-Led)
Real-time Practical SQL DBA LIVE Online Training designed to work with all major SQL Database Administration activities including DB Design, Normalized Views, Stored Procedures, Indexes, Joins, DB Maintenance, Query Tuning, HA/DR, AAG and SQL Cluster Issues. Study Material, 24×7 Online Lab, Certification, Job Support with One Realtime Project included in the course. Versions: SQL Server 2012, SQL Server 2014 & 2016.

Register today @ http://sqlschool.com/Register.html

SQL DBA TRAINING – CDC, SERVER ALIAS n NETWORK PROTOCOLS

SQL DBA TRAINING – CDC, SERVER ALIAS n NETWORK PROTOCOLS

SQL SERVER DBA TRAINING CDC, Aliases, Network Protocols

This video explains SQL DBA Training Content – CDC [Change Data Capture], Server Aliases and Network Protocols.

Change Data Capture is used to AUDIT DML [INSERT. UPDATE, DELETE] and minimal DDL[ALTER TABLE .. ADD/ALTER COLUMN/CONSTRAINT .. statements] operations on any SQL Server Table. Applicable for Enterprise and Data Center Editions.

Server Aliases are used for SQL Server Connection Aliasing and Application Level Connection Abstraction.

Network Protocols to ensure secured transfer of TDS [Tabular Data Stream] Packets between SQL Server and any client like SSMS, SQLCMD, PSSDIAG, etc..

At SQL School Training Institute, we provide complete real-time and practical traininings on SQL Server T-SQL, SQL DBA, MSBI (SSIS, SSAS, SSRS), Power BI and more…

For details course curriculum available at :

http://sqlschool.com/SQLDBA-Online-Training.html

To register for a free demo, visit:
http://sqlschool.com/register.html

contact@sqlschool.com
+91-9666440801 (India)
+91-9542916779 (India)
+91-(0)40 64577244 (India)
+1-510-400-4845 (USA/Canada)

MSBI (SSIS, SSAS, SSRS) Training with Real-time Project

MSBI (SSIS, SSAS, SSRS) Training with Real-time Project

Microsoft Business Intelligence – MSBI Online Training (LIVE, Instructor-Led)
This impeccable MSBI (SQL BI) course is carefully designed for aspiring BI Developers, Consultants and Architects. Program includes basic to advanced Business Intelligence and Data Warehouse concepts on SQL Server Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS). Complete practical and realtime training course with 24×7 free LIVE server access and Lab.

MSBI (SSIS, SSAS, SSRS) LIVE Online Training

MSBI (SSIS, SSAS, SSRS) LIVE Online Training

MSBI (SSIS, SSAS, SSRS) Training with Real-time Project

SQL DBA Training – LIVE Online Training

SQL DBA Training with Real-time Project, Job Support

SQL DBA Online Training (LIVE, Instructor-Led)
Real-time Practical SQL DBA LIVE Online Training designed to work with all major SQL Database Administration activities including DB Design, Normalized Views, Stored Procedures, Indexes, Joins, DB Maintenance, Query Tuning, HA/DR, AAG and SQL Cluster Issues. Study Material, 24×7 Online Lab, Certification, Job Support with One Real-time Project included in the course. Versions: SQL Server 2012, SQL Server 2014 & 2016.

Register Today
contact@sqlschool.com
+91-9666440801 (India)
+91-9542916779 (India)
+91-(0)40 64577244 (India)
+1-510-400-4845 (USA/Canada)

Trainer Profile, Duration, Pricing

Trainer: Mr Sai Phanindra T (9+ Yrs Exp, MS FTE)

Duration: 7 Weeks (Mon – Fri/Sat). Installment Pay.

Total Course Fee: INR 18000/- ~ USD 300

Register Today
contact@sqlschool.com
+91-9666440801 (India)
+91-9542916779 (India)
+91-(0)40 64577244 (India)
+1-510-400-4845 (USA/Canada)

SQL DBA Online Training – Highlights
Completely Practical and Real-time
Suitable for Starters + Working Professionals
Session wise Handouts and Tasks + Solutions
TWO Real-time Case Studies, One Project
Certification & Interview Guidance
Detailed SQL Server Architecture, DB Design
Query Tuning, Stored Procedures, Linked Servers
In-Memory, DAC and Contained Databases
Routine DBA Activities, Emergency DBA Activites
High Availability, Disaster Recovery, Always-On

More Details and Free demo registration @ http://sqlschool.com/SQLDBA-Online-Training.html

SQL Server DBA Course From SQLSchool.com

SQL Server DBA Course From SQLSchool.com

Complete Practical & Real-time Training

Mode: Instructor Led – LIVE , Online Training
Duration: 7 Weeks, Weekly 6 Days
Type: 100% Practical. Theory Material provided in Advance.

Training Highlights
 Study Material and Practice Labs
 Interview Preparation and Guidance
 24×7 LIVE Server Access with Databases
 Complete Practical and Real-time Scenarios
 Session wise notes & Doubts Clarifications
 Certification Material & Resume Preparation
 Technical Support and Placements Assistance
 Mock Interview and Job Support, Mock Interviews
 One Real-time Project with DBA Challenges in Real-time

All Training Sessions are Completely Practical & Real-time