DotNetShoutout

Database

2
Shouts

Shout it

Quick-and-Easy Database Integration Tests with SpecsFor

published 460 days, 16 hours ago posted by

Matt_TCF 469 days, 11 hours, 38 minutes ago

SpecsFor makes it very easy to bolt on your own conventions, create your own base classes, and extend its behavior to support your specific testing needs. I’m working on a project that’s built on LINQ to SQL, and I wanted to start creating integration tests around our stored procedures and views. Here’s the base class I made to handle establishing a database connection, loading in “seed data,” and then cleaning up after each set of specs once they’re finished. (more)

category: Agile | clicked: 23 | comment | | source: trycatchfail.com

tags: SpecsFor, Linq To SQL, TDD, Testing, Database

8
Shouts

Shout it

Knowing minimum timestamp value for a database

published 503 days ago posted by

dhara 504 days, 22 hours, 57 minutes ago

When a datatype timestamp or rowversion is used, it generates unique value whenever a row is added or updated in a table. It is one of the ways to generate auto-generated values not only for insertion but for updation too. If you want to know the minimum... (more)

category: Screencast | clicked: 51 | comment | | source: beyondrelational.com

tags: SQL Server, Database

7
Shouts

Shout it

DB2 security audit

published 503 days ago posted by

dhara 505 days, 22 hours, 8 minutes ago

The SYSIBM.SYSDBAUTH maintains user privileges on databases The SYSIBM.SYSPLANAUTH maintains user privileges on plans The SYSIBM.SYSUSERAUTH maintain user privileges on the system. This shell script collects and records these recordsets. Useful for regular... (more)

category: Data | clicked: 6 | 1 comment | | source: beyondrelational.com

tags: SQL Server, TSQL, Database

7
Shouts

Shout it

SQL Server – Performance tuning - DBCC FLUSHPROCINDB – Flush procedures of a particular database from cache

published 505 days, 5 hours, 52 minutes ago posted by

dhara 508 days, 22 hours, 27 minutes ago

Performance tuning & analysis during new development has it’s own unique challenge – on one hand as database developers, we need a clean procedure cache and on the other hand, we do not want to impact the performance of other databases on the same... (more)

category: Data | clicked: 17 | comment | | source: beyondrelational.com

tags: SQL Server, TSQL, Database

9
Shouts

Shout it

SQL Server - Database Backup Statistics and History

published 525 days, 20 hours, 40 minutes ago posted by

kinj312 529 days, 9 hours, 31 minutes ago

Every DBA has a daily activity review or monitor database backups as these database backups used for the restoration at other place and using for the database restore which used for reporting purpose or used in log shipping purpose. Because database backups... (more)

category: Data | clicked: 29 | 1 comment | | source: beyondrelational.com

tags: SQL Server, TSQL, Database

6
Shouts

Shout it

Nic Teaming

published 531 days, 23 hours, 22 minutes ago posted by

dhara 532 days, 7 hours, 41 minutes ago

Network card teaming or NIC teaming are networking terms describing methods of combining multiple parallel network connections . The main purposes are 1) increasing throughput beyond a single connection and 2) redundancy. The three main teaming configurations... (more)

category: Data | clicked: 9 | comment | | source: beyondrelational.com

tags: SQL Server, TSQL, Database

9
Shouts

Shout it

SQL Traces and c2 auditing are different

published 530 days, 1 hour, 16 minutes ago posted by

kinj312 534 days, 6 hours, 41 minutes ago

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... (more)

category: Data | clicked: 21 | 1 comment | | source: beyondrelational.com

tags: SQL Server, TSQL, Database

11
Shouts

Shout it

SQL Database Status with sys.databases

published 534 days, 6 hours, 33 minutes ago posted by

kinj312 539 days, 6 hours, 2 minutes ago

I was creating a Powershell script for a SQL Server checkout procedure after a reboot , and used the state_desc column in sys.databases view to report on the database status. The descriptions, courtesy of BOL are: ONLINE - Database is available for access... (more)

category: Data | clicked: 16 | 1 comment | | source: beyondrelational.com

tags: SQL Server, Database

10
Shouts

Shout it

Reduce heap table fragmentation

published 534 days, 6 hours, 33 minutes ago posted by

kinj312 539 days, 6 hours, 3 minutes ago

A table that does not have a clustered index is referred to as a Heap. While a lot has been written about index fragmentation and how to defrag indexes, there is not much that talks about how to defrag a heap table. To identify whether your heap table... (more)

category: Data | clicked: 14 | 1 comment | | source: beyondrelational.com

tags: SQL Server, TSQL, Database

9
Shouts

Shout it

Find out the referenced tables of a table that to be added as articles in replication

published 534 days, 6 hours, 33 minutes ago posted by

dhara 540 days, 5 hours, 15 minutes ago

In replication, we need to add objects as articles to replicate the data to different server.The important point is here that if we have any reference(foreign keys) associated with the articles(tables choosen to be replicated), then we need to consider... (more)

category: Data | clicked: 25 | 1 comment | | source: beyondrelational.com

tags: SQL Server, TSQL, Database

10
Shouts

Shout it

SQL Server – TempDB v/s Model database – Minimum size considerations – CREATE DATABASE - Error Msg 1803

published 541 days, 8 hours, 51 minutes ago posted by

kinj312 546 days, 7 hours, 26 minutes ago

