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…
Year: 2016
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…