Stranger Danger… The need for trust with constraints
I ran into an issue with errors with an database upgrade running into a violation of a foreign key constraint....
2015-08-13
418 reads
I ran into an issue with errors with an database upgrade running into a violation of a foreign key constraint....
2015-08-13
418 reads
Red Gate Documentation Update
Looks like the rapid release channel now has a great feature for locking database objects that you...
2015-08-12
274 reads
out of memory, argggh!
Am I the only one that has experienced the various out of memory issues with SSMS? Not...
2015-08-11 (first published: 2015-08-05)
3,418 reads
the problem of monster views
I’ve been working with tuning an application that performs a lot of Entity framework calls,...
2015-08-10
1,279 reads
Have never really played around with the option: SET NOEXEC ON
Turns out this can be a helpful way to validate...
2015-08-07
3,473 reads
Working in a development environment, I botched up a restore. After this restore attempt to overwrite my database with the...
2015-08-04 (first published: 2015-07-28)
3,111 reads
Was testing a batch file to add a user to a localdb instance. Assumed that my user as admin on...
2015-07-13
501 reads
Was testing a batch file to add a user to a localdb instance. Assumed that my user as admin on...
2015-07-13
315 reads
I'm excited to see the future of Sql server management studio with release of SQL Management Studio 2015 Preview. http://bit.ly/1LSu0Ek
Two...
2015-07-06 (first published: 2015-06-30)
10,114 reads
I’m excited to see the future of Sql server management studio with release of SQL Management Studio 2015 Preview. http://bit.ly/1LSu0Ek...
2015-06-30
943 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers