joeblogs.ie
Tags: data visualisation
Data Visualisation
Tags: qi
QI
Tags: jquery mobile
jquery mobile
Tags: android
Android
Following on from this post on identifying SQL server versions, this blog gives very detailed information on all SQL server versions and service packs
Tags: sql server
SQL Server
This is a useful tool from redgate, formats SQL. An excellent online companion to SQL Fiddle
Tags: sql
SQL
SELECT * FROM OPENROWSET ('Microsoft.Jet.OLEDB.4.0' ,'Excel 8.0;Database=C:\test.xls' ,'SELECT * FROM [Sheet1$]') Or from CSV: SELECT * FROM OPENROWSET('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};DEFAULTDIR=C:\;Extensions=CSV;','SELECT * FROM my_csv.csv')
Or from CSV:
SELECT * FROM OPENROWSET('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};DEFAULTDIR=C:\;Extensions=CSV;','SELECT * FROM my_csv.csv')
Tags: openrowset
T-SQL | SQL Server
One of my bete noirs in SQL server is collation and the problems that can arise from it. Thankfully Joel Spolsky has written a very in-depth guide on collation and character sets that will help everyone to get to grips with this subject.
Tags: unicode, collation
UNICODE
Had a torrid time trying to get SSIS working to import a fixed width text file into SQL server. In the end due to lack of flexibility with SSIS packages I opted to revert to using schema files instead. This worked perfectly, but the only downside is that there has to be a unique schema file per text file if the fixed width layout is different.
This article from Datebase Journal is all you need to get started. Also there are some useful functions in this article by Phil Factor
Tags: sql server, t-sql, openrowset
SQL Server | T-SQL
Click here for full article
Tags: jquery, asp.net
.NET
Powered by BlogEngine.NET 1.5.0.7 Theme by Mads Kristensen