samtran.me shared a link.
6 methods to write PowerShell output to a SQL Server table
PowerShell has become the ultimate choice for many database administrators because of its efficient way of handling and managing automation in a simple, quick way. It’s built on .NET Framework and uses Object Models such as COM, ADSI, ADO, and WMI. PowerShell has replaced the traditional way of sc...
sqlshack.comsamtran.me shared a link.
How to use Python in SQL Server 2017 to obtain advanced data analytics
On the 19th of April 2017, Microsoft held an online conference called Microsoft Data Amp to showcase how Microsoft’s latest innovations put data, analytics and artificial intelligence at the heart of business transformation. Microsoft has, over the last few years, made great strides in acceleratin...
sqlshack.comsamtran.me shared a link.
Horizontal Partitioning for Big Tables
It’s fairly common knowledge amongst database professionals partitioned tables can help considerably with performance in various situations but my guess is not many would have considered the enormous benefits when it comes to archiving, a necessity when it comes to massive tables.
samtran.meThanks for visiting. I use this page as a source feed for my main site at: http://samtran.me/ . This saves time with updates. Feel free to drop me a visit there-I'm trying to plot global visitors on Google Analytics
samtran.me shared a link.
7 lesser known hacks for debugging in Visual Studio
The official source of product insight from the Visual Studio Engineering Team
blogs.msdn.microsoft.comsamtran.me shared a link.
LINQ-to-BigQuery - LINQ to BigQuery is C# LINQ Provider for Google BigQuery. It also enables Desktop GUI Client with LINQPad and plug-in driver.
github.comsamtran.me shared a link.
What's So Great About Tuples? -- Visual Studio Magazine
String functions, integer functions ... booorrring! Tuples in C# 7.0 -- let's explore what makes them infinitely more exciting.
visualstudiomagazine.comsamtran.me shared a link.
MongoDB vs. Azure DocumentDB - Simple Talk
If you are familiar with MongoDB you may be wondering how Azure's DocumentDB service compares. In this article David Green gives us a look. Note that Azure DocumentDB is evolving very quickly, so some of the limitations mentioned in this article may have already been removed.
simple-talk.com