383 reputation
213
bio website delphicodemonkey.blogspot.com
location Toronto, Canada
age 44
visits member for 2 years, 2 months
seen Apr 7 at 14:30

Software Developer (Professional), Amateur DBA.

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


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
Dec
17
comment Is there a compact way to use a NOT IN (1,2,3) syntax when setting a variable?
Wow. thanks for the IIF (2012+) idea. When we move to SQL 2012 that would be great. Otherwise CASE is at least more readable than my if (a<>1)and(a<>2).... msdn.microsoft.com/en-us/library/hh213574.aspx
Dec
17
asked Is there a compact way to use a NOT IN (1,2,3) syntax when setting a variable?
Dec
13
accepted Is it possible to record incoming parameter values in a procedure call while tracing in SQL Server Profiler?