Lately I’ve been utilizing schemas more frequently in my databases, however the first time I did this in VSDBPro was a pain. The reason for this was I didn’t know how to do it, so hopefully this post will save someone else the struggles I went through. First I want to highlight the differences between [...]
Displaying the most recent of 88 posts written by
Vendoran
So I’ve been using Visual Studio for Database Professionals (aka VSDBPro, aka DataDude) consistently this year for primarily new database development, both for Data Warehouses and OLTP Databases. This will be the first in what hopefully will become a series of posts about Database projects. In Database Professional there is are two types of projects, [...]
So the other day I was working on a T-SQL query that I was using to take data from generic data types and insert it into a strongly typed table. One of the columns was moving from an nvarchar(255) to an decimal data type. As some of the rows had character data in it, I [...]