Uncategorized

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

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

How to Enable .NET Framework on Windows

Enable the .NET Framework 3.5 in Control Panel

You can enable the .NET Framework 3.5 yourself through Control Panel.

Step 1: Ensure you are connected to Internet. Log on to Control Panel.

Step 2:
Press the Windows key Windows logo on your keyboard, type Windows Features, and press Enter. This brings up the Turn Windows features on or off dialog box. Alternately, open Control Panel, click on the Programs items, and then click on “Turn Windows features on or off” under Programs and Features.

Step 3:
Select the .NET Framework 3.5 (includes .NET 2.0 and 3.0) check box, press OK, and reboot your computer if prompted.
You do not need to select the child items for Windows Communication Foundation (WCF) HTTP activation unless you are a developer who requires WCF script and handler mapping functionality.

Step 4: Restart your Computer.

Cron Jobs in SQL Server

Cron Jobs in SQL Server

Cron is a utility for time-based job scheduling operations.

PowerShell Scripts help us in configuration of Cron Jobs.

 

Steps to Schedule a cron job:

  1. Open the SQl Azure / Cloud Sites Control Panel.
  2. Click on the site with the database >>  Features (tab).
  3. Under Scheduled Tasks (Cron Jobs) >> Add New Task (This is similar to STEP we see in regular SQL Server Job)
  4. Name the Job >> Check  Send me an email check box
  5. Configure the step. Ex: Select http as the script language and Enter the URL to the ASP script/PowerShell Script you predefined for action and notification.
  6. Schedule the job as per your requirement.

Error while connecting to SQL Server?

How to Connect to SQL Server after Installation

 

Applicable for SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 and SQL Server 2016

To resolve possible connection issues at basic level, ensure the following:

1. Verify and ensure correct server name is provided
2. Start >> Run then services.msc then ensure SQL Server service for the respective instance is started.

Any clarifiations: Please email to contact@sqlschool.com

For Real-time Trainings and Projects, Placements on SQL Server, please visithttp://www.sqlschool.com

Or call us on +91 9666440801 (INDIA) or +1 510-400-4845 (USA/CANADA)

Tech Mahindra Off Campus Drive for BE/BTech/MCA as Employee Referral at Across India

Key Skills

Job Description

Company Name: Tech Mahindra
Company Website: www.techmahindra.com
Job Location : Across India Offices
Salary : Rs 2.47 LPA on training and after completing the probationary period , 3.07 LPA.
Last Date to get referred : ASAP
Hall Ticket : will be intimated to the shortlisted candidates email id
Eligibility Criteria :
Year of Passing out : 2015 Batch
Degree : BE / BTech / MCA
Specialization : CS / CE / IT / E&C / E&TC / Telecom / Communication / Mechanical / Electronics / Electrical / Mechatronics / Instrumentation
No Backlogs
 
Percentage Criteria :
Minimum 60% in 10th and BE / BTech / MCA and ( including Non Engg Graduation for MCA )
Minimum 70% in 12th / Diploma
Note : Not more than 1 year gap in education ( after passing 10th ) and should not have lost any academic year due to having failed in any course / subject ever for whatsoever reason.
 
Selection Process :
Campus Test
Essay Writing in English
Tech & HR Interview
Note : Please confirm and proceed with Tech Mahindra employee.
Find Tech Mahindra employee and send your details to him / her in the following fashion :
Please give your Preferred Test Location as well in subject line asTechM-Offcampus-Bangalore
Send the details in below format. () field is mandatory.
First Name:-
Middle Name:-
Last Name:-
Father’s Name:-
Mother’s Name:-
Date Of Birth:-
(MM/DD/YYYY)
Gender:-
Contact Number:-
Email ID:-
Nationality:-
Current Location:-
Preferred Test Location:-
Passport No:-
Date Of Issue:-
Valid Upto:-
Place Of Issue:-
Email ID 1:-
Email ID 2:-
Country:-
State:-
City:-
Pin Code:-
Previous Experience:-
Permanent Address:-
Current Address:-
Educational Details : Qualification
 
10th
Degree Board / University  :-
School / College :-
Specialization Marks (%) :-
Year Of Passing :-
 
12th / Diploma
Degree Board / University :-
School / College :-
Specialization Marks (%) :-
Year Of Passing :-
Engg. Graduation
Degree Board / University :-
School / College :-
Specialization Marks (%) :-
Year Of Passing :-
Post Graduation
Degree Board / University :-
School / College :-
Specialization Marks (%) :-
Year Of Passing :-
About The Company :  Tech Mahindra Limited is an Indian multinational provider of information technology (IT), networking technology solutions and business support services (BPO) to the telecommunications industry. Tech Mahindra is a part of the Mahindra Group conglomerate. It is headquartered at Mumbai, India.