Ars Technica

Creating a SQL Database for an absolute beginner

I don't know if this is the right place for this question or not but I'm hoping someone can point me in the right direction. I have a project in mind that requires a database and I would like to begin ...
MCPmag

Creating a SQL Server Login Using PowerShell and SMO

In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...
Ars Technica

T-SQL: Creating a (not quite) duplicate row

Hello, I've got a bit of an unusual request, I want to create some duplicate rows in a SQL Server table. We have a WorkOrders table that has our customer orders in it. Every order has a WOID ...
Redmond Magazine

Write .NET Code in SQL Server

Technology Toolbox: VB.NET, C#, SQL Server "Yukon" All versions of SQL Server prior to SQL Server "Yukon" provide two ways to write procedural code that executes inside the database. The usual way is ...