About Me

I now work for Microsoft Federal in Chevy Chase, MD.

Dedicated to providing customer-driven, results-focused solutions to the complex business problems of today... and tomorrow.

At SQLTrainer.com, LLC  we understand that the technical challenges faced by businesses today are much greater in both scope and complexity than they have ever been. Businesses today are faced with understanding both local IT infrastructures as well as cloud-based technologies.

What is SQLTrainer.com?

Founded in 1998 by Ted Malone, SQLTrainer.com is a technical consulting, training and content development firm dedicated to the following core principles:

  • Technology Alone is NOT the Answer! - Implementing a particular technology because it is interesting or "cool" will not solve customer problems.
  • Technology Solutions do NOT need to be Overly Complex! - Many times developers and technical practitioners will attempt to build the most clever solution possible. While this serves to stroke the egos of those involved, it doesn't provide a maintainable solution.
  • Consultants Should be Mentors First! - When looking to hire an external consultant, businesses should look to the consultant who's willing to train themselves out of a paycheck.

Why the name, SQLTrainer.com?

SQL (pronounced See-Quell) stands for Structured Query Language, which is at the heart of every modern-day relational database system. Since many technology solutions today rely on some form of database storage or interaction, it was only logical to find a way to incorporate SQL into the name of the organization. Given that one of our core principles is to be a mentor/training above everything, the name SQLTrainer made sense. Since we also wanted to represent our embracing of the cloud, it seemed logical to add the ".com", referring to the biggest "cloud" of them all.

Live Feeds

Friday, April 17, 2015 5:40:15 PM

On Wednesday, April 15, Microsoft launched SQL Server 2014 Service Pack 1 (SP1).  Shortly after release we discovered an installation issue.  As a result, we have put the Service Pack downloads on hold.

SQL Server 2014 (SP1) will be re-released in the next few weeks. In the meantime, we recommend that you continue using SQL Server 2014 and its Cumulative Updates.

If you have encountered an issue during installation of the Service Pack, this article on the Release Services Blog will provide workaround steps.

Thursday, April 16, 2015 9:00:00 AM

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?



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.

Wednesday, April 15, 2015 2:00:00 PM

The SQL Server 2014 SP1 package download is temporarily unavailable.  Please read this post for more information.


One year ago, Satya Nadella spoke in San Francisco to launch SQL Server 2014.  Today, we are pleased to announce the release of SQL Server 2014 Service Pack 1 (SP1). The Service Pack is available for download on the Microsoft Download Center. As part of our continued commitment to software excellence for our customers, this upgrade is available to all customers with existing SQL Server 2014 deployments.

SQL Server 2014 SP1 contains fixes to issues that have been reported through our customer feedback platforms and Hotfix solutions provided in SQL Server 2014 CU 1 up to and including CU 5, as well as a rollup of fixes previously shipped in SQL Server 2012 SP2. 

A few of the customer-requested updates in Microsoft SQL Server 2014 SP1 are:

  • Column store performance is improved when batch mode operators spill over to disk. A new XEvent provides insights into column store inserts.
  • Several issues in buffer pool extension SSD configuration are addressed, including the ability to do instant initialization of the buffer pool extension file.
  • Certain queries compile faster when using new cardinality estimator, and other cardinality estimation query plans are more efficient when using TF-4199. 
  • The scalability benefits of two trace flags (TF-1236, TF-9024) are applied automatically.
  • Backup header information retrieval works better with encrypted backups.

Customers like Samsung Electro-Mechanics are already seeing the benefits of upgrading to SQL Server 2014. Samsung improved OLTP performance up to 24 times and DW up to 22 times when they upgraded to SQL Server 2014.  SBI Liquidity Market sped up their transaction performance by tenfold when they adopted SQL Server 2014 in-memory OLTP.

For information about upgrading to SQL Server 2014, see the tools and resources available at www.microsoft.com/sqlserverupgrade.  To trial SQL Server 2014, visit the SQL Server 2014 Evaluation Center.

For more highlights of the release, please read the Knowledge Base Article for Microsoft SQL Server 2014 SP1.  To obtain SQL Server 2014 SP1 with its improved supportability, please visit the links below. SQL Server 2014 with SP1 will be available in additional venues including the Volume Licensing center and via Microsoft Update starting May 1, 2015.

Monday, April 13, 2015 9:00:00 AM

Can you believe it’s been 10 great years since SQL Server 2005 was released? Extended support for this offering will end on April 12, 2016. Before support ends, you’ll need a plan for migrating remaining instances of SQL Server 2005. But, why wait to migrate when you have an opportunity to provide new value to your business now with a modern data platform? Many customers are already experiencing the benefits of upgrading to SQL Server 2014. GE Healthcare, for example, wanted a more flexible, scalable platform to deliver applications to healthcare providers worldwide. They met this goal using a cross-platform cloud strategy with SQL Server 2014 and Microsoft Azure. With SQL Server on Azure VMs, GE Healthcare can accelerate time-to-market, cuts costs and enable compliance for more customers.

