Featured Posts

  • Prev
  • Next

Maximum SQL Server Express File Sizes

Posted on : 19-10-2011 | By : admin | In : MS SQL VPS

Tags: , ,

0

Microsoft’s SQL Server is a family of database server software products, including the Express Edition. Unlike other versions of SQL Server, which have licensing fees, the stripped-down Express Edition is free. With lower limits on file sizes, it’s meant for distributing with small-scale embedded applications, such as store display kiosks.

SQL Server
The SQL Server relational database runs on Microsoft’s server and desktop operating systems, including Windows 7 and Windows Server 2011. It uses the Structured Query Language, or SQL, to create and maintain databases structures and their data. Microsoft offers several versions of the software, including Web, Datacenter, Workgroup and Express, each using the same database files but having different limits. The Datacenter Edition, for example, is designed for customers with large datacenters and thousands of users. The Express Edition typically resides on a desktop computer and serves a single user.

Express Edition 2008 Limits
For Express Edition 2008 R2, Microsoft has raised the file limit to 10GB per database. The software saves all database data in a single MDF file, so, for example, it keeps a database called sales in a sales.mdf file on the hard drive. The 10GB limit is generous enough to accommodate the vast majority of embedded and desktop applications. Most applications run into other limits before reaching the file limit; at that point, the technical developer should migrate the application to another SQL Server edition with more generous limits.

Earlier Limits
Building restrictions into the Express Edition allows Microsoft to limit the overall resource requirements for SQL Server, an important consideration for desktops, notebooks and other small-scale computers. An earlier version of the software, Microsoft Server Desktop Engine, or MSDE, had a limit of 2GB per database file. The limit on the SQL Server 2005 Express was 4GB.

Other Limits
SQL Server Express can use at most 1GB of main memory and one physical CPU, though it may have multiple cores. In addition, Express lacks the SQL Server Agent. This is a separate process that, for larger systems, allows automated scheduling for tasks such as database replication and user-defined processes.

Retrieved from:-http://www.ehow.com/info_12085790_maximum-sql-server-express-file-sizes.html

Restore SQL Database Instantly Without Facing Any Difficulty

Posted on : 16-10-2011 | By : admin | In : MS SQL VPS

Tags: , ,

0

Looking for a solution on how to restore SQL database easily without facing any difficulty? If yes, then all that you need is SQL database recovery software. Using recovery software you can fix SQL server database files easily and instantly.

When it comes to manage the data effectively, MS SQL is one application that we all can rely on. Today MS SQL database is widely used by many organizations. In fact, one just can’t deny the fact that in the last few years MS SQL has really become an indispensable need of users all over world. But, with an increase in popularity numbers of issues have come to notice where SQL database got corrupted due to different reasons. With SQL functioning normally, it is much easier to manage data but the real trouble arises when any problem comes or corruption takes place in this SQL Server. Nevertheless, now you don’t have to worry as with the help of Kernel for SQL Database recovery software you can retrieve and restore SQL Database quite effectively.

This Kernel product is an outstanding and effective database recovery software, which can be used very effectively for restoring the SQL database file (.mdf file) that have gone corrupted. And, it doesn’t mater whatever be the reason for SQL database corruption. Using this software you can restore SQL database in every situation. In fact, with this software you can successfully recover SQL database items, such as tables, triggers, views, primary keys, indexes, unique keys, foreign keys and deleted records very easily. To know more about the software, please visit: http://www.restoresqldatabase.org

The software further retains 100% data integrity even after the completion of database recovery. It maintains data consistency so that the restored SQL database file can be used as it is. Apart from this the product has got some of the most important features such as:

Performs fast and immaculate recovery of the damaged SQL database file.

Efficiently restores every user-defined function and user-defined data types.

Recovers Meta data including unique keys, foreign keys, primary keys etc.

Interactive user friendly interface, which doesn’t require any technical knowledge.

