...

...

Here are the seven Demo’s that I had posted over the past few weeks, listing them here: Detecting invalid values in Price domain or unrealistic values in Height domain How to standardize data using DQS How to clean records using third-party refere...

...

In this post, I use the MODIFY FILE clause of the ALTER DATABASE statement to rename the logical file of a database. This is most often useful during product/organization re-branding. This approach is fast because it does not require a transfer of data ...

...

SQL Server Error log is the best option for a DBA to identify any current or potential issues with SQL Server databases. These error log files contain a broad range of error messages that provide valuable information with respect to automatic recovery, ...

...

...

Converting Base64 values to varbinary and vice versa can be realized with the help of XQuery functionality available from SQL Server 2005 onwards...