If you’re hesitant to make this move, it is important that you know what end of support means for your business. After the end of support date, hotfixes and security updates will no longer be provided. The costs to maintain security and support as well as the potential liabilities associated with compliance audits can make it more expensive to stay on the old version than to upgrade. Now is the time to take advantage of new technology to support your business with SQL Server 2014, SQL Server 2014 in a VM (on-premises or in Azure), and/or Azure SQL Database.

Read more about SQL Server 2005 end of support on the Official Microsoft Blog and start planning your upgrade today. 

Thursday, April 9, 2015 9:00:00 AM

This is your opportunity to put your data skills to use for a good cause! Come along and meet other data pros as you use big data technologies to solve real-world problems, make a difference in your community, and learn about Microsoft’s big data technologies and cloud services. The Hackathons offer the chance to get hands on with the latest data science technologies and show the world what is possible when Hadoop/HD Insight, Machine Learning, and Power BI tools are used together to find solutions and unlock insights.

How does the Hackathon work? Contestants spend two days at the event, with food, drink, a $250 credit pass on Microsoft Azure, and other goodies & prizes provided. The agenda typically looks like this:

  • Day 1: Morning: registration and short presentations from top Microsoft data professionals and partners providing insight and instruction on big data and data science topics such as Hadoop and HDInsight, Power BI, and Machine Learning. (Note: The experts will be available for the duration of the hackathon to assist with questions). Hacking starts around noon, and the contestants self-organize into teams of 3-5 members to use data science tools to design and build an analytical model to solve a specific data science problem or challenge. The hacking will continue well into the evening, and has been known to go all night! (Note: Remember to bring your own lap top, cords and dongles)
  • Day 2: The competition continues from early morning to around 4pm, when the winning team will be announced by the Hackathon judging panel based on creativity, collaboration, innovation, and overall brilliance in data modelling and visualization. Cool prizes will be awarded to the winning teams.

Since November, over 500 data scientists and big data developers have participated in these big data Hackathons in London, Moscow, Johannesburg, Istanbul, San Jose, and Toronto. Didn’t make it to one of these events? You have more chances to participate! Check below for an upcoming Hackathon near you.

  • Register here for Cairo Hackathon, April 10th - 11th, 2015
  • Register here for Vancouver Hackathon, April 18th - 19th, 2015
  • Register here for New York Hackathon, May 9th - 10th, 2015
  • Register here for Copenhagen, May 23rd – 24th, 2015
  • Register here for Seattle May 30th-31st, 2015
  • Registration details coming soon for Hackathons in Frankfurt, Moscow, London, Zurich & Milan!

Interested in having a big data hackathon in your city? Let us know by leaving a note in the comments section.

Want to learn more about Microsoft’s big data solutions? Visit www.microsoft.com/bigdata.

Photo of the teams in San Jose Feb 2015, hacking in groups of 3-6.

Friday, March 20, 2015 9:00:00 AM

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: Grant Fritchey
Role: Product Evangelist, Red Gate Software
Location: Grafton, MA, USA

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

I’m helping to build a set of classes to teach people how to automate their database deployments in support of Database Lifecycle Management. Development is moving faster and faster in order to keep up with the demands of business. Because of this, databases must also be deployed faster and faster. But, you still have to ensure the protection of the vital business information stored within your databases. In the class I’m working on, we’ll show you how to get your database into source control alongside your application and how to perform continuous integration with databases. We’re going to cover all sorts of mechanisms for automating database deployments and database testing in order to work Database Lifecycle Management right into your Application Lifecycle Management.

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

The main challenges we have with databases are the same ones we’ve always had: performance and uptime. The thing is, we have blazing fast hardware these days. Or, if you’re looking at online solutions like Azure, we have very large VMs as well as methods for sharing across servers and databases. All this means that the underlying architectures of our database systems can perform very well. But, we still have to deal with the database design and the T-SQL code being run against the database. More and more we’re taking advantage of ORM tools such as Entity Framework, which really do speed up development. But, around 10% of the queries still need to be coded by hand in order to ensure adequate performance. Add to this the fact that we need to deploy all this while still ensuring up-time on the databases… Figuring out how to get adequate functionality in place without affecting up-time is tough work.

How does data help you do your job better?

Decisions on what to do with systems need to be based on information, not guesses. Data gathered about my systems shows me where I need to prioritize my work and directs choices on resource allocation.

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

