Posts Tagged ‘sql server’

Opportunity to write about Microsoft SQL Server

Posted: 21st January 2011 by Deepak in SQL BI/DW/SSRS, SQL DBA, SQL Dev, Uncategorized
Tags: , , ,
0

Do you have something to write about SQL Server that can help SQL community by your learning, innovation. R&d, research etc. This is an unique opportunity to reach a large group of SQL Server users, gain experience as SQL writer, publicity and much more. Drop an email with your content/summary to dk@sqlknowledge.com I will review [...]

Monitoring & Setting Alerts for SQL Server Critical Errors

Posted: 20th January 2011 by Deepak in Scripts, SQL BI/DW/SSRS, SQL DBA, SQL Dev, Uncategorized
Tags: , , , , , , ,
0

As a Proactive DBA, you must monitor All SQL Server errors having severity level between 17 to 25. Any errors from level 20 to 25 are serious in nature however for 17 to 19 a DBA involvement is required for resolution. Here is self explanatory MS description of error levels, steps to get automatic alert [...]

What you ‘Currently’ don’t get with SQL Azure?

Posted: 21st December 2010 by Deepak in SQL DBA, Uncategorized
Tags: , , , , , , ,
0

SQL Azure is cloud based relational database platform built on SQL Server technology; it allows storing structured, semi-structured and unstructured data over the cloud. Behind the scene databases are hosted on cluster SQL servers, and are load balanced plus replicated for scalability & high availability purposes. Each logical Server consists of one master and N [...]

Script to find used and free space in Database files

Posted: 2nd August 2010 by Deepak in Scripts, SQL BI/DW/SSRS, SQL DBA, SQL Dev, Uncategorized
Tags: , , , , , , , , , ,
0

In an Enterprise world, you may be responsible to monitor 1000+ databases hosted on hundreds of SQL Server instances. On a lazy afternoon, suddenly low disk space alarm hit your inbox. What will you do, storage can not be added or expended on the fly. Here is the tested script to find used and free [...]

Database Logshipping issues & Considerations!

Posted: 4th June 2010 by Deepak in SQL DBA, Uncategorized
Tags: , , , , , , ,
0

While working on SQL Server logshipping a DBA must consider following points to have log shipping setup running smoothly over a long period of time. Logshipping architect will look like: Transaction log Backup and restoration jobs should work constantly (in parallel) and if backup/restoration jobs are not in sync due to network/server or any other [...]