|
|
-
|
|
On Day 4 we covered a lot of index internals and statistics. I was in particular able to understand filtered indexes and statistics in a lot of detail, seemed like features that would be of great benefit to DBAs who knew their data and queries intimately well and need to fine tune a lot. I felt part......
|
|
-
|
|
<p>Yesterday we covered database structures and transaction logging. I learnt a ton of great stuff on the latter especially and need to experiment with it a lot. It is tempting to 'bullet point' the 'aha' moments but somehow am trying to avoid that and keep it for my own deep dives and explorations ......
|
|
-
|
|
I have had the good fortune of attending the first of the 4 'immersion events' conducted by http://sqlskills.com (Paul Randal and Kimberly Tripp). The first event is on Internals and Performance Tuning, and started off this week at Dallas, TX. To give readers an idea - I do not have any ambitious pl......
|
|
-
|
|
We held a day long SQL Saturday event at Louisville, KY on January 22nd, 2011. Below are most common experiences and lessons learnt from this event.
Event Overview: We had a registered attendee count of 220 people, nearly 170 showed aup which is more than what we expected. The event was held at Co......
|
|
-
|
|
There have been lot of posts written on this. During the PASS conference i learnt a new way in SQL Server 2008 to find the start date. That led me to summarize all the ways in TSQL to find the date and time the server was started.
1 2005/08: SELECT create_date FROM sys.databases WHERE name = 'temp......
|
|
-
|
|
One of the commonly audited and most risky security issue is to have an id without a password. This can be avoided by turning windows security on for windows authenticated passwords but still those of us who have mixed mode authentication still have to risk having this. One of the most popular tools......
|
|
-
|
|
It is fairly known to most long term DBAs that DBCC log and ::fn_dblog function are undocumented commands used to read the transaction log. What I learnt in the PASS conference this time was that undocumented - means unsupported AND not used in any white paper or reference material by Microsoft. (T......
|
|
-
|
|
Learning Performance Counters : Memory/Available Mbytes and Pages/Sec.
Introduction
I firmly believe a DBA is only as good as how well he/she knows Performance Counters. I have been wanting to blog/learn on them for a long time and thought would start with the list of important counters as listed......
|
|
-
|
|
In this post I would like to share some thoughts on differences between work ethic in India and the United States. These are just some lessons I have learnt the hard way, lessons I wish someone had told me when I was new to States after 10+ years of working in India. These are only generalizations a......
|
|
-
|
|
Malathi Mahadevan works as a Senior DBA with Kindred Healthcare – a healthcare services company based out of Louisville, KY and ranked first in Fortune magazine's Most Admired Companies "Health Care: Medical Facilities" category. She is the founder-lead of the local chapter of Professional A......
|
|