Recently I found that I was seeing a serious “observer affect” in how I was collecting performance data. While tuning queries I was using STATISTICS IO and STATISTICS TIME. I normally do this all the time. As I was adjusting the code, I wasn’t seeing the kind of performance improvements I expected. In fact, some of my solutions seemed to be working even worse. I was a little surprised because I thought I was following a good methodology, and so I tried turning off all the STATISTICS capturing and just used Extended Events. Suddenly, the tuning started was working extremely well. I went back and experimented until I discovered that for some of my queries STATISTICS IO was actually impacting query execution, affecting both the time and the reads. Turning it off cleared the problem completely. I’ve now changed to using extended events most of the time in order to minimize, or eliminate, that issue. Best of all, I’m able to use these within Azure SQL Database as well as in my earthed servers.

What or who do you read, watch, or follow to help grow your data skills?

I go to SQLSkills.com over and over, sometimes multiple times in a day. It’s one of the single best resources for detailed SQL Server information. I also go to SQLServerCentral.com regularly to ask and answer questions. It’s a great resource for expanding your knowledge.

What’s your favorite SQL command and why?

RESTORE DATABASE: Because it has saved my job and the companies I’ve worked for so many times.

How does Azure help you protect your local databases?

There are a couple of ways you can use Azure to extend local capabilities. The first, and probably the easiest, is to use Azure Blob Storage as a means of ensuring that you have off-site storage of your backup files. You could pretty easily write a PowerShell script that copies your backups to Azure Storage. But, starting in SQL Server 2012, you can also issue a backup command to go straight to Azure Storage. Either way, you can be sure there’s a copy of your backups in case you suffer a catastrophic event locally.

Another way to extend your local capabilities to the cloud is to set up a virtual network. You can incorporate Azure Virtual Machines directly into your local network. Because of this, you can set up Availability Groups between Azure VMs and your local machines. This would enable you to have a failover setup to Azure, allowing for additional protection of your data and your systems.

Are there other ways Azure can be used in combination with local databases?

It’s my opinion that every developer should be using a local copy of SQL Server for their development. This is to allow them to experiment, learn, and, well, break stuff, without affecting anyone else. But, some laptops might be underpowered, or this could in some way violate a corporate policy. As a workaround, people can take advantage of the fact that SQL Database covers the vast majority of standard SQL Server functionality, at the database level. This makes it a great place to develop and test databases, especially if you’re already developing applications for Azure. You only need to keep the database around while you’re developing, and because you can keep the size small, the costs are extremely minimal.

Any other benefits for Azure in combination with local machines?

Tons. For one, expanded capacity. What if you need to get a lot more servers online quickly, but you’re hurting on disk space, or the servers are on back-order? Go back to that virtual network we talked about earlier. Set that up and now you can very quickly, even in an automated fashion through PowerShell, add SQL Server machines to your existing systems.

Another thing you could do, although this not something I’ve tried yet, is take advantage of the fact that in SQL Server 2014 you can actually add file groups that are in Azure Blob Storage. Do you need extra disks, right now, that you can’t get from the SAN team? Well, if you can afford a bit of latency, you can just expand immediately into Azure Storage. I’d certainly be cautious with this one, but it’s exciting to think about the expanded capabilities this offers for dealing with certain kinds of disk space emergencies.

Thanks for joining us, Grant!

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

Wednesday, March 18, 2015 9:00:00 AM

This is a guest blog post from Thomas LaRock, the President of PASS (Professional Association for SQL Server)

It’s no secret that the role of data in the IT industry, in business, and in the world at large is changing at a rapid pace. As technology continues to become a more integrated and integral part of our lives the value of data continues to rise.

At PASS we have a 16-year history of empowering IT professionals who use Microsoft data technologies. The SQL Server community is the largest and most engaged group of data pros in the world. PASS volunteers and the PASS Board of Directors work together to help the PASS community succeed in connecting, sharing, and learning from one another. A big part of that effort is keeping an eye on the future of the data profession.

What we see is that data analytics is the next frontier for professionals passionate about data. The growth of Big (and Little) Data, the advent of cloud computing, and advances in machine learning are all areas that present challenges for our community. Data analysts, data scientists, and line-of-business managers are in high demand as organizations realize the potential of collecting and understanding the wealth of information that is available from a variety of sources.

PASS is dedicated to helping our members harness the technologies, skills, and networks that are the foundation of solid and successful careers. We believe that keeping up with industry advances is a vital skill for all data professionals. Setting and achieving new goals as well as learning new ways of working with data is a must.

Whether you’re coming from a background in SQL Server, business intelligence, or social media there are specific cornerstones of turning all this data into something that can benefit your organization. We call this the “analyst’s journey.”

One such cornerstone is data discovery and integration. We want our members to be aware of the latest technologies in collecting, modeling, and preparing data for analysis. Next is data analysis and interpretation. We want to help our members understand the techniques and tools that enable sophisticated analysis, prediction, and optimization. Then there’s visualization: the creative side of things, where we get into report and dashboard design.