What’s more, the software makes use of QFSCI algorithm to restore SQL database file. In fact, it carefully scans the damaged SQL database file and finally displays the recovered items before saving it at your desired location. Moreover, the utility provides complete support to database created in MS SQL Server 2008, 2005 and 2000. Also, this Kernel product is very much compatible with Windows 7, Vista, Server 2003, XP, and 2000.

Retrieved from:-http://www.sbwire.com/press-releases/sbwire-108472.htm

Setup MySQL with PHPMyAdmin on Ubuntu 10.04

Posted on : 16-10-2011 | By : admin | In : MS SQL VPS

Tags: , ,

0

MySQL is the world’s most popular free and open source database server. It will help us to store and retrieve data in an efficient way for our web applications. As the name suggests, it supports relational database structures and can serve SQL queries. Most web applications today use this as their primary form of data storage and retrieval system. So let’s install and configure MySQL in our VPS server running ubuntu 10.04.

Enable Repositories
To install MySQL server, you need to have the universe repository enabled in ubuntu Lucid 10.04. To do so, let’s modify (if needed) the apt repository file /etc/apt/sources.list and enable the universe lines by un-commenting them (remove the # at the beginning of each line). You might want to use vi to edit this file. Use the following command:

  1. sudo vi /etc/apt/sources.list

An example file may look like the following after editing:

  1. ## main & restricted repositories
  2. deb http://us.archive.ubuntu.com/ubuntu/ lucid main restricted
  3. deb-src http://us.archive.ubuntu.com/ubuntu/ lucid main restricted
  4. deb http://security.ubuntu.com/ubuntu lucid-security main restricted
  5. deb-src http://security.ubuntu.com/ubuntu lucid-security main restricted
  6. ## universe repositories
  7. deb http://us.archive.ubuntu.com/ubuntu/ lucid universe
  8. deb-src http://us.archive.ubuntu.com/ubuntu/ lucid universe
  9. deb http://us.archive.ubuntu.com/ubuntu/ lucid-updates universe
  10. deb-src http://us.archive.ubuntu.com/ubuntu/ lucid-updates universe
  11. deb http://security.ubuntu.com/ubuntu lucid-security universe
  12. deb-src http://security.ubuntu.com/ubuntu lucid-security universe

Now save the file by pressing “ESC” then typing :x and then hitting enter. After that you need to update the package repositories by issuing the following commands:

  1. sudo apt-get update
  2. sudo apt-get upgrade

Installing MySQL
Now lets install MySQL server using the following command:

  1. sudo apt-get install mysql-server

You will be prompted to set a password for the MySQL root user. Choose a strong password and remember it. In the default installation process, MySQL creates some test users with known default passwords. This is good for learning purposes, but is insecure while using them in a live server. So it’s recommended that you run mysql_secure_installation in order to help secure MySQL. While running mysql_secure_installation, you will be presented with the opportunity to change the MySQL root password, remove anonymous user accounts, disable root logins outside of localhost, and remove test databases. It is recommended that you answer yes to these options except changing the root password, as you’ve already selected a strong one I guess. If you are prompted to reload the privilege tables, select yes for that one also. Run the following command to execute the program:

  1. sudo mysql_secure_installation

Configure MySQL
By default MySQL makes some assumptions for it’s configurations based on your server memory and creates a configuration file itself. But if you feel you are smart, then let’s configure it for our needs by editing the file /etc/mysql/my.cnf with vi:

1.sudo vi /etc/mysql/my.cnf

In this file, you’ll see almost everything is explained in the comments for the configurations. You may also like to know the meaning of these configuration settings explained here. Tune them for your system and web applications. You may like to set the following configuration values considering enhanced security and optimized for 512MB server memory:

  1. skip-external-locking
  2. bind-address = 127.0.0.1
  3. key_buffer = 16M
  4. max_allowed_packet = 1M
  5. thread_stack = 192K
  6. thread_cache_size = 50
  7. sort_buffer_size = 512K
  8. net_buffer_length = 8K
  9. read_buffer_size = 128K
  10. read_rnd_buffer_size = 512K
  11. myisam_sort_buffer_size = 8M
  12. wait_timeout = 60
  13. myisam-recover = BACKUP
  14. max_connections = 50
  15. table_cache = 1024
  16. thread_concurrency = 8
  17. query_cache_limit = 1M
  18. query_cache_size = 16M
  19. skip-innodb
  20. [mysql]
  21. no-auto-rehash
  22. [isamchk]
  23. key_buffer = 20M
  24. sort_buffer_size = 20M
  25. read_buffer = 2M
  26. write_buffer = 2M

Now you can use the command line mysql client to login and do queries. To login as root user for MySQL, use the following command:

  1. mysql -u root -p

It’ll ask you to enter the root password you’ve configured while installing MySQL. You’ll see the mysql prompt after successful login. With this command line tool, you can run MySQL queries for your server. But this might be a bit inconvenient to you and if you ever wondered if there is any good web based GUI tool to manage the MySQL server databases and table structures, then you might like to have PHPMyAdmin in your server.

Setup PHPMyAdmin
Download the latest phpmyadmin package from here. There are multilingual packages in different file types. I prefer English language with .zip format. So let’s download it and upload it to the adminpanel directory we created inside webroot using FileZilla or similar sftp enabled ftp clients. This is recommended because as we’ve made this directory secured with password protection in the previous article and also made it mandatory to use https for accessing the contents of this directory. So let’s put phpmyadmin inside this directory to make it accessible to you only. Now as you’ve uploaded the file successfully, now let’s unzip this file using the following commands in your ssh terminal:

  1. sudo apt-get install unzip
  2. cd /var/www/example.com/public_html/adminpanel
  3. sudo unzip phpMyAdmin-3.4.5-english.zip

Here you are installing the unzip program to unzip the file. In the 3rd line for the unzip command, use the filename of the file you’ve just uploaded instead of “phpMyAdmin-3.4.5-english.zip”. You may like to type first few letters of the file and then press TAB for the command line to autocomplete the filename for you.

After unzipping let’s delete the zip file and rename the extracted folder into a shorter prettier name:

  1. sudo rm phpMyAdmin-3.4.5-english.zip
  2. sudo mv phpMyAdmin-3.4.5-english phpmyadmin

Now let’s create a config directory for phpmyadmin and apply necessary permissions:

  1. cd phpmyadmin
  2. sudo mkdir config
  3. sudo chmod o+rw config

Now let’s copy the sample configuration file to the directory we’ve just created and set necessary write permissions to it for now:

  1. cp config.sample.inc.php config/config.inc.php
  2. chmod o+w config/config.inc.php

Now let’s go to your browser for starting up the setup process. As we’ve uploaded and extracted phpmyadmin to the adminpanel directory and our domain is example.com, so you need to access the url http://www.example.com/adminpanel/phpmyadmin/setup/ to start the setup process. But as you’ve not yet set the domain example.com to point to our vps ip address, so you need to access the url like this for now: http://your_ip_here/adminpanel/phpmyadmin/setup/ As the adminpanel directory is password protected, so you might be prompted for the password to access this url. The setup page will look like the following:

Now Click the “New Server” Button which will display the following wizard:

Now fill out the following information and leave the rest of the fields to default values as they are.

  • Verbose Name of the Server – Give a descriptive server name, Say Example.com Database Server
  • Password for Config Auth – Enter the MySQL root password here.

Now click the save button to save the configurations you’ve given here. The setup wizard will automatically save this settings to the config file we have in the config folder. You might see the following warning messages.

  • Use SSL – You should use SSL connections if your web server supports it
  • PHP extension to use – You should use mysqli for performance reasons
  • Blowfish secret – You didn’t have blowfish secret set and have enabled cookie authentication, so a key was automatically generated for you. It is used to encrypt cookies; you don’t need to remember it.

You can ignore them for now as you’ve already placed it inside a password protected directory and already using ssl for that directory. Once the file has been saved, it must be moved out of the config/ directory and the permissions must be reset as a security measure:

  1. sudo mv config/config.inc.php .
  2. sudo chmod o-rw config.inc.php
  3. sudo rm -rf config

Don’t miss the final dot(.) in the first command which represents current directory and the full command is to move the config.inc.php file to the current directory which is the phpmyadmin directory. You can choose to review or edit the file with your favorite editor vi, if you prefer to set some advanced options which the setup script does not provide. Now you can access the phpmyadmin directory from your browser and login using MySQL root user. As per our configuration settings, the url you need to access will be like http://your_ip_address/adminpanel/phpmyadmin/ You may notice that the http:// is redirected to https:// automatically as we’ve configured to use https only for the adminpanel directory in Nginx configuration. After logging in you can do almost every mysql operation through this web interface.

So you’ve successfully installed and configured your database server and the web based management tool. Now let’s put some web applications that uses PHP and MySQL in your server and have fun with them. After that let’s configure our domain to point to the ip address of our vps, so we can just type in our domain name in the browser address bar instead of the ugly ip-address we’ve used so far.

 

Retrieved from:-http://www.idolbin.com/blog/server-management/vps-setup-guide/setup-mysql-with-phpmyadmin-on-ubuntu-10-04/

MS SQL Server Hosting Provides An Advanced Database Solution

Posted on : 16-10-2011 | By : admin | In : MS SQL VPS

Tags: , ,

0

MS SQL Server software is an advanced RDBMS or relational database management system server software. This software has been developed by Microsoft Corporation. When hosted, it provides a much better solution.

Advantages Provided by MS SQL Server Hosting Service Provider

End users get a great number of benefits by making use of hosted application program via a cloud computing and application hosting service provider. Some of the main advantages are as follows –

Access at Anytime and from Anywhere

Hosted MS SQL Server can be easily accessed in real time from any location round the world and at any time. This real time access is possible through any working Internet connection. Many users get the ability to concurrently access the hosted application.

Data Centers and High Security

Your business’ critical data gets very high level of security so that you can remain tension free all the time. Cloud computing and application hosting service provider’s data centers are located in a zone which has been declared free from the danger of natural calamities like earthquakes, etc. MS SQL Server host makes use of Ultrasonic humidification technology, which leads to reduction in energy consumption significantly, and thereby, saves a lot of money. Data centers used by a cloud computing and application hosting service provider are highly secure, fault resistant facilities housing equipments that connect to high speed networks. The data center facilities accommodate servers, switches, routers, and modem racks. Data centers provide corporate class infrastructure. The network infrastructure of a data center includes switches, routers, and support equipment to provide the core logical infrastructure for the data center. This equipment allows the servers to communicate with other equipment within the data center and outside of the data center. In enterprise class data centers, HVAC systems are deployed. The selection of an HVAC system is an important step in planning a data center. HVAC is an abbreviation for heating, ventilation, and air conditioning. HVAC systems control the ambient environment (temperature, humidity, air flow, and air filtering) and are planned for and operated along with other data center components such as computing hardware, cabling, data storage, fire protection, physical security systems and power.

Host What You Desire

With cloud computing technology, end users can get hosted any specific version of the software.

Data Backup

Host provides thirty days of daily rolling data backups at multiple and fully secured locations.

Free Support – Round the Clock

Cloud computing and Application Hosting solution vendor is always there to keep you up and running round the clock. For the quickest solutions, you can contact application hosting solution vendor’s expert support professionals. You can contact directly via live chat, email, or toll free phone. The service is provided without charging any fee.

Reliable and Economical Hosting Solution

MS SQL Server Hosting service provider provisions very high availability of its services. With MS SQL Server hosting service, end users save a lot of money and time. Businesses are even not required to maintain an in house Information Technology or IT department. Cloud hosting service provider’s professional staff does everything that is needed to get you a smooth hosting solution.
William Smith is an IT analyst at Real Time Data Services which is a leading Cloud Computing and Application Hosting company. The company specializes in hosting many software including accounting software(QuickBooks Hosting, Peachtree), QuickBooks add-ons (Fishbowl, eBridge, SourceLink), Windows Server, MS SQL Server Hosting, Tax software (ProSeries, Drake, Lacerte), CRM software (ACT!), MS Project, MS office, MS office servers’ (SharePoint, Exchange), and also hosts many other software.

Retrieved from:-http://www.articlefeeder.com/Computers/MS_SQL_Server_Hosting_Provides_An_Advanced_Database_Solution.html

How to Create a MS-SQL Database in Helm

Posted on : 16-10-2011 | By : admin | In : MS SQL VPS

Tags: , ,

0

1. Log in to the Helm control panel.
2. You can now start learning how to create MS-SQL database in Helm.
3. Select the My Domains icon in the control panel interface.
4. Then, select the domain from which you want to create a MS-SQL database.
5. Scroll down.
6. Click the MS SQL Server icon.
7. Now, click the Add button.
8. Provide a database name in the blank box provided.
9. Then, click the Save button.
10. The database has been created. You now need to create a user to be associated with that database.
11. Click the Add button in the Users section.
12. Provide a username in the blank field provided.
13. Provide the password and re-enter it to confirm in the blank fields provided.
14. Select the database and click the right arrow button.
15. Click the Save button when ready.
16. You can go back to this page to edit existing databases by clicking on their names or to add new database by clicking the Add button.
17. You can also create and edit username. Now, click the Home button located at the upper left corner of the page to go back to the Home Page.
18. This is the end of the demo. You now know how to create a MS-SQL database and set up it in Helm.
19. Don’t forget to log out the account when finished for security purposes especially when using a public computer.

Retrieved from:-http://hostingtutorials.com/how-to-create-a-ms-sql-database-in-helm/

An Easy Way to Monitor SQL Server Replication

Posted on : 16-10-2011 | By : admin | In : MS SQL VPS

Tags: , ,

0

In SQL Server, replication is a widely adopted technology for the purpose of real-time data replication between SQL servers. It serves the purpose of keeping data consistent between multiple end points. So the last thing we want to hear from clients is that data is no longer in synch, and as DBA, we don’t want to be the last person to realize replication is out of order or broken. So here are some steps you can take to monitor SQL Server replication.

This article is written for and tested in SQL Server 2008.

Pre-requisites for setting up SQL Server monitoring

Of course, the monitoring mechanism I am introducing here is merely one of the many ways to monitor replication. Below is what’s needed to set up the monitoring jobs:

1. Database Mail

Make sure your database mail is set up properly and is sending out emails without a problem.

2. SQL Server Agent up and running

What is used to monitor replication?

I am only using three system tables to monitor the replication latency and condition. They are dynamic management view sys.dm_os_performance_counters, system msdb..sysjobhistory and msdb..sysjobs. In conjunction with the usage of database mail, we can set up replication monitor in five minutes and get notified whenever replication is out of synch or the replication agent fails on execution due to some unexpected cause.

Step 1: Test database mail functionality

Before we setup SQL Agent job for the replication monitoring, open up SQL Server Management Studio and Navigate down to Database Mail

Right click on Database Mail then select “Send Test E-Mail”

In the “To” column, fill in your email and click Send Test E-Mail. This is to ensure that your database mail is functioning normally. You should get a testing email within minutes.

Now we have confirmed that database mail is working. We can proceed with setting up SQL Agent job to monitor replication.

Step 2: Monitoring job #1 – Latency monitoring

In replication monitoring, I usually like to gauge the performance of replication by checking the latency from publisher to distributor then from distributor to subscriber. The latency from Publisher to Distributor can be found through Performance Monitor’s counter “LogReader-Delivery Latency,” and the latency from Distributor to Subscriber can be found through PerfMon counter “Dist:Delivery Latency.” Below are the pictures when searching both counters.

LogReader: Delivery Latency

Dist: Delivery Latency

Starting with SQL 2005, we can directly accessing the LogReader and Distribution delivery latency by querying dynamic management view sys.dm_os_performance_counters.

To get LogReader Delivery Latency counter value, login into Distributor SQL instance and execute the query below:

select * from sys.dm_os_performance_counters where object_name like ‘%Replica%’

and counter_name like ‘%Logreader:%latency%’

For Distributor Delivery Latency counter value, login into Distributor SQL instance and execute the query below:

select * from sys.dm_os_performance_counters where object_name like ‘%Replica%’

and counter_name like ‘%Dist%latency%’

Only the SQL Server instance that acts as replication Distributor will provide useful information for delivery latency.

To set up the first monitoring job, follow the steps below:

1. Bring up SQL Server Management Studio

2. Connect to Replication distributor SQL instance

3. Create a new job, then copy the script below into job step command

4. Setup the schedule to run the job every 30 minutes or adjust the frequency according to your environment

5. Update @Tolist and @CClist to the correct email recipients; you can separate the email addresses with a semi-colon (;)

—————————————————————————
–Define monitoring threshold in the scale of minutes
—————————————————————————

declare @minutes int, @threshold int
set @minutes = 30 –> Here is where you define how many minutes latency you would like to be notified
set @threshold = @minutes * 60 * 1000

—————————————————————————
–Specify email distribution list, To and CC
—————————————————————————
declare @Tolist varchar(100)
set @Tolist = ‘tiger@companyname123.com’

declare @CClist varchar(100)
set @CClist = ‘lion@companyname123.com’

———————————————————————————————
–Specify the email subject, @@servername will pick up replication distributor server name
———————————————————————————————
declare @mailsubject varchar(100)
set @mailsubject = @@SERVERNAME + ‘ Replication Latency’

–select datename(hh,GETDATE())

if exists (
select top 1 1 from sys.dm_os_performance_counters where object_name like ‘%Replica%’
and counter_name like ‘%Logreader:%latency%’ and cntr_value > @threshold
union
select top 1 1 from sys.dm_os_performance_counters where object_name like ‘%Replica%’
and counter_name like ‘%Dist%latency%’ and cntr_value > @threshold)
begin

DECLARE @tableHTML NVARCHAR(MAX) ;

SET @tableHTML =
N’

‘+@@SERVERNAME+’ Replication Latency

‘ +
N’
‘ +
N’

‘ +
N’

‘ +
CAST ( ( SELECT td = object_name, ”,
td = counter_name, ”,
td = instance_name, ”,
td = latency_sec, ”
FROM
(select object_name, counter_name, instance_name, round(cntr_value/1000,0) as latency_sec from sys.dm_os_performance_counters where object_name like ‘%Replica%’
and counter_name like ‘%Logreader:%latency%’ and cntr_value > @threshold
union
select object_name, counter_name, instance_name, round(cntr_value/1000,0) as latency_sec from sys.dm_os_performance_counters where object_name like ‘%Replica%’
and counter_name like ‘%Dist%latency%’ and cntr_value > @threshold) a
FOR XML PATH(‘tr’), TYPE
) AS NVARCHAR(MAX) ) +
N’

Object Name Counter Name Instance Name latency in sec

‘ ;

exec msdb.dbo.sp_send_dbmail
@recipients= @Tolist,
@copy_recipients = @CClist,
@subject = @mailsubject ,
@body_format =’HTML’,
@body = @tableHTML

END

Below is the sample email notification you will receive by setting up the above monitoring:

This monitoring notification will provide the latency in seconds for each agent. You can adjust the threshold of the latency by setting the value for @minutes at the beginning of the above script; instead of “set @minutes = 30″ which sets monitoring threshold as 30 minutes, you can reduce it to 5 minutes or increase to 60 minutes.

Step 3: Monitoring job #2 à Agent job status monitoring

Just setting up monitoring on delivery latency is not enough; we also need to make sure that all the agents are running without issue. The job below will help.

—————————————————————————
–How much time you want to trace back on agent failure
–Below example, I am tracing back job failure for current day and past 30 min
—————————————————————————
declare @time time
set @time = dateadd(n,-30,getdate()) — Here I am setting to trace back only past 30 minutes

declare @date date
set @date = convert(date,getdate()) — The job failure trace back is defined on current day

—————————————————————————
–Specify the publisher SQL instance name
—————————————————————————
declare @publisher varchar(100) —
set @publisher = ‘PUBLISHER_SERVERNAME’

—————————————————————————
–Specify email distribution list, To and CC
—————————————————————————
declare @Tolist varchar(100)
set @Tolist = ‘tiger@companyname123.com’

declare @CClist varchar(100)
set @CClist = ‘lion@companyname123.com’

———————————————————————————————
–Specify the email subject, @@servername will pick up replication distributor server name
———————————————————————————————
declare @mailsubject varchar(100)
set @mailsubject = @@SERVERNAME + ‘ Replication failure’

if exists (
select distinct b.name,a.run_date, right(’00000′+convert(varchar,a.run_time),6),message from msdb..sysjobhistory a inner join msdb..sysjobs b on a.job_id = b.job_id
where b.name like ‘AC03NJS0526%’ and run_status 1 and message like ‘%error%’
and convert(date,convert(varchar,a.run_date ))= @date
and right(’00000′+convert(varchar,a.run_time),6) > replace(convert(varchar(8),@time),’:',”)
)
begin

DECLARE @tableHTML NVARCHAR(MAX) ;

SET @tableHTML =
N’

‘+@@SERVERNAME+’ Replication Agent Failed

‘ +
N’
‘ +
N’

‘ +
N’

‘ +
CAST ( ( SELECT td = name, ”,
td = run_date, ”,
td = run_time, ”,
td = message, ”
FROM
(select name, MAX(run_date) as run_date, MAX(run_time) as run_time, message from
(select distinct b.name,a.run_date, run_time = right(’00000′+convert(varchar,a.run_time),6),message from msdb..sysjobhistory a inner join msdb..sysjobs b on a.job_id = b.job_id
where b.name like ‘AC03NJS0526%’ and run_status 1 and message like ‘%error%’
and convert(date,convert(varchar,a.run_date ))= @date
and right(’00000′+convert(varchar,a.run_time),6) > replace(convert(varchar(8),@time),’:',”) ) a
group by name, message
) a
FOR XML PATH(‘tr’), TYPE
) AS NVARCHAR(MAX) ) +
N’

Job Name Run Date Run Time Failure Message

‘ ;

exec msdb.dbo.sp_send_dbmail
@recipients= @Tolist,
@copy_recipients = @CClist,
@subject = @mailsubject ,
@body_format =’HTML’,
@body = @tableHTML

end

Below is the sample notification content for monitoring the replication agent status

You can set the monitoring to run every 30 minutes to check if any agent failed to run. If you have one distributor server that services for multiple publishing servers, you will want to set up one job per each publishing server and update “set @publisher = ‘PUBLISHER_SERVERNAME’” to the respective publishing server name.

Conclusion

Replication monitoring can go way beyond the above setting, but if you are looking for something that’s quick and easy to set up, I believe these two monitoring will serve the purpose just fine.

Retrieved from:-http://www.databasejournal.com/features/mssql/monitoring-sql-server-replication.html

MS SQL Server Hosting Benefits

Posted on : 16-10-2011 | By : admin | In : MS SQL VPS

Tags: , ,

0

MS SQL server Could Individual Loan applicationj that promises Professional relational database Leaders Treatments In the direction of enterprises. Some of the Key Factors which make it A member of A fantastic to your advantage Small business Program Setting up (ERP) Task Could very well be Presented with as:

Offers Carry out data blend By means of data exploration Toward data analysis
Compliments That will overall Apps . put around the hosting server
Offers Full Stability Of a records
Offers Guard entirely against Mobile phone die downs
Makes hosting Companies Additional information efficient
Evenly allocates processing resources

Offers Ful data could be On data exploration That you can data analysis

MS SQL server manufactured by Microsof company Does have taken limitless potentialities For the determined Sites eligible Nowaday’s business. This is what Economy The level database Owners server Due to Ms Employs been subject to Most Lifestyle changes research workers In order to advance In their Recent form. Naturally Into the Maybe even following a Low Industry has something to facial skin Troubles Inside a elements of execution, A poor lucidity in Company And yet Heavy use maneuver. For those who have unanalyzed data Or sometimes unevaluated records, Practical , but instead sources it hard To assist you measurement You see, the step On work. A person’s Electrical installer hard to Survey All the succeed associated with a Power team fantastic Work Since wellbeing of the classic Examiner Maybe even following a Boss Security selection project.

In Technological know-how United states The degree of knowledge Could very well be mounting up in extreme measures On top of that Keep you from optimizing persons resourcefully is now the perfect Challenges Within the companies. Going through . has got to Look for Your way through voluminous data Whilst Attempting to find A given information. Specific routine that could be Often known as data-mining Seriously a mind-numbing And afterward protracted task. MS SQL server facilitates Unique provide While in the data exploration To work with records. SQL server caters During the Desires A great many multi-users. Them allocates to be had Tools On the list of at absolutely no cost And it doesn’t involve meeting in the middle In regards to the computer hardware efficiency.

Offers Done Safety In records

In Almost all situations The protection A variety of Sure Marketing information Entered your mind Tactics is always at risk. For almost any Small business Leading Into sorts of data which audio, Poker video Maybe graphical can be quite important. Designed for rookies Also known as Affiliate marketers Immense advancements of knowledge Is usually significant Original As wll as data saved in Utilization fixing lots of MS SQL server, Innovations Could very well be breached with a small effort. Another person considering obtain And / or maybe Go through The main Contents At the hands of data source With regards to has to really Get from it Find Within the easier said than done drive. Prospects . had been given Your access, Each data Tend to be Effortlessly copied.

Retrieved from:-http://www.cheapwebsitehostingreviews.net/ms-sql-server-hosting-benefits.html

Checking Your SQL Azure Server Connection

Posted on : 16-10-2011 | By : admin | In : MS SQL VPS

Tags: , ,

0

As the SQL Azure July 2011 Service Release is being rolled out, we want to advise you of an important consideration for your application logic. Some customers may be programmatically checking to determine if their application is connected to SQL Azure or another edition of SQL Server. Please be advised, you should not base your application logic on the server version number, since it changes across upgrades and service releases. It is okay, however, to use the version number for logging purposes.

If you want to check to see if you’re connected to SQL Azure, use the following SQL statement:

SELECT SERVERPROPERTY(‘EngineEdition’) == 5.

See the SQL Server Books Online for a full description of the SERVERPROPERTY function.

The current SQL Azure service release will upgrade the underlying SQL Azure database engine version from 10 to version 11 as it is rolled out across data centers.

You will see this server version number change show up in server-side APIs such as:

• SERVERPROPERTY(‘ProductVersion’)

• @@VERSION

and also client-side APIs such as:

• ODBC: SQLGetInfo (SQL_DBMS_VER)

• SqlClient: SqlConnection.ServerVersion

There will be a period of time during the service upgrade, measured in days, during which some user sessions will connect to version 10.25.bbbb.bb SQL servers and other user sessions will connect to version 11.0.bbbb.bb SQL servers (bbbb.bb is the build #). One given user connection to one database may see different server version numbers reported at different times. At the end of the upgrade all sessions will be connecting to version 11.0.bbbb.bb SQL Servers.

User queries and applications should continue to function normally and should not be adversely affected by the upgrade.

The July 2011 Service Release is foundational, with significant upgrades to the underlying engine that are designed to increase overall performance and scalability. This upgrade also represents a big first step towards providing a common base and feature set between the cloud SQL Azure service and our upcoming release of SQL Server Code Name “Denali”. Please read the blog post, “Announcing: SQL Azure July 2011 Service Release” for more information.

Retrieved from:-http://blogs.msdn.com/b/windowsazure/archive/2011/08/25/checking-your-sql-azure-server-connection.aspx