Profile

Cover photo
Paresh Prajapati
Works at sqlideas.com
Attended B.E.I.T.
Lived in India
1,730 followers|605,331 views
AboutPostsPhotosVideos+1's

Stream

Paresh Prajapati
owner

Discussion  - 
The SQL Ideas
sql, database, sql server, dba, sqldba, database administrator
View community
2
Add a comment...

Paresh Prajapati

Shared publicly  - 
The SQL Ideas
sql, database, sql server, dba, sqldba, database administrator
View community
1

Paresh Prajapati

commented on a post on Blogger.
Shared publicly  - 
 
Hi D P Tripathy,

It supports split to 64 files max.
As a maintenance activity DBA need to take care of the database backups and monitoring for the same because database backups are more important in recovery.Production live databases have more sizes and because of heavily size...
1

Paresh Prajapati

Shared publicly  - 
 
You may work with Service Broker in SQL Server. I am just learning Service Broker and implemented practical with an example which I evaluated. Before moving on it, I would like to introduce service broker, not in the deep but...
1

Paresh Prajapati

Shared publicly  - 
 
Previously i have posted for the overview and usage of the Grouping Sets as how can we get the aggregate data of different group sets with GROPING SETS vs Native method of group by. If you have not read my earlier post for th...
1
 
http://www.sqlideas.com/2015/05/configure-listener-for-high.html : Configure Listener for high availability in SQL Server 2012
Configure Listener for high availability in SQL Server 2012sqlIdeasConfigure Listener for high availability in SQL Server 2012
1
Add a comment...
Have him in circles
1,730 people
maulik kamdar's profile photo
Ian Duran's profile photo
Jeff Snodgrass's profile photo
Jayaprakash Jayaraman's profile photo
Dusty Sage's profile photo
Monu Kumar's profile photo
Tushar Viradiya's profile photo
sher hanc's profile photo
Snehal Brahmbhatt's profile photo

Paresh Prajapati

Shared publicly  - 
 
Before SQL Server 2008 , when we need gather all information and details related to server or database level, we must run the script individually by connecting each SQL Server instances. But SQL Server 2008 came up and easy o...
1
People
Have him in circles
1,730 people
maulik kamdar's profile photo
Ian Duran's profile photo
Jeff Snodgrass's profile photo
Jayaprakash Jayaraman's profile photo
Dusty Sage's profile photo
Monu Kumar's profile photo
Tushar Viradiya's profile photo
sher hanc's profile photo
Snehal Brahmbhatt's profile photo
Education
  • B.E.I.T.
Basic Information
Gender
Male
Looking for
Friends, Networking
Relationship
Married
Story
Tagline
SQL, Database, DBA, Database Administrator
Introduction
Working as Database Administrator.
Work
Occupation
Database Administrator
Skills
SQL Server, Database, DBA, Database Administration
Employment
  • sqlideas.com
    dba, 2006 - present
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Previously
India - Gujarat - Ahmedabad
Contact Information
Home
Email
Work
Email
Paresh Prajapati's +1's are the things they like, agree with, or want to recommend.
Code Snippets in SQL Server Denali
www.sqlideas.com

SQL Server Denali introduced one more feature which can easily and reduces our t-SQL coding. This feature is "Code Snippets". It allows to i

Agent XPs Disabled - SQL Server
www.sqlideas.com

I notified so many times by the Object Explorer when I go to check the SQL Server Agent jobs. The notification is “Agent XPs disabled”. Then

"Login failed for User" in SQL Server - Reason II
www.sqlideas.com

I hope you already read my previous post for the "Login failed for User" - Reason 1. And you have very idea on that how a user was foiled du

List your Tasks using Task List feature - SQL Server Denali
www.sqlideas.com

Problem : Sometime we need external tools to list our day to day tasks mostly when work for the SQL Server as it does not have any built in

Custom Code Snippet - SQL Server Denali
www.sqlideas.com

In previous post of code snippet, i have wrote for how code snippet is useful and how to use in query editor. It is good enhancement of quer

Working with Service Broker for single database in SQL Server
www.sqlideas.com

You may work with Service Broker in SQL Server. I am just learning Service Broker and implemented practical with an example which I evaluate

Service Broker - Conversation between Databases in SQL Server
www.sqlideas.com

Recently I have posted for Service Broker for single database in which I have explained it with table history example and it was invoked wit

New Logical functions coming in SQL Server Denali CTP3
www.sqlideas.com

As I have started to learn new functions arrived by SQL Server Denali CTP3 version and I have posted some of them. You can learn Analytical

Delete files using Ole Automation Procedures in SQL Server
www.sqlideas.com

To delete the files using Ole Automation Procedures in SQL Server we need to first enable 'Ole Automation Procedures' using sp_configure as

Stored Procedure Internal Activation in Service Broker - SQL Server
www.sqlideas.com

As we have seen earlier posts for Service Broker for single database and Service Broker between databases, we have implemented it with examp

Grouping Sets vs Native method of Group By - Performance review in SQL S...
www.sqlideas.com

Previously i have posted for the overview and usage of the Grouping Sets as how can we get the aggregate data of different group sets with G

Perform database backup using SQLCMD utility in SQL Server
www.sqlideas.com

I just went through the SQLCMD command line utility to perform database backup in SQL server where it does not have SQL agent. Below is the

Download all files through FTP in SQL Server
www.sqlideas.com

We have completed the reading of earlier methods to receive single file and receive file dynamically through the FTP in SSIS. Hope you like

sqlIdeas: Changing Rows to Columns Using PIVOT - SQL Server
www.sqlideas.com

Changing Rows to Columns Using PIVOT - SQL ServersqlIdeasChanging Rows to Columns Using PIVOT - SQL Server

sqlIdeas: Configure Listener for high availability in SQL Server 2012
www.sqlideas.com

Configure Listener for high availability in SQL Server 2012sqlIdeasConfigure Listener for high availability in SQL Server 2012

sqlIdeas: How to increase the number of characters retrieved from the se...
www.sqlideas.com

How to increase the number of characters retrieved from the server for XML data - SQL ServersqlIdeasHow to increase the number of characters

sqlIdeas: Archive files based on number of files configuration in SQL Se...
www.sqlideas.com

Archive files based on number of files configuration in SQL Server - SSISsqlIdeasArchive files based on number of files configuration in SQL

HHA Exchange
market.android.com

Schedule: View your schedule in real-time. See patient Info i.e. Care plan and Directions. Electronic Visit Verifications: Use Mobile specif

SQLIdeas - SQL Server High Availability - Manual Failover - Paresh Praja...
beyondrelational.com

Availability As we have seen SQL Server High Availability configuration and listener for same, i would like to go ahead for manual failover