If your business uses relational databases to store data, it helps to use the SQL SELECT command with the INTO clause to create new tables from query results. This method isn't ANSI-standard SQL, but ...

With JSON now the default format for moving data between clients and servers, SQL Server adds JSON support to make it easier to get your data out of the database and down to the client. SQL Server ...

Last time, I discussed how to get PowerShell and SQLPS up and running on your machines. And much like my dog chasing its tail, you're probably asking yourself, "Now that I have it, what do I do with ...

SQL Server 2008 has a ton of new DBA features, but if you really want to make this thing go, just crank out a little code. SQL Server 2008 is mostly in the domain of system and database administrators ...

A free tool to reduce coding for developers who like to surface T-SQL database recordsets in a simple collection of customized POCO objects. Every so often, I find myself wishing that I had a utility ...

Microsoft SQL Server's relational engine has offered new instrumentation that improves by light years with each new release. The introduction of Dynamic Management Views (DMVs) in SQL Server 2005 ...