Read up on third normal form, primary keys, index covered joins.

I guess this an effort on the part of Microsoft product teams to better synchronize shared code bases, builds, and testing between SQL Server 2016/2017 and Azure SQL Database, which...

I've worked with Oracle in the past as well, and I can adapt to differences in syntax. However, a harder pill to swallow is that in Oracle, '' IS NULL....

I trust Microsoft, particularly the SQL Server team, to do this right and to do it for the right reasons. It's probably the best engineered software product in the world.

I'm not concerned about alleged health risks associated with eating GMO food; that's not the risk people should be concerned with. The way I see it, the real potential threat...

Here is where I've found PowerShell particularly useful:
- Iterating across multiple servers. In my case that's hundreds of servers.
- Integration with Windows, things like gathering disk...

Developer Edition can't be used in a production system. For example, you can't use Developer edition to host your organization's public website or even an internal application like timesheets. Starting...

NOLOCK hints on a query are generally a bad idea, regardless of whether the query is inside a view. Other than the nolock hint, there doesn't appear to be anything...

Space colonization, flying cars, fossil fuel independence, human cloning: we can argue the merits of whether each of these things should exist, but the required technology exists today, and has...