388 reputation
215
bio website delphicodemonkey.blogspot.com
location Toronto, Canada
age 44
visits member for 2 years, 4 months
seen Oct 14 at 21:49

Software Developer (Professional), Amateur DBA.

Bits of code at Bitbucket hosting: https://bitbucket.org/wpostma


Oct
24
awarded  Popular Question
Oct
14
answered SQL Server Create Access Denied even after adding MSSQLSERVER user permissions
Oct
14
awarded  Popular Question
Sep
5
awarded  Notable Question
Jul
2
awarded  Curious
Jun
25
awarded  Popular Question
May
29
awarded  Popular Question
Apr
7
comment How do I configure SQL Server 2012 so that it can restore and see files in my user account?
By end user I mean any of the dozens of categories of people, some quite professional and technically competent in various disciplines, but who may NOT be DBAs. Personally I think even DBAs would find that the UI on this tool could do to be improved. The robust third party tool market is another indicator that SSMS, while free, is entirely worth the price.
Apr
7
accepted How do I configure SQL Server 2012 so that it can restore and see files in my user account?
Apr
6
awarded  Popular Question
Oct
14
awarded  Popular Question
Jul
3
awarded  Yearling
Jan
30
comment SQL Server Create Access Denied even after adding MSSQLSERVER user permissions
I have a feeling it has something to do with OWNER RIGHTS
Jan
30
asked SQL Server Create Access Denied even after adding MSSQLSERVER user permissions
Jan
15
comment How can I do a differential query (delta plus/minus) telling me what rows are in view A that are not in view B and vice versa?
Oh... That covers either one being null, so either the left-hand-side (T1) or right-hand--side (T1) is null, but the other side is not null, and thus, we have a row returned. Both cases (t1 row missing, t2 row missing) are covered?
Jan
15
comment How can I do a differential query (delta plus/minus) telling me what rows are in view A that are not in view B and vice versa?
All fields are non-null.
Jan
15
asked How can I do a differential query (delta plus/minus) telling me what rows are in view A that are not in view B and vice versa?
Dec
18
comment How do I configure SQL Server 2012 so that it can restore and see files in my user account?
If everybody changes their SQL Servers to run with a regular user ID when doing development, that might be the "best practice". I'm just wondering if that's a good idea or not. If manually adding "NT Service\MSSQLSERVER" to the folders I need to add to is the standard idea, I guess that would be the most logical minimal fix, right? Wot I wish is that the SQL server SSMS UI was a little easier to connect to this hidden "NT Server\xxx" account id.
Dec
18
asked How do I configure SQL Server 2012 so that it can restore and see files in my user account?
Dec
17
revised Is there a compact way to use a NOT IN (1,2,3) syntax when setting a variable?
deleted 5 characters in body