-
Recent Posts
Archives
- December 2016 (1)
- May 2016 (1)
- March 2016 (1)
- February 2016 (4)
- January 2016 (2)
- December 2015 (3)
- November 2015 (4)
- October 2014 (1)
- March 2014 (2)
- February 2014 (7)
Tag Archives: database
Recipe for Disaster
Happy New year to everyone. With a new year, here I start the year with a blog post talking about a common recipe for disaster waiting to happen with your SQL Servers. By default, SQL Server’s databases are installed on … Continue reading
Posted in Best Practices, ms sql, Performance Tuning, Troubleshooting, Uncategorized
Tagged configuration, database, DBA, ms sql, performance, performance tuning, SQL, sql server, troubleshoot, tuning
Leave a comment
SQL Server Storage Report
When working with Oracle databases, especially Oracle Cloud Control 12C, it was easy enough for me to generate a daily report early morning that would be mailed to all the stakeholders regarding the Storage Usage for all the Oracle instances. … Continue reading
How To Identify The Source Of Page Splits
In my last post I talked about how one could go about troubleshooting an issue in SQL Server, and today I would like to talk about one of the common issues that most DBA’s come across their professional career, Page … Continue reading
Posted in ms sql, Performance Tuning, Troubleshooting
Tagged database, DBA, ms sql, performance, performance tuning, Query, Session, SQL, sql server, troubleshoot, tuning
Leave a comment
Troubleshoot Your SQL Server
Hi Everyone. I wanted to ask a question before I begin my post today. And the question is: When you’re trying to troubleshoot SQL Server, Where do you start looking? This is one of the most hardest question to answer … Continue reading
Posted in Best Practices, ms sql, Performance Tuning, Troubleshooting, Uncategorized
Tagged database, DBA, ms sql, performance, performance tuning, SQL, sql server, troubleshoot, tuning
Leave a comment
You’re a DBA, you should know these
How many databases are you responsible for? How many different version do you support? How much data have we handled this month? How much capacity will we need next year? What new IT techniques will help you get there? These … Continue reading
Posted in Best Practices, ms sql, Uncategorized
Tagged agent, backup, configuration, database, DBA, metrics, ms sql, SQL, sql server, sql server agent
Leave a comment
Better…..Faster….SQL Server Backups
Ever since I phased out the legacy backup system in one of my recent projects with a centralized SQL Server backup solution, I have been asked by many people regarding the results that I got from the transition. To put … Continue reading
Posted in backup, Best Practices, ms sql
Tagged backup, database, DBA, ms sql, performance, SQL, sql server, tuning
1 Comment
Find the locks
There are many blog posts on the internet that have explained time and again regarding this topic. Many of them are pretty basic stuff while some of them are quite advanced. A while back I myself wrote a blog post … Continue reading