Creating and restoring bacpac files without using a GUI
A short article on using command line tools for backing up databases hosted using Azure's SQL Database SaaS offering, and restoring them onto local SQL Server instances.
Posts tagged with 'sql'
SQL Woes - Mismatched parameter types in stored procedures
A cautionary tale about performance issues that can arise when the types of parameters used in stored procedures don't match the types of underlying columns when such parameters are being used in WHERE clauses, causing implicit conversions and the 'Type conversion in expression (CONVERT_IMPLICIT()) may affect "CardinalityEstimate"' warning to be displayed in query plans.