|
|
-
|
|
Yet another achievement (renewal) in my career! Glad to achieve 6th time in a row.
Dear Satya Jayanty,
Congratulations! We are pleased to present you with the 2011 Microsoft® MVP Award!
This award is given to exceptional technical community leaders who actively share their high quality, rea......
|
|
-
|
|
SQL Server Log Shipping is one of the essential task that every user must setup to offer disaster recovery (standby) for the databases. Since the version 2005 it has become easier and quicker way to setup using SQL Server Management studio.
Almost all the editions of SQL Server offer the log shippi......
|
|
-
|
|
How quickly you can get information on individual user activity and pin-point the processes that are causing blocking and performance issues?
As a DBA how many times you use Activity Monitor in your SQL Server platform?
Monitoring the SQL Server paltform activity is one of the key responsibility f......
|
|
-
|
|
Over 85 practical recipes for administering a high-performance SQL Server 2008 R2 system.
Book and <a href="https://www.packtpub.com/microsoft-sql-server-2008-r2-administration-c......
|
|
-
|
|
How often you see this message in your SQL Server platform error log?
SQL Server database recovery message: Analysis of database (No) is %% complete (approximately 0 seconds remain). This is an informational message only. No user action is required
When was the last time you had a database recov......
|
|
-
|
|
As a DBA you must keep this coin with two-side: Baseline and Benchmarking, irrespective of number of instances or databases that you support.
Lets call them as B&B (not bed and breakfast), because they are essential when you are dealing any performance problems.
In general getting know more ab......
|
|
-
|
|
Fragmentation - have you ever heard about it when you are dealing with databases.
Just talking on DBA perspective I would say fragmentation is dearest friend of database when you need to deal with Performance, so by using the DBCC statements and other methods here you can deal the database level ......
|
|
-
|
|
As a DBA How many times you had to deal with TEMPDB during performance montiroing?
As a Developer do you really care about TEMPDB when writing resource intensive queries?
Within the last year how many times you had to increase size of TEMPDB or add more physical space to the drive where TEMPDB is ......
|
|
-
|
|
For a minute I thought the error is related to network as it refers 'RequireKerberos' and 'SQL Network name', on top of that this is a SQL Server 2008 Failover clustering environment.
Both of these terms are registry based values that are used for kerberos authentication (if not available) then a n......
|
|
-
|
|
Every business has it's mission critical applications and data. Therefore, it is very important to keep database servers up and running all the time – 24 X 7. There is a need to store and process terabytes of data to cater for business needs, and it is vital to make data highly available.
Mic......
|
|