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…
Category: SQL 2012
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…
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.
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…