Tags » SQL Server

.Net version of SQL Server PWDCompare

One of my customers has a Microsoft SQL Server database with passwords that have been secured using PWDENCRYPT and PWDCOMPARE As part of a migration plan we need to be able to validate passwords against… 492 more words

Microsoft

Logging

Every database has a transaction log that records all transactions and the database modifications made by each transaction

The transaction log is a critical component of the database. 231 more words

Sql Server

Raw SQL and SqlAzureExecutionStrategy

If you are using Entity Framework to run raw SQL queries directly against the database and are using SqlAzureExecutionStrategy for retrying SQL Azure transient failures, you might be getting “The SqlParameter is already contained by another SqlParameterCollection” exceptions. 43 more words

.NET

SQL Operations Studio - Connection Dialog Improvements

Back in November, I had opened an issue in GitHub for SQLOps Studio Team to make the ‘Server Name’ and ‘Database Name’ as drop downs instead on text boxes, when you are adding a new connection. 187 more words

SQL Server

Getting started with the SQLUndercover Inspector

Here is a quick guide to getting started with the SQLUndercover Inspector.

Pre-requisites:

  • SQL 2012 or higher
  • SQL Server Agent
  • A database to store the the data collected by the agent jobs (this can be one you use for your other DBA needs it doesn’t have to be a dedicated database)
  • 619 more words
Database Administration

STORPORT: Reading an ETL trace

One of the things I enjoy most is diagnosing storage latency. I honestly couldn’t tell you why I enjoy it so much; but, I just do. 425 more words

Administration