A few weeks ago, I wrote a post related to the tempdb where I attempted to answer the question – Is TempDB a copy of the model database? The post attracted a couple of follow-up comments (which I really appreciate, because it gives everyone a great deal... (more)

category: Data | clicked: 32 | 3 comments | | source: beyondrelational.com

tags: SQL Server, TSQL, Database

8
Shouts

Shout it

System Reserved Partition and monitoring

published 546 days, 21 hours, 34 minutes ago posted by

kinj312 548 days, 6 hours, 21 minutes ago

On Windows 2008 R2 , a System Reserved Partition is created. It is 100 MB and acts as a preparatory step for implementing Bitlocker. The installation doesn’t install Bitlocker. BitLocker is a disk encryption method for full disk encryption. The System... (more)

category: Data | clicked: 12 | comment | | source: beyondrelational.com

tags: SQL Server, TSQL, Database

7
Shouts

Shout it

DB2 Database code set

published 545 days, 17 hours, 1 minute ago posted by

dhara 552 days, 7 hours, 58 minutes ago

The DB2 code set value defines the character encoding used by the database. Setting the appropriate value for translation, for example: Euro symbol and DB2 database codeset To get the DB2 database code set value, use: db2 get db cfg for MY_DB --From a... (more)

category: Data | clicked: 5 | 1 comment | | source: beyondrelational.com

tags: SQL Server, TSQL, Database

10
Shouts

Shout it

Data Loading Performance Guide

published 554 days, 2 hours, 27 minutes ago posted by

kinj312 557 days, 8 hours, 31 minutes ago

Bulk loading with large amounts of data requires strategy. The Data Loading Performance Guide for SQL Server 2008 and SQL Server 2005 is a very useful document. Highlights Understanding Minimally Logged Operations Trace Flag 610 (sql server 2008) Summarizing... (more)

category: Data | clicked: 28 | 1 comment | | source: beyondrelational.com

tags: SQL Server, Database

8
Shouts

Shout it

More on Table-valued Parameters (TVP’s)

published 565 days, 2 hours, 56 minutes ago posted by

kinj312 569 days, 9 hours, 55 minutes ago

While finalising some slides for my presentation at the Canberra .Net User Group on Using XML and TVP’s to Transport Relational Data , I stumbled across a couple of posts by Bob Beauchemin relating to how TVP’s cause plan recompiles when called from ADO... (more)

category: Data | clicked: 9 | 1 comment | | source: beyondrelational.com

tags: SQL Server, TSQL, TVP, Database

6
Shouts

Shout it

DBCC CHECKDB

published 571 days, 12 hours, 42 minutes ago posted by

kinj312 574 days, 11 hours, 2 minutes ago

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... (more)

category: Data | clicked: 11 | comment | | source: beyondrelational.com

tags: SQL Server, TSQL, Database

6
Shouts

Shout it

Analyzing a DB2 trap file

published 573 days, 1 hour, 54 minutes ago posted by

kinj312 575 days, 10 hours, 9 minutes ago

Usually when the DB2 instance ends unexpectedly, trap files are created. There is usually one trap file capturing the root cause. A number of other files are created, supporting data about DB2 processes. The dbdiag.log file indicates which files to analyze... (more)

category: Data | clicked: 4 | comment | | source: beyondrelational.com

tags: SQL Server, Database

7
Shouts

Shout it

Different Properties of SQL Server Database

published 576 days, 1 hour, 27 minutes ago posted by

kinj312 576 days, 23 hours, 56 minutes ago

Hi all, You all are thinking, what I will write here on “Database properties”. Right, it’s a big question in all’s mind. However, I am writing here for each and every property of SQL Database and will discuss in details in future articles. Let’s start... (more)

category: Data | clicked: 11 | comment | | source: beyondrelational.com

tags: SQL Server, Database

7
Shouts

Shout it

DIAGLEVEL db2

published 576 days, 1 hour, 27 minutes ago posted by

kinj312 576 days, 23 hours, 57 minutes ago

Diaglevel refers to the Diagnostic error capture level configuration parameter. There are 5 levels: 0 - No diagnostic data captured 1 - Severe errors only 2 - All errors 3 - All errors and warnings 4 - All errors, warnings and informational messages The... (more)

category: Data | clicked: 11 | comment | | source: beyondrelational.com

tags: SQL Server, Database

6
Shouts

Shout it

Backup/restore/checkdb/shrinkfile progress

published 584 days, 10 hours, 40 minutes ago posted by

dhara 587 days, 9 hours, 1 minute ago

Have you ever wonderet how long you need to wait for a backup or restore command to complete? If you perform the backup or restore from the gui in management studio, it shows you the progres for every 10%. But what to do if you issuet the backup or restore... (more)

category: Data | clicked: 28 | 3 comments | | source: beyondrelational.com

tags: SQL Server, Database

Welcome!

Database

Quick-and-Easy Database Integration Tests with SpecsFor

Knowing minimum timestamp value for a database

DB2 security audit

SQL Server – Performance tuning - DBCC FLUSHPROCINDB – Flush procedures of a particular database from cache

SQL Server - Database Backup Statistics and History

Nic Teaming

SQL Traces and c2 auditing are different

SQL Database Status with sys.databases

Reduce heap table fragmentation

Find out the referenced tables of a table that to be added as articles in replication

SQL Server – TempDB v/s Model database – Minimum size considerations – CREATE DATABASE - Error Msg 1803

System Reserved Partition and monitoring

DB2 Database code set

Data Loading Performance Guide

More on Table-valued Parameters (TVP’s)

DBCC CHECKDB

Analyzing a DB2 trap file

Different Properties of SQL Server Database

DIAGLEVEL db2

Backup/restore/checkdb/shrinkfile progress

Open ID Login

Standard Login

Forgot Password?

Sign up