3Deers.com, LLC
Facebook Twitter LinkedIn Mail
  Menu
Skip to content
  • Home
  • Excel for SQL Business Intelligence
    • Overview
    • How to Connect to SQL from Excel
    • Create Your First SQL Report In Excel
    • Excel Table Best Practices
    • Multiple Tables For Useful Information
    • SQL Joins for Better Table Links
    • Build Intelligence into your Business Data
    • Pivot Table Cleanup
    • Graph and Show Results
  • Who We Are
    • Perry T Patterson
    • Perry-Isms
  • Blog
  • Technical Papers
    • ExtraNet Case Study
    • eCommerce and Sales Tax
  • Contact Us

Author Archives: admin

« Older posts
Newer posts »

SQL Connections Slow on Windows 8 and Excel

By admin | April 10, 2014|April 10, 2014 SQL-Excel Tips and Help
Leave a comment

Named Pipes.  That’s the Jeopardy answer to a question that took 3Deers a month or so to answer regarding a sever slowdown in the queries from Microsoft Excel to a SQL database.  Named (freaking) Pipes. For folks that use Excel to access SQL and do great Business Intelligence Reports (like… Continue reading →

5 Tips for SEO Friendly Blogs

By admin | December 21, 2013|December 21, 2013 Independents Exchange
Leave a comment

5 Tips for writing SEO friendly blogs for the new or basis blogger. There are some very easy tools and techniques that can be easily mastered. Continue reading →

Excel For Business Intelligence – SQL Presentation

By admin | August 1, 2013|August 1, 2013 SQL-Excel Tips and Help
Leave a comment

July 13 was a great day at the IT Pro Camp hosted by Keiser University in Ft. Lauderdale (http://itprocamp.com/southflorida/south-florida-it-pro-camp/).  I was honored to represent 3Deers and do a presentation on utilizing Microsoft Excel as a front end tool for Business Intelligence. Many people do not realize that you can use… Continue reading →

IT ProCamp – Excel for Business Intelligence

By admin | July 8, 2013|July 8, 2013 SQL-Excel Tips and Help
Leave a comment

I am trilled to announce that I have been selected to speak this weekend at the South Florida IT ProCamp on Excel for Business Intelligence. Continue reading →

What is a Blog and Post?

By admin | March 21, 2013|March 21, 2013 Independents Exchange
Leave a comment

As part of my Coral Springs Chamber of Commerce networking group, I was asked for my definition of a blog and a post.  Are they the same thing?  Where does a company or person blog and post?  Blogging and posting: what are they and what is the difference? Before I… Continue reading →

Chamber Helping Chamber

By admin | February 18, 2013|February 18, 2013 Independents Exchange
Leave a comment

When starting a new business, networking is widely regarded as a key to get going.  Funds for advertising are slim, and probably not even a good investment for a private consultant.  I am looking for solid long-term clients, not trying to sell a copy of a software program or widget…. Continue reading →

Help! What should I write in my BLOG today?

By admin | February 11, 2013|February 11, 2013 Independents Exchange
Leave a comment

Ever wonder “What should I write in my blog?” Looking for some help on your writer’s block or do you just want to Build Links on Google? Continue reading →

Be Prepared, Even When You Can’t Prepare

By admin | January 17, 2013|January 17, 2013 Independents Exchange
Leave a comment

As a consultant, especially as an independent looking to build a new business, one must be prepared for anything!  Meetings… proposals… client reviews… you never know what might happen. It has been some years, but I remember going with a group to visit a long-term client.  We had a good… Continue reading →

Social Sharing Is Nice… for SEO

By admin | January 9, 2013|January 9, 2013 Independents Exchange
Leave a comment

A common request from clients is a way for readers to have easy sharing of their posts.  Comments are nice, but they notice less and less people registering for sites and comments… readers just want to do a quick social sharing on to their favorite platform.  Let us face it;… Continue reading →

WordPress Network Solution

By admin | January 4, 2013|January 4, 2013 WordPress Help and Site News
Leave a comment

As a webmaster and WordPress host with multiple clients, a provider must decide whether to use a single instance of WordPress for all your clients or keep each client separated.  There are pros and cons for each approach. If you keep each of your clients or blogs on a separate… Continue reading →

1234
    • My Journey with Co-Pilot
    • SQL and Excel Tips and Tricks
    • Independents Exchange

  • IONOS Cloud and Website Hosting

  • Laptops on Sale at Amazon