SQL Server

17 Years of SQL Experience

Our owner started working on databases while employed at AT&T as a data analyst, and worked for 11 years on one of the largest data warehouses in the world.  He then moved on to Conn's Appliances where he worked with legacy databases in DB2 as well as SQL server to deliver retail data in real-time to all departments.  Since 2013, he has been solely focused on Spectrum's SQL Server database and reporting solution, and has helped his current employer and side customers achieve their construction reporting initiatives across all modules of the software.  He has written complex queries on a variety of RDBMS's, including DB2, Teradata, Oracle, INGRES, and SQL Server.  His most memorable effort is a 10,000 line stored procedure that delivers 16 different Job Cost reports in Spectrum through Crystal Reports.

SQL Server Queries and Views

Given our background in SQL, we can create specialized tables and views that can be utilized to provide key data quickly and accurately when you need it. Here are some things we can provide you:

  • Add additional data points to existing Crystal Reports with custom views.
  • Create views for new dashboards to improve your business efficiency.
  • Integrate views into Excel Workbooks to pull data directly from SQL.
  • Help your local admin or IT folks on creating tables and views that can support your Spectrum installation.

How can we help you today?

We're ready to help you with any SQL Server items, queries, views or other issues you may have!  We charge our normal development rate when performing work on your SQL Server database.  Drop us an email today at billy@nannerb.com or give us a call at 409-344-0406.  We look forward to hearing from you!