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…
Author: Steve Schneider
Using SQL to read from a web service
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…
SQL Saturday May 2016, Jacksonville, FL
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…
PowerBI
Now I am developing a PowerBI demo. Here’s my first look: This is based on Duval County Florida real estate parcels.
Querying a remote server w/ SQLCMD
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.
Direct query to excel (AceOleDb.dll)
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…
Importing (old) SSIS packages into VS 2012
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…
Government Transparency Powered by SharePoint 2013 and Sql 2012
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…
SharePoint 2013 and SQL Powered BI
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…
SQL Saturday Jacksonville, May 10, 2014
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…