Apr
30
2013

Oracle to SQL Server Trigger Migration – Useful Tips

Today got a requirement to convert an Oracle trigger to SQL Server trigger, I have not worked on DDL triggers so did a check on code, it was pretty simple and alongside used few online conversion utilities (limited freeware conversion) which helped in achieving final results.   Image Courtesy: Manageengine.com   This post is not about writing all aspects of creating triggers; it is just about resources available to help in completing conversion.   First, […]

Apr
16
2013

Fix: Issue with SQL Agent not coming up due to agent error log path incorrect

SQL Server Agent was unable to come up and no error was being reported (only error we found as “SQL agent services started and then stopped”, nothing was logged in Event viewer as well), hence was unable to identify the actual error with which agent was failing, following is done to fix it,   1. Ran following command to read agent error log using query analyzer,                                 EXEC sys.xp_readerrorlog 0,2                 Output was: Msg 22004, […]

Mar
19
2013

Service Unavailable : HTTP Error 503. The service is unavailable

After applying SQL Server service pack on one of SQL Server 2008, faced situation when user reporting then he is unable to open his webpage, he was receiving following error,   HTTP Error 503. The service is unavailable     After restarting OS, IIS 7.5 services as well received same error, finally found the solution as,   1. Open the Internet Information Services (IIS) Manager 2. Select the Application Pools node under the root node […]

Feb
26
2013

Using EXCLUDE in NetBackup .bch script –SQL Server database backups

I was searching for a solution to exclude specific database from Symantec NetBackup .bch script for SQL Server database backups, there are two ways to excluded databases,   1. By using EXCLUDE parameter As per admin guide, Name of a database to exclude when DATABASE $ALL is specified in a batch operation EXCLUDE can be used in a batch file only if DATABASE $ALL is used.   Following is sample .bch file with some example […]

Feb
21
2013

Why there is separate package for SQL Native Client (SNAC) on cumulative update download page?

If you are wondering that Cumulative Update download page has a package for SNAC, should you download and install or not? Then probably you will find your answer below.   Everything about SNAC is clearly explained at following link, http://blogs.msdn.com/b/psssql/archive/2009/10/23/should-i-have-a-snac-with-my-cumulative-update.aspx   Just to brief it out,   What is SNAC? SNAC stands for SQL Native Client   Why separate package is there on download page? It is a package only to apply updates to native […]

Feb
20
2013

Enable Policy Based Management using Central Management Servers

While trying to configure policy based management (PBM) across 100+ SQL servers in my domain faced issue that by default you need to import policies on individual servers or evaluate by connecting to a central policy server. Although this dilemma was broken by the articles written by several DBA’s across several forums and communities that Central management server (CMS) can be used to deploy or evaluate policies across set of servers or all SQL servers […]

Feb
19
2013

How to become a Microsoft Most Valuable Professional (MVP)?

This question was haunting me from long that how to become an MVP, the simplest solution is CONTRIBUTE and SHARE!   The Microsoft Most Valuable Professional (MVP) Award is an annual award given to outstanding members of Microsoft’s technical communities based on contributions made during the previous 12 months to offline and online Microsoft-related technical communities.   More you can found on MVP FAQ’s available at http://mvp.support.microsoft.com/gp/mvpfaqs   If you think you or your friend […]

Feb
15
2013

The command failed because the database mirror is busy. Reissue the command later.

Issue: Trying to turn of database mirroring, disconnected mirroring from Principal database but when checked the partner Database, found that database still in restoring mode, when trying to delete it, it failed stating database is part of mirroring as below,     Then ran following command/s which resulted in error, ALTER DATABASE [STASxref] SET PARTNER OFF; ALTER DATABASE [STASxref] SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS;   Msg 1404, Level 16, State 11, Line 1 The command failed because […]

Feb
15
2013

Microsoft SQL Server on Private Cloud

While trying to identify a solution for an internal private cloud for a client and deploy SQL Server as a service on it, came across following articles which can provide some useful insight and references,   Microsoft provides certain case studies and articles at following link on private cloud, http://www.microsoft.com/en-us/sqlserver/solutions-technologies/hybrid-it/private-cloud.aspx   Microsoft with HP and Dell has provided Database consolidation and private cloud appliances as well, details at following link, http://www.microsoft.com/sqlserver/en/us/solutions-technologies/Appliances/HP-dca.aspx http://h71028.www7.hp.com/enterprise/us/en/partners/microsoft-database-consolidation-solution.html http://blogs.technet.com/b/dataplatforminsider/archive/2011/10/13/announcing-the-first-database-consolidation-amp-private-cloud-appliance.aspx   If […]

Feb
15
2013

Virtualizing Microsoft SQL on VMware vSphere

Useful resources for virtualizing your SQL Servers on VMWare ESX   http://www.vmware.com/solutions/business-critical-apps/sql-virtualization/microsoft-support.html   DBA Guide to Databases on VMware – White Paper Availability and Recovery Options for Microsoft SQL® on vSphere Best Practices Guide for Virtualizing SQL Server SQL Server on vSphere FAQ Support and Licensing Guide – SQL Server on vSphere SQL Server on vSphere – Use Cases VMware Performance Benchmarks and Resources Reference Architecture: EMC Business Continuity for SQL Server 2008 Reference Architecture: […]

Pages:«123456789...15»

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 24 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

October 2017
M T W T F S S
« Sep    
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

View Post by Categories

%d bloggers like this: