In honor of the upcoming PASS Business Analytics conference, we wanted to take some time to spotlight the great work happening in the SQL and BI communities across the world. The conference is focused on business analytics, but PASS offers many great community activities for SQL Server and beyond. Learn about the various local and digital opportunities to connect with the PASS community here.

Name: Luan Moreno Medeiros Maciel

Role: SQL Server Database Consultant at The Pythian Group

Location: Brazil

 

What is an exciting project that you’re working on right now?

I have a few interesting projects going on right now…

Hybrid Cloud on SQL Server: This projects consists in a cloud between Amazon and the local DataCenter of the client. I’m designing this solution utilizing Database Mirroring on SQL Server 2012. After the implementation the client will be able to have a High Available solution between two sites.

In-Memory OLTP a.k.a “Hekaton” Feature Implementation: Implementing tables In-Memory for a medium company. The idea is to provide a big table In-Memory that will absorb all the requests and then, at a specific time of the day, flush the data to disk-based tables.

Partitioning in SQL Server 2012: Partitioning a big table to provide better maintenance and velocity in the data request. The data will be split by month.

Creating DW (Data Warehouse) – Educational Company: Creating the complete Data Warehouse process for a client who needs to analyze data to be used with end visualization tools in Excel (PowerView, PowerMap and PowerPivot).

 

What are your current analytics and/or database challenges, and how are you solving them?

I have a few challenges I am currently navigating. The first is determining the proper tables to be used in an In-Memory implementation. To help choose the correct tables to put In-Memory, I am using the Data Collector to analyze the client workload and generate insights. The second is creating the right Table Partitioning to improve one of my clients’ weekly maintenance. To do this I am analyzing the client server/database/maintenance to check what options are available and to determine the specific timeframe to apply the changes. I am also consulting some DMV’s and the MSDB database to check the jobs in this instance.

 

How does data help you do your job better?

Data is the center of my globe; I need to analyze, maintain, sustain, and provide insights and solutions to my clients. All of this can happen because of data.

 

What types of data-related challenges do you frequently see with customers, and how are you solving them?

Working with customers requires you to understand the customer environment, check what you have available to accomplish the work required, and then provide the best solution possible.

 

What’s your favorite example of how data has provided an insight, a decision, or a shift in how business gets done?

One of my clients had several problems related to data analysis. Because their data was not organized in the correct manner in their database, the client couldn’t provide solutions to front-end users. To solve the problem my team created a Data Quality Services structure with the client, organizing the data so that the data insights of the OLTP system could be recognized. As a result of these improvements, the client started to provide his own insights with the new, reinvented data.

 

What or who do you read, watch, or follow to help grow your data skills? (book, blog, Twitter handle, podcast, online course…anything!)

 

What’s your favorite SQL command and/or Excel function and why?

ALTER DATABASE imoltp
ADD FILEGROUP imoltp_mod CONTAINS MEMORY_OPTIMIZED_DATA

 

This command gives me the certainty that I will work with the In-Memory OLTP (a.k.a “Hekaton”).

 

Thanks for joining us, Luan!

Know someone doing cool work with data? Nominate them for a spotlight in the comments.


SQL Server Team Blog

{ Comments on this entry are closed }

Senate votes down USA Freedom Act

May 24, 2015

In a midnight session, the Senate has voted down the USA Freedom Act, putting one of the legal bedrocks of the NSA’s bulk surveillance programs into jeopardy. The Patriot Act is set to expire at the end of the month, and the USA Freedom Act would have extended large portions of the act in modified […]

Read the full article →

The Bitcoin Blocksize Blackjack Mining Blues

May 23, 2015

 Bitcoin: it’s at a crucially important crossroads; it’s approaching a crisis that threatens its very existence; it has never been more likely to erupt into enormous global importance. Which? Don’t be ridiculous. It is all those things at once, of course, as usual. I only wish I was joking. If you’re dumb enough to judge […]

Read the full article →

Q&A With John Tsai, V.P. of Marketing at Thecus

May 21, 2015

Hi Folks – If you’ve been following this blog, then you already know that Thecus is now shipping 2-bay, 4-bay, and 5-bay NAS devices running Windows Storage Server 2012 R2 Essentials. This is a new edition of Windows Storage Server that we created to enable affordable, easy-to-use, cloud-connected storage for small businesses and small office/home […]

Read the full article →

Big data needs a big cloud

May 21, 2015

Brian Mitchell, Microsoft Senior Business Program Manager, took the stage at Ignite two weeks ago to discuss Planning Your Big Data Architecture on Azure. “Big Data” requires big scale. Mitchell covered how this is accomplished through storage strategies, partitioning, fault tolerance, and the right architecture to scale to the extremes of big data. If you […]

Read the full article →

Patching and servicing of Windows and Linux – survey and email contact

May 21, 2015

HI folks, Ned here again. We are studying customer patching pain points and behaviors within Linux and Windows Server environments across operating systems and applications. If you are a stakeholder in the patching/updating process for your company and would like to share your thoughts and feedback, please take a few minutes to fill out the […]

Read the full article →

AMD: Nvidia GameWorks “sabotaged” Witcher 3 performance

May 21, 2015

While AMD seems to have made up with Slightly Mad Studios, at least if this tweet from Taylor is anything to go by, the company is facing yet another supposedly GameWorks-related struggle with CD Projekt Red’s freshly released RPG The Witcher 3. The game makes use of several GameWorks technologies, most notably HBAO+ and HairWorks. […]

Read the full article →

An in-depth look at the Registry settings that control Microsoft DPM 2012

May 20, 2015

~ Mike Jacquet | Senior Support Escalation Engineer Hello everyone, Mike Jacquet here from the DPM support team at Microsoft. I would like to share some registry settings that you may not be aware of that can alter the behavior of DPM, enable features, eliminate uncommon errors, and help with troubleshooting. Many of these registry […]

Read the full article →

Tech Giants Press Senate On NSA Reform

May 20, 2015

 The NSA reform bill passed by the House has an uncertain future in the Senate. The USA FREEDOM Act will receive a vote in the upper chamber, likely later this week, but whether it has the 60 votes required to pass isn’t clear. Tech giants want it to pass. The assembled market cap behind Reform Government Surveillance […]

Read the full article →

Azure Data Services for Business Intelligence

May 19, 2015

A little known fact the biggest workload on Azure VM’s (aka IaaS) is .. SQL Server. This might seem odd give that there is a SQL Azure service where you can run SQL Server database without worrying about SQL Server itself.  So what’s going on here? There are a few possible options: These VMs might […]

Read the full article →