|
|
-
|
|
A couple of years ago, I heard some new terms: “10x developer” and “2x developer”.
A 10x developer seemed to complete tasks almost instantly. A 2x developer took a
long time to complete a task. These terms can also be applied to other jobs such
......
|
|
-
|
|
DBAs find it easier to manage large Database Server environments when checklists are used. This Stored procedure checklist will stimulate some ideas you could use
For acceptance into the SQL Server environment, I’ve developed some scripts that scan the T-SQL code for some items in this check......
|
|
-
|
|
Assuming the database was detached successfully, this t-sql code will attach a mdf file without a log file. It will also reattach the database with a new database name.
USE [master]
GO
CREATE DATABASE [myTestDatabase] ON
( FILENAME = N'E:\Program Files\Microsoft SQL Server\Data\MSSQL.1\MSSQL\D......
|
|
-
|
|
The Storage \ SAN administrator asks “ can I have some targets to aim for in testing
a new storage IO subsystem
installation”. Of course, as the SQL Server DBA I normally reply by saying “ I
don’t have any targets apart from activity type ......
|
|
-
|
|
Choosing the optimal amount of disks for a RAID server configuration and block sizes can be a challenge.
Typical questions from the SAN\Storage guy to the DBA are:
“How many disks in a RAID configuration?”
“What is the optimal block size?”
“What MB\sec throughput?&......
|
|
-
|
|
Torn Pages \ Corrupt pages – all in a days work for a DBA. But can anyone tell me how to use DBCC CHECKDB and the steps to take if a corrupt page is discovered?
This is a typical question I’ll ask at an interview for a DBA. In most cases the answers are vague.
My approach on DBCC CHE......
|
|
-
|
|
Latency is the time delay measure in the system. SQL Server can only be as fast as the slowest component in the system.
Database servers are particularly sensitive to disk IO speeds. For example, introducing an SVC system may speed up writes, but will add a cost to Reads.
Latency is about benchm......
|
|
-
|
|
Sometimes end users interchange the terms : C2 auditing and Traces. They server different purposes.
c2 auditing records all attempts (successfull and failed) on objects and statements. Typically a SQL Server DBA will use a c2 audit to monitor security compliance .
A trace will will monitor an even......
|
|
-
|
|
First thing this morning – a request from a DBA to confirm if Differential BACKUPS can be restored on a database in SIMPLE RECOVERY mode. Yes , you can.
A few assumptions are made :
1) A Differential base exists
2) The Differential base is not a COPY_ONL...
|
|
-
|
|
2012-03-14-21.59.22.121301+000 E1040722932E430 LEVEL: Severe
PID : 26754 TID : 182956718112 PROC : db2bp
INSTANCE: db2my NODE : 000
FUNCTION: DB2 UDB, bsu security, sqlexGetDefaultLoginContext, probe:150
MESSAGE : ADM1...
|
|