Category Archives: SQL 2012

Import tab delimited data files directly into SQL Server via SSMS

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 … Continue reading

Posted in SQL 2000, SQL 2005, SQL 2008, SQL 2012, SQL Administration, SSIS | Tagged , , | Leave a comment

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 … Continue reading

Posted in SQL 2012 | Tagged , | Leave a comment

PowerBI

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

Posted in Azure, PowerBI, SQL 2012 | Tagged , , , | Leave a comment

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.

Posted in SQL 2008, SQL 2012, SQL Administration | Leave a comment

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 … Continue reading

Posted in SQL 2012, SQL Administration, SSIS | Tagged , , | Leave a comment

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 … Continue reading

Posted in SharePoint 2013, SQL 2012 | Tagged , | Leave a comment