As with any career another key skillset is communication. The people who analyze and work with data are in the best position to help gain executive buy-in for data-driven business decisions. For years PASS has been the leader in helping data professionals improve their communication and soft skills.

One way in which we’re reaching out to those who want to learn more about analytics is the PASS Business Analytics Conference. This premiere event brings together a stellar lineup of business and analytics speakers including our keynote speakers Carlo Ratti and BI Brainz founder Mico Yuk. We have created a series of webinars and a Meet the Expert interview series to give people an idea of what the conference will offer. We also have replays from last year’s conference, and we have hours of training available through our Virtual Chapters.

We’re excited about data and analytics and we’re hearing from more and more SQL Server pros who share that excitement.

It’s a wonderful time to be a data professional.

See you in Santa Clara!

Thomas LaRock

President, PASS


Thursday, March 12, 2015 12:00:00 PM

As of March 11 2015, SAP has certified support for SAP NetWeaver-based applications on Microsoft SQL Server 2014.  Now you can run even more of your Tier-1, mission-critical workloads on SQL Server.  And, the ability to run SAP on Microsoft Azure means that it can be accomplished with low total cost of ownership (TCO).

SQL Server 2014 provides the higher scale, availability, and breakthrough performance needed for your most demanding SAP workloads. The updatable in-memory ColumnStore will deliver blazing fast query performance for your SAP Business Warehouse (BW).  SQL Server AlwaysOn availability groups help with the reliability and availability requirements of SAP systems by enabling multiple, readable secondaries that can be used for failover and read workloads like reporting and backup.

With SAP’s certification, you can also run SAP in Microsoft Azure Virtual Machines with SQL Server 2014. Azure enables SAP customers to reduce TCO by leveraging Microsoft infrastructure as system needs grow, rather than investing in additional servers and storage.  With Microsoft Azure, customers can leverage development and test environments in the cloud that can be spun up and scaled out as needed.  SQL Server 2014 also introduced Disaster Recovery to Azure using an asynchronous AlwaysOn secondary, which can make Azure a part of your SAP disaster recovery plan.

With the certification, customers can now adopt SQL Server 2014 for mission-critical SAP workloads, and we look forward to telling you their stories soon. Here are some customers who are taking advantage of SAP on SQL Server today:

  • Quanta Computer Boosts Performance of Its SAP ERP System with In-Memory Technology
  • Zespri International Prunes Costs, Defends Business from Disasters by Running SAP in the Cloud
  • Saudi Electric Company Increases Query Times by 75 Percent, Can Respond Faster to Customers
  • Mitsui & Co. Deploys High-Availability and Disaster-Recovery Solution After Earthquake

Many companies are already betting their mission critical apps on SQL Server 2014. To read about Microsoft’s leader position for business critical operational database management and data warehouse workloads, read Gartner's Magic Quadrant for Operational Database Management Systems and Magic Quadrant for Data Warehouse Database Management Systems Report.  For more information about how customers are already using SQL Server 2014 for mission critical applications, read these case studies:

For more about the powerful combination of Microsoft and SAP, visit http://www.microsoft.com/SAP.  To get started with SQL Server 2014, click here.

Tuesday, March 10, 2015 9:00:00 AM

Hybrid cloud solutions offer the best of both worlds: you get the flexible power of the cloud combined with the tight control of localized datacenters. SQL Server offers tons of out-of-the-box hybrid capabilities, and Microsoft Principal PM Nosheen Syed will show you how to make the most of them in his Ignite session "Microsoft SQL Server to Microsoft Azure Virtual Machines: Hybrid Story."

You'll learn all about:

  • Using Managed Backup to take charge of data storage sensibly
  • Boosting IT efficiency with Azure Replica Wizard
  • Easy "lift and shift" migration of on-site SQL Server workloads to Azure Virtual Machines
  • Backup to Block Blob, which is as easy to use as it is difficult to say

There’s plenty more happening at Ignite. Get email updates by subscribing here. And if you haven’t already, register for Ignite here.

Monday, March 9, 2015 1:00:00 PM

As part of SQL Server’s ongoing interoperability program, we are pleased to announce an updated Microsoft SQL Server driver for PHP.  The new driver, which supports PHP 5.6, is now available!

This driver allows developers who use the PHP scripting language to access Microsoft SQL Server and Microsoft Azure SQL Database, and to take advantage of new features implemented in ODBCThe new version works with Microsoft ODBC Driver 11 or higher.

You can download the PHP driver here.  We invite you to explore the rest of the latest the Microsoft Data Platform has to offer via a trial evaluation of Microsoft SQL Server 2014, or by trying the new preview of Microsoft Azure SQL Database.

Site Map | Printable View | © 2008 - 2015 SQLTrainer.com, LLC | Powered by mojoPortal | HTML 5 | CSS | Design by mitchinson