Read-SqlTableData is a PowerShell cmdlet for reading tables data from SQL Server without writing a query. Here is how I tried it on my box.
SQL SERVER – How to Join a Table Valued Function with a Database Table
I use APPLY to Join a Table Valued Function with rows from another table. The example passes each customer’s delivery city.
SQL SERVER – How to INSERT or SELECT Copyright Special Characters in SSMS?
A reader asked how to insert or select copyright special characters in SSMS. The answer is ALT codes, like ALT + 0169 for the copyright sign, plus two more.
SQL SERVER – Case of Different Default Collation on Two Servers
My client saw a different default collation on two servers installed with SQL Server 2012. Here is what decides the default collation during setup.
SQL SERVER – Edition Downgrade with Supported Migration Checks
To Downgrade SQL Server editions, I plan a supported migration or reinstall. I test the application on the destination edition first.
MySQL – Fix Error – WordPress Database Error Duplicate Entry for key PRIMARY for Query INSERT INTO wp_options
My blog was slow and scheduled posts failed. The cause was a Wordpress Database Error: duplicate entry for key PRIMARY in wp_options. Here is how I fixed it.
SQL SERVER – Setup Screen Not Launching While Updating a Patch
Double clicking a SQL Server patch just flashed a window and vanished. SqlSetup.log in the %temp% folder showed why the Setup Screen was not launching.