Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database. In part one of this article, I described a ...

Here's how you can use SQL Server's OpenJson function to dismantle ... "street" : "300 Strathcona" } ] }, …more customer objects… ]}'; One solution to moving this structure to relational tables is ...