If you want to create a schema in a Microsoft SQL Server database only when it does not exist, use: declare @SchemaName nvarchar(128) set @SchemaName = 'Staging' if not exists(select top 1 1 from information_schema.schemata
If you restore a SQL Server (< 2012) database on an other database server make sure you fix the user and login mappings by following the steps on http://atakala.com/browser/Item.aspx?user_id=amos&dict_id=2036 Short fix: use MyDatabase go sp_change_users_login
A .NET 4.0 assembly containing a custom Team Foundation Build Activity can only be dragged and dropped from the toolbox on your build process template XAML file, when it is first registered in the GAC.
And the answer is: don’t use select top 1, instead use the row_number() function and the OVER clause. Lets assume we have a table structure like: Table [Observation] Multiple observations during a TimeSpan
I wanted to save information found in a file to a database without having to deal with encodings, well I found my solution at http://stackoverflow.com/questions/472906/net-string-to-byte-array-c-sharp [TestClass] public class RliResearchTester { [TestMethod] public void
After every Microsoft TechEd, I am overwhelmed by the new possibilities. Microsoft TechEd Europe 2012 in Amsterdam was no exception. You always learn new stuff, things you didn’t know they exists or hints to which
A colleague pointed me to Mighty Moose. It’s a FREE plugin for Microsoft Visual Studio and it can be used for continuous testing. CTRL+S, not only saves your code, but also builds and runs al
If you are using TDD in Microsoft Visual Studio 2010 and apply that red – green – refactor thingie, you want your tests to execute as fast as possible. Well MSTEST in Microsoft Visual Studio
If you want to set the [SelectedValue] property of a DropDownList in a unit test, you must first add items to the [Items] property of the DropDownList. If you don’t add items, setting the SelectedValue