Tag: sql server

Azure, cloud, database, sql serverLeave a comment

SQL Server on Azure VMs – Updated Tips April 2017

mssqldude

There are a lot of “best practice” and “performance guide” links available on the Internet to provide guidance on migrating SQL Server instances and databases from on-prem to Azure on VMs (aka Azure IaaS). In this post, I wanted to share a few findings from the field that I’ve encountered along the way recently working with customers on projects that migrate from on-prem SQL Server to Azure VMs. This is not a guide to migrating to Azure SQL Database and I do not cover all of the issues, migration steps or performance measures in an exhaustive manner. I will share … Continue reading SQL Server on Azure VMs – Updated Tips April 2017

Big Data, Big Data AnalyticsLeave a comment

OPASS Discussions & Big Data in the Real World

mssqldude

If you are in the Orlando Sanford area tomorrow night (Thursday October 24 @ 6;30 register here) then come join the Orlando PASS gang where I will lead a discussion on Big Data and Big Data Analytics in the real world. I am basing this discussion on the systems that we designed and took to market for Razorfish and will include demos of HDInsight, Hadoop, NoSQL databases, Big Data Analytics with Pentaho and SQL Server. Here is the Slideshare link to the presentation for the meeting. Continue reading OPASS Discussions & Big Data in the Real World

BI, Reporting, SSAS6 Comments

Adventure Works SQL DW on Pentaho OLAP, part 1

mssqldude

Let’s say you have SQL Server databases for your data marts and warehouses in your organization, but you are looking for alternatives to SSAS cubes and SharePoint-based dashboards. If you are like me and have built many BI solutions in SSAS OLAP and PPS, then you’ll find a transition to OSS with Pentaho to be very easy and a natural fit for those BI scenarios. We’re going to take this SQL Server 2012 DW and SSAS cube and recreate it all in Pentaho: I’m going to kick this series off with a very simple BI dashboard using the traditional SQL … Continue reading Adventure Works SQL DW on Pentaho OLAP, part 1

Big Data AnalyticsLeave a comment

SQL Dude Adventures and BI Blogging

mssqldude

Hi Everyone! My apologies for the gap in blogging … It’s been a long couple of months transition over to the Open Source Software world and relocating to Orlando for Pentaho. It’s been an amazing adventure so far and I’ve just started transitioning my work to the hybrid OSS / commercial world for this MSSQLDUDE blog, SQL PASS, local BI Meetups & the SQL Server Pro Magazine BI Blog. I will post my Adventure Works on Pentaho OLAP blog post this evening to kick it off and if you are looking for the more purist Big Data Analytics and Pentaho … Continue reading SQL Dude Adventures and BI Blogging

Administration, Data Warehouse, UncategorizedLeave a comment

Monitor SQL Server CDC with Customer Data Collector

mssqldude

I’ve posted several times over the years here @MSSQLDUDE on the benefits of SQL Server Management Data Warehouse (MDW) for baselining your SQL Server performance and sending those measurements to a central server for monitoring. MDW makes use of the SQL Server Data Collector feature and is a feature you get out of the box. Here are some of my writings on MDW here @MSSQLDUDE: http://en.search.wordpress.com/?q=mdw&site=mssqldude.wordpress.com. There is a debate among SQL Server DBAs about the worthiness of MDW and Data Collectors because they can appear to be a “heavy burden” on your server and provide overhead that you may not … Continue reading Monitor SQL Server CDC with Customer Data Collector

UncategorizedLeave a comment

Big Data and the Telecom World

mssqldude

The complicated world of telecommunications analytics continues to be a primary driver behind complex data analytics solutions and I find it mentioned time and time again in Big Data use cases and scenarios. Those of us who have lived in this world for years will probably agree with me that we’ve been pioneers in “Big Data techniques” ever since we were asked to build CDR (call detail record) data warehouses. My first CDR solution was for customer service and marketing at AT&T in the 1990s. We used Oracle for the DW and hired PhD statisticians to build models for predictive … Continue reading Big Data and the Telecom World

Big Data, Big Data Analytics6 Comments

Big Data with SQL Server, part 2: Sqoop

mssqldude

I started off my series on Hadoop on Windows with the new Windows distribution of Hadoop known as Microsoft HDInsight, by talking about installing the local version of Hadoop on Windows. There is also a public cloud version of Hadoop on Azure: http://www.hadooponazure.com. Here in part 2, I’ll focus on moving data between SQL Server and HDFS using Sqoop. In this demo, I’m going to move data between a very simple sample SQL Server 2012 database that I’ve created called “sqoop_test” with a single table called “customers”. You’ll see the table is very simple for this demo with just a customer … Continue reading Big Data with SQL Server, part 2: Sqoop

Big Data, Big Data Analytics, Hadoop, SSAS, SSISLeave a comment

PSSUG November 2012 Presentation: Big Data with SQL Server

mssqldude

Thank you all for coming out on a rainy, snowy, cold evening to join us for this month’s PSSUG meeting! Here is a link to the slides that I used tonight during my presentation of Big Data with SQL Server and Hadoop demos: http://www.slideshare.net/kromerm/pssug-nov-2012-big-data-with-sql-server. Br, Mark Continue reading PSSUG November 2012 Presentation: Big Data with SQL Server

Big Data, Data Warehouse, Uncategorized2 Comments

Configure SQL Server for Big Data

mssqldude

Now that my new focus is 100% on Big Data Analytics, I thought I’d get back into blogging here @ MSSQLDUDE and start providing some insights and lessons-learned around managing “Big Data” in SQL Server. The context for this example will be a SQL Server 2012 database that is loading flat files with millions of rows of Website cookie data and social media data for specific marketing campaigns. The files are generated from an Hadoop MapReduce job that parses those files and produces new flat files in structured format that SSIS can pick-up and store in SQL Server. If you … Continue reading Configure SQL Server for Big Data

Administration, Monitoring, Uncategorized3 Comments

System Center for the SQL Server DBA: Wrap-Up

mssqldude

I’m going to call the series on System Center for the SQL Server DBA complete with this one last post today. First, here is the full series to date … my apologies for the lack of post naming consistency!! System Center for the SQL Server DBA Intro The Continuing Story of System Center for the SQL Server DBA Monitor SQL Server from System Center Operations Manager SQL Server management pack for SCOM System Center for the SQL Server DBA Part 2: DPM System Center Data Warehouse for SQL Server DBAs What I wanted to point you all to is an … Continue reading System Center for the SQL Server DBA: Wrap-Up