Reputation
485
Top tag
Next privilege 500 Rep.
Access review queues
Badges
1 5 19
Newest
 Critic
Impact
~32k people reached

  • 0 posts edited
  • 0 helpful flags
  • 27 votes cast
18h
comment Can SQL Server 2016 validate JSON on insert?
Oh. Looks like it's ALTER TABLE [dbo].[Resource] ADD CONSTRAINT [RESOURCE_ExtJSON_VALID] CHECK ( ISJSON( ExtJSON )> 0 )
18h
asked Can SQL Server 2016 validate JSON on insert?
18h
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?
Oct
29
revised Unable to get SQL Server 2016 CTP3 service to start on Windows 10
added 141 characters in body
Oct
29
comment Unable to get SQL Server 2016 CTP3 service to start on Windows 10
Note that if, logged in as Administrator, I run c:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn\sqlservr.exe -s MSSQLSERVER I get a running server, but I had to use OSQL to reset SA password as the MS SQL installer did NOT set it. I can not get the service to start up when I have it log in with its default account, nor if I make it start up with my own user account which is a local administrator for this machine. If I start it up using my User Account, it fails with Error 1067, The process terminated unexpectedly.
Oct
29
asked Unable to get SQL Server 2016 CTP3 service to start on Windows 10
Oct
6
revised Can I convert a VARCHAR field body to unquoted JSON result in SQL Server 2016 CTP 2.X?
added 87 characters in body; edited title
Sep
28
comment Re-designing a Database cost and advice
It sounds like your company doesn't even want to use an SQL database or relational technology. If you work in a domain where a non-relational database might actually suit your domain and your requirements, consider Couchbase and MongoDB, as it sounds like your entire company and history has been to use an SQL database without regard for relational integrity, normalization, or any other thing that SQL technology excels at. For web -developers who don't want to employ DBAs, or to understand SQL best practices, maybe it's best to just use a document key-value store.
Sep
28
comment Re-designing a Database cost and advice
First my sympathies. A mess that was made over several years is seldom less than several years work to clean up. You probably are not free to redesign the schema unless you redesign the applications at the same time, unless the code is not in use in a commercial environment, and even then, it sounds like you're asking a question which is more or less unanswerable on a Stackoverflow style format. Please don't take it badly if someone downvotes or votes to close your question.
Sep
21
accepted Can I convert a VARCHAR field body to unquoted JSON result in SQL Server 2016 CTP 2.X?