Reputation
532
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 7 20
Impact
~37k people reached

  • 0 posts edited
  • 0 helpful flags
  • 28 votes cast
Apr
13
awarded  Notable Question
Apr
5
accepted SQL Server 2016 deprecation of DML keyword ROWGUIDCOL
Apr
5
comment SQL Server 2016 deprecation of DML keyword ROWGUIDCOL
This is correct. Yes, I was confusing DDL and DML.
Apr
5
asked SQL Server 2016 deprecation of DML keyword ROWGUIDCOL
Apr
4
awarded  Revival
Apr
2
accepted Can SQL Server 2016 validate JSON on insert?
Apr
2
answered Can SQL Server 2016 validate JSON on insert?
Mar
16
awarded  Notable Question
Feb
9
asked Can SQL Server 2016 validate JSON on insert?
Feb
9
comment Do SQL Server or MYSQL contain JSON supporting functions?
One problem I see with the SQL Server 2016 approach is that an NVARCHAR(max) can contain JSON and non-json data, and all it takes is one invalid JSON value in your entire table, to break your whole database. There does not appear to be a way to enforce JSON validation on insert.
Feb
2
awarded  Critic
Feb
2
revised Can I create a referential integrity constraint in SQL Server that prevents time overlaps?
added 481 characters in body
Feb
2
asked Can I create a referential integrity constraint in SQL Server that prevents time overlaps?
Nov
4
comment Unable to get SQL Server 2016 CTP3 service to start on Windows 10
A link to the Error Help link which Microsoft currently has NO HELP at. error 50000 Source: setup.rll go.microsoft.com/…
Nov
3
comment Unable to get SQL Server 2016 CTP3 service to start on Windows 10
More help on getting past Microsoft's inability to build a rugged installer and deployment tools for SQL 2014, and SQL 2016: blog.brankovucinec.com/2015/04/08/…
Oct
30
revised Unable to get SQL Server 2016 CTP3 service to start on Windows 10
added 114 characters in body
Oct
30
comment Windows could not start the SQL Server service error
related question with Windows 10 specific elements: dba.stackexchange.com/questions/119606/…
Oct
30
accepted Unable to get SQL Server 2016 CTP3 service to start on Windows 10
Oct
30
comment Unable to get SQL Server 2016 CTP3 service to start on Windows 10
It is interesting that the installer (at least on Server OS) won't let me select NT AUTHORITY\LOCALSERVICE during the installer's page where it lets you select your logon accounts. It says this is not allowed. I am not sure why. Clearly not good for production, but why would it be bad for a DBA or Developer's own local test/eval workstation instances.
Oct
29
comment Unable to get SQL Server 2016 CTP3 service to start on Windows 10
Okay really really weird: I am able to get it to start once I used OSQL to reset the SA password, and change the Service login to NT AUTHORITY\LOCALSERVICE. Is it okay to leave it like that on my workstation?