A Big Data Sqoop of Hadoop

On January 26, 2017, Posted by , in Big Data, Development, tags , , , , With Comments Off on A Big Data Sqoop of Hadoop

This week I’m working with one of our partners on migrating some data from Microsoft SQL Server to Hadoop. Sqoop is the tool of choice because it can migrate the data and maintain data types inside of Hive. Sqoop is a very straight forward tool, but there were some serious…

PowerShell quick list of SQL Users with SysAdmin Role

On February 6, 2012, Posted by , in Consulting, Development, Information Technology, tags , , With Comments Off on PowerShell quick list of SQL Users with SysAdmin Role

Here’s a link to a quick script from Max Trinidad to list SQL Users with the SysAdmin role. Here’s a quick way to start getting a list of SQL Server users having “SysAdmin” Role.  Basically, I’m using SQLPS module (now available with SQL Server 2012) which loads all the SMO…

PowerShell and SQL Server

On August 21, 2010, Posted by , in Information Technology, tags , , With Comments Off on PowerShell and SQL Server

Customers are always asking about using PowerShell to interact with their SQL servers.  One great source I’ve started following is Max Trinidad.  He has a very good grasp of both PowerShell and SQL Server administration.  Max has also contributed to codeplex with the SQLDevTools Module.  He wrote a blog postthat…