sqlinsix (54)in #data • yesterdayDevelopment: Reality vs Promises (Ethereum 2.0 Example)When it comes to development, one of the most consistent patterns we've all seen is overpromising. Developers promise…sqlinsix (54)in #data • 2 days agoLogic For the Business or Database Layer?In the video, Should Our Logic Be In the Application or Database Layer, we discuss the approach of designing business…sqlinsix (54)in #data • 4 days agoDatabase Challenge: Simultaneous Update of the Same ValueWhat happens if two separate users update the same database value at the same time? In the video, T-SQL: Simultaneous…sqlinsix (54)in #data • 6 days agoAuditing Login Failures With T-SQLAs we've seen with recent attacks, it may be worthwhile to track and monitor login attempts and failures. In the…sqlinsix (54)in #data • 8 days agoHow To Use the STUFF Function In SQL Server Part 2How can we use the STUFF function in T-SQL and where will we possibly want to use it? Check out the solution in the…sqlinsix (54)in #data • 9 days agoDiscussion About Data and the Physical World Part IIn the video, Data and the Physical World (Gold) we look at the severe limitations of data about the physical world.…sqlinsix (54)in #data • 11 days agoDoes the Same Data Mean the Same Conclusions?Before discussing this challenge, a few notes: I intentionally picked a neutral topic (the Dollar shortage) because…sqlinsix (54)in #security • 13 days agoWhy Linkability Is A Growing Security Topic (and Concern)We seldom hear about it, but linkability has become one of the top concerns in security. Check out the security video…sqlinsix (54)in #data • 15 days agoAltering Columns and Log GrowthCheck out the discussion in the video TSQL: Altering Column To NOT NULL Causes Log Growth Spike. In this situation…sqlinsix (54)in #data • 18 days agoGetting the Last Restore Date In SQL ServerCheck out the solution in the video TSQL: Get Last Restore Date. I've faced situations where backups were failing…sqlinsix (54)in #data • 20 days agoString Data Truncation in SQL ServerCheck out the solution in the video TSQL: "String or Binary Data Would Be Truncated" Quick Solution. As you can see…sqlinsix (54)in #security • 22 days agoWhat Are Sim-Swap Attacks?What is one cybersecurity attack that is growing and is one of the more potent attacks? Check out the discussion in…sqlinsix (54)in #data • 24 days agoShould We Use the NOLOCK Hint?Check out the discussion in the video . A colleague once shared a story of a company that dismissed a developer…sqlinsix (54)in #data • 27 days agoUsing DBCC CHECKDB In SQL ServerCheck out the solution in the video TSQL: DBCC CHECKDB Part I. In part 1 of this series, we look at the basics of…sqlinsix (54)in #data • 29 days agoMongoDB Connection ErrorsCheck out the solution in the video MongoDB Error: Couldn't Connect To Server [IP]:[Port [path] Exception. As we…sqlinsix (54)in #data • last monthChanging Columns In SQL ServerWhat happens when we run into the problem where we need to make changes to a column in a SQL database after the…sqlinsix (54)in #data • last monthFast In SSMS, Slow in the ApplicationWhat happens when we run into the problem where the query executes quickly in SSMS, but runs slow in the application…sqlinsix (54)in #money • last monthMy Cyber Warning Was ValidatedAt a recent speaking event, one point I highlighted involved how many people misunderstand their opponent in the cyber…sqlinsix (54)in #data • 2 months agoAdd Subdocument To Existing Document and Subdocument ArrayWhat if we have an existing document or subdocument and we want to add a subdocument to this, or add a subdocument to…sqlinsix (54)in #data • 2 months ago3 Useful XML Formats For SQL ServerIn the following video of T-SQL: How To Use FOR XML PATH - 3 Output Formats, we look at 3 popular XML formats that…