Here’s what you do when you want to get a local copy of an Azure SQL Database. Export Azure Database 1. Select your database in the Azure Portal https://portal.azure.com/#blade/HubsExtension/BrowseRes
Power BI is Microsoft’s new data visualization platform. It allows you to easily pull data from datasources like Salesforce, GitHub and QuickBooks. As I was going through the product I noticed they di
I just got this error when doing Merge Replication on a SQL Server 2005 environment: A row insert at ... could not be propagated to ... This failure can be caused by a constraint violation. Cannot ins
The is a post in a blog series I’m writing called "Microsoftie Perks" Over the years I have found many bugs in Microsoft products. I want to help Microsoft have the best products out there,
The new SQL tools in Visual Studio 2012 are amazing, but still lack a database diagrams features that SQL Server Management Studio has. I use database diagrams all the time to easy create foreign keys
[ You likely get the exception "Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly.��� when you are trying to add a Database file to a project and don’t
You are probably using the wrong DbConnection class. If you are using Access then make sure you use OleDbConnection, not SqlConnection…and vice versa. Alternatively you could be referencing your MDB f
Great video on the new Date DataTypes in in Sql [T-SQL Enhancements and Date/Time ](http://download.microsoft.com/download/8/5/1/851B0968-0BE0-417E-9DA9-B3A2A6E47A67/NewDateTime.wmv) SQL Server 2008
The SqlXml datatype constructor only accepts a Stream or XmlReader, if you have an XmlDocument in memory (go with stream if you have it) then you can easily convert to a SqlXml compatible stream with