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 here:

The solution requires putting a “Schema.ini” file in the same directory as the file you are attempting to upload, and the file HAS TO BE NAMED “schema.ini” (case insensitive). The contents of the simple text file should be as follows:

Continue reading “Import tab delimited data files directly into SQL Server via SSMS”

SSRS Data Source Lister

Hello,

Sometimes, you’re in the middle of doing something, and you need an answer.  You google it and find such a great solution, you want to keep it handy for … whenever!  Here is such a post.  As the title of my post indicates, you can list out the Data Sources that exist on an SSRS server… and you can do so with this code…which i got entirely from http://gallery.technet.microsoft.com/scriptcenter/List-connection-strings-of-1a9a9adc.  Thank you Olaf Helper!

 

Sql Binaries location, SessionTimeout, Sql Version

OK…this is a ‘strange’ post… That is because the script i have for you today is a real ‘utility’ script… it does three things that occasionally come in REAL handy! It tells you the location of your SQL binaries. It tells you the length of the session time out for the server your instance is running on. It tells you the full SQL Version information. Enjoy! Continue reading “Sql Binaries location, SessionTimeout, Sql Version”

Out of disk space…Log file grown too big?

It’s early in the morning, and you’ve got disk space problems… log file, right?  Yep.   OK, we need a script that will tell us what we need to know ASAP.  Since i experienced this issue multiple times…and since they always happened on Sunday morning…just before i was going to church (how much more inconvenient can it get?)…i created just such a script.  Using two CTE’s i first gather the information i need about the database data files, and then the database log files.  Since there can be multiple physical files for either type, i max and sum the needed values before grouping.  Then, i combine that data with sys.database information.  The result gives me almost all i need to know in a single picture…i’m ready then, with a simple “xp_fixeddrives” to get straight to fixing things. Continue reading “Out of disk space…Log file grown too big?”