Benchmarker

Simple SQL script for all tables

SELECT
    'delete from ' + table_name 
FROM 
    information_schema.tables 
WHERE
    table_name LIKE 'tbl_junk_%'

RegEx Search and Replace

(?s)<Client>.*?</Client> 

Moving dates between sql and dotNet

Recursive copy of files

xcopy C:\sourceFolder\*.dll C:\destinationFolder /sy

Validating XML with XSD

SQL Script for Memory Stats

Data reconciliation against SQL Servers

Requirement:
Compare two differently shaped data tables across two SQL Servers on a nightly basis.

Solution:
1. Create a view on each server that gets the data into a consistent (matching) shape.  Use CAST to ensure the datatype also match:

2. Create a RedGate SQLDataCompare project that compares the two views:

3. Run a SQLDataCompare command nightly:

4. Which produces the following results:

In this case, 2 records were identical, two records were different and one record was found in "DB2" that didn't exist in "DB1".

Here is the summary and detail output, which is configurable from within your project file.  I've opted to some identical records here, in production you probably wouldn't want to:

5. Email yourself the results 

Batch script for creating an empty file

copy NUL c:\myfoldername\myfilename.txt

Run all SQL files in a directory

Add this .bat file to the directory and run it:

for %%G in (*.sql) do sqlcmd /S servername /d databaseName -E -i"%%G"
pause

Adding speech marks around a list of data

# Ever had to add text characters to a list of data, like speech marks to each line before and after the data and a comma?

Here's an example of how to do this using Notepad++:

Filter XML with XSLT

SQL pivot without aggregration

Pivot data to return the first two country entries for each person.