SQL Server 2012 – Installation of SSRS Reporting Services Native Mode Report Server (SSRS)

You will get the step by step tutorial to install the SQL Server with Full or Partial features. Many time people are looking specific feature that we need to install for Reporting service Native Mode Report Server. So the purpose if this post is give idea of feature required for SQL Server Reporting Service Installation as shown in given snapshot:

» Read more

Reviewer – Reporting with Microsoft SQL Server 2012

I pleased to announce that Reporting with Microsoft SQL Server 2012 has been published. Officially, I have reviewed this book. I would like to request you all to read this book and provide your valuable feedback on the content. Click here for more detail about Reporting with Microsoft SQL Server 2012

» Read more

SQL Server – Understanding of SQL Server Role and Database Role

SQL Server supports the two authentication mode as Windows authentication mode and Mixed authentication mode. Once the user is authenticated, SQL server will allow access to the user based on the permission that user has. All the user permissions are based on Server Role and Database Role. So let try to user understand the meaning of each server role and database role. Server Role: Role Name Permission user can have bulkadmin Can run the BULK INSERT statement. dbcreator Can create,

» Read more

Six Signs You Need To Change Careers

“Choose a job you love, and you will never have to work a day in your life.” ― Confucius  Are you one of those people who are struggling to finish the 9 to 5 shift every freaking day? Is satisfaction hard to come by when you’re working? Do you feel that you’re meant for something greater and grander? If your answer to these questions is a big YES then maybe it’s time for you to change careers! Of course, a

» Read more

Packt Publishing celebrates their 2000th title with an exclusive offer – We’ve got IT covered!

Known for their extensive range of pragmatic IT ebooks, Packt Publishing are celebrating their 2000th book title `Learning Dart’– they want their customers to celebrate too. To mark this milestone Packt Publishing will launch a ‘Buy One Get One Free’ offer across all eBooks on March 18th – for a limited period only. `Learning Dart’ was selected as a title and published by Packt earlier this year. As a project that aims to revolutionise a language as crucial as JavaScript,

» Read more

SQL Server 2012 – Get Backup History of the database

The msdb database is system database used by SQL Server Agent for scheduling alerts and jobs. msdb.dbo.backupset – Contain the information concerning the most-granular details of the backup process msdb.dbo.backupmediafamily – Contains the metadata for the physical backup files as they relate to backup sets Using the above mentioned tables, we will find the backup history of database Script: SELECT s.database_name, m.physical_device_name, CAST(CAST(s.backup_size / 1000000 AS INT) AS VARCHAR(14)) + ' ' + 'MB' AS Backup_Size, CAST(DATEDIFF(second, s.backup_start_date,s.backup_finish_date) AS VARCHAR(4))

» Read more

SQL Server – Migrate/Transfer Maintenance Plan from one Instance to another

There are very few simple steps to migrate/ transfer the maintenance plan from one SQL Server instance to another. Maintenance Plan is nothing but SSIS package which SQL Server creates and deploys it under MSDB Database. I have created one maintenance plan to for the demonstration; you may migrate/ transfer as many you have with the same steps (as shown in the below image). Now connect to SQL Server Integration Services and Navigate to Stored Packages >>MSDB >> Maintenance Plans

» Read more

SQL Server – Integration Services – Access is denied

If you are facing the access denied error while connecting to Integration Services as shown below : Error detail: Connecting to the Integration Services service on the computer “ComputerName” failed with the following error:  “Access is denied.” (shown in given image) Connect the SQL Server Management Studio with “Run as administrator” option. After that you will able to connect SQL Server Integration Services Service.

» Read more

XCOPY VS ROBOCOPY – Command Line Tool

XCOPY and ROBOCOPY both are the command line tools for copying multiple files or entire directory trees from one directory location to another and for copying files across a network.  XCOPY stands for extended copy and ROBOCOPY means “Robust File Copy“. XCOPY is included in most versions of Windows and ROBOCOPY is available as part of the Windows Resource Kit starting with Windows NT 4.0. We can say that, ROBOCOPY replaces XCOPY with more switches/options. XCOPY Syntax: XCOPY <source folder location>

» Read more

Schedule Automatic Backup in SQL Server 2012 – Part2

In the previous post, we have scheduled automatic backup in SQL Server 2012 – Part1. As we have scheduled daily backup of database and backup file will be generated every day. It is a good practice that to delete backup files after a certain period of time as per requirement. Now we will add the Maintenance Clean Up Task along with the Back Up Database Task. Configure Clean Up Task From the Maintenance Plan Tasks tool box pane in the left

» Read more

Schedule Automatic Backup in SQL Server 2012 – Part1

You know it is very important to back up your SQL server database backup on the regular basis. So in this post, we will see how to schedule automatic backup in SQL server 2012. We will go step by step to schedule so that we all can understand each and every step clearly. Before scheduling automatic backup we have make sure the following two points: User should have the SYSADMIN privileges to schedule automatic backup. SQL Server Agent service should

» Read more

Adjusting To Your New Life After College

Life after college is far from being made up of rainbows and butterflies. Take it from someone who had difficulty adjusting to the new lifestyle. Finding a new job and forgetting that research papers are out of my concern is easier said than done. Still, I was able to pull it off and is now a proud member of the work force. The transition that you’ll have to go through once college is over is going to be one hell

» Read more
1 2 3 4 5 26