Skip to content
SQLInsight

SQLInsight

We Do SQL Right!

  • What’s New
  • Power BI Gallery
  • PowerPoint Downloads
  • About Us
  • Contact Us
  • Home
  • Steve Schneider

Author: Steve Schneider

Import tab delimited data files directly into SQL Server via SSMS

June 1, 2016 Steve Schneider

Recently, I wanted to bring data into a SQL Server table, and I wanted to do so w/o SSIS. I know that I had done this before, but, of course, I had forgotten the details. I found the best answer…

Read more

SQL 2000, SQL 2005, SQL 2008, SQL 2012, SQL Administration, SSISData Import, SSIS, tab delimitedLeave a Comment on Import tab delimited data files directly into SQL Server via SSMS

Using SQL to read from a web service

May 2, 2016 Steve Schneider

Recently, I needed to find correct addresses for physical locations that I had only latitude and longitude.   The general process to do this follows: script to PROVE OUT the process for generating good addresses from JEA bad addresses thru the…

Read more

SQL 2012SQL, SQL 2012Leave a Comment on Using SQL to read from a web service

SQL Saturday May 2016, Jacksonville, FL

April 1, 2016 Steve Schneider

Hey, Everyone… our annual get-together of SQL professionals is happening on May 7th, at UNF, here in Jacksonville.  I will be speaking at 9 AM on breaking into the world of Azure & PowerBI, using (mostly) the skills you likely…

Read more

Azure, Career, Performance Tuning, PowerBI, SQL Administration, SSAS, SSIS, SSRSLeave a Comment on SQL Saturday May 2016, Jacksonville, FL

PowerBI

February 27, 2016 Steve Schneider

Now I am developing a PowerBI demo. Here’s my first look: This is based on Duval County Florida real estate parcels.

Azure, PowerBI, SQL 2012Azure, Duval County, Florida, PowerBILeave a Comment on PowerBI

Querying a remote server w/ SQLCMD

February 8, 2016 Steve Schneider

So, sometimes you need a simple way to run (often the same) command on two different servers at the same time. Perhaps setting up a Linkserver is difficult, or simply too time consuming. Here’s an option. Try SQLCMD.

SQL 2008, SQL 2012, SQL AdministrationLeave a Comment on Querying a remote server w/ SQLCMD

Direct query to excel (AceOleDb.dll)

January 30, 2016 Steve Schneider

So, often you need to get excel data into SQL ‘in a hurry’ for analysis.  After you’ve done a base case analysis you can go about getting the data in a more ‘regular’ fashion.  What’s the fastest way to get an…

Read more

SSISAceOleDB.dll, Excel, Import, SQL, SSISLeave a Comment on Direct query to excel (AceOleDb.dll)

Importing (old) SSIS packages into VS 2012

December 6, 2015 Steve Schneider

SQL 2012 introduced a new deployment model.  Many of us, for various reasons didn’t move along with Microsoft…and continued to use and deploy the old SSIS Packages (.dtsx) … even to SQL 2012.  So, that being the case, how do…

Read more

SQL 2012, SQL Administration, SSISpackages, projects, SSISLeave a Comment on Importing (old) SSIS packages into VS 2012

Government Transparency Powered by SharePoint 2013 and Sql 2012

April 27, 2015 Steve Schneider

Hey, everyone! There’s a great event here in Jacksonville, Florida. It’s coming in May.  Saturday, 9 May, to be specific.  It is like a mini Tech-ed. Free Food. Great Technical presentations.  Click the picture to the right to register! Lots…

Read more

SharePoint 2013, SQL 2012SharePoint, SQLLeave a Comment on Government Transparency Powered by SharePoint 2013 and Sql 2012

SharePoint 2013 and SQL Powered BI

June 7, 2014 Steve Schneider

I know i have been AWOL now for some time… i have been heavily focused on bringing up Sharepoint 2013…and also empowering it with SQL 2012. And, actually there’s even more to it than that. One of the benefits of…

Read more

SharePoint 2013, SSAS 2012Leave a Comment on SharePoint 2013 and SQL Powered BI

SQL Saturday Jacksonville, May 10, 2014

April 28, 2014 Steve Schneider

Hey, everyone! There’s a great event here in Jacksonville, Florida. It’s coming in May. It is like a mini Tech-ed. Free Food. Great Technical presentations.  Click the picture to the right to register! Lots of networking. Fellowship. Swag. After hours…

Read more

Azure, Career, Performance Tuning, PowerBI, SQL AdministrationLeave a Comment on SQL Saturday Jacksonville, May 10, 2014

Posts navigation

1 2 … 6 Next
Copyright SQL Insight 2017 © All rights reserved.
Business Era by mProThemes