GitHub

SQL Server Time Zone Support

This project adds full support for time zones to Microsoft SQL Server. This implementation uses the industry standard IANA time zone database. If you are used to Microsoft Windows time zones, such as ...
GitHub

This PowerShell module contains two functions that are useful for exporting large amounts of data from tables, views, or queries on an (Azure) SQL Server database into CSV ...

Exports the contents of a table, view, or query of a SQL Server database to an RFC 4180-compliant CSV file. This function supports the export of huge result sets by writing the contents of the CSV ...
Microsoft

Transitioning from SMP to MPP, the why and the how

This blog post was authored by: Sahaj Saini, PM on the Microsoft Analytics Platform System (APS) team. In this blog post, we’ll provide a quick overview of Symmetric Multi-Processing (SMP) vs.
TechRepublic

SQL basics: Datetime and interval data types

Shelley Doll finishes her coverage of SQL data types with an overview of datetime and interval data types. Learn more about the basic syntax of these standard SQL types. Datetimes and intervals are ...