January 19, 2015 at 10:45 am
Ed Wagner (1/19/2015)
GilaMonster (1/19/2015)
Well this is fun.Officially, according to the government, South Africa uses the , as the decimal point. In reality, everyone, including the government, uses the .
Windows 7, when used with English (South Africa) had the decimal separator for numbers as .
Windows 8, when used with English (South Africa) has the decimal separator for numbers as ,
SQL Server uses the regional settings of the machine it's installed on. Hence when running on a Windows 8 machine that is set to South African regional settings, SSIS refuses to accept that '34.22' is a valid number.
SQL Server doesn't care, SSIS throws a fit.
And I have 30 grads doing a homework exercise that requires they import data from flat file into SQL Server (import/export wizard is the way everyone who searches google will find)
It's gonna be a looooog week.
The joys of working with different number formats. So, if they figure it out, would that be extra credit? 😉 I wonder if using BULK INSERT with a format file would allow it through.
This whole thing of number/time formats is wrong. We should all have settled to one format and forget the past.
The metric/non metric system has already done enough harm, we didn't really need the regional options thing...
Of course, everybody should be using the Italian format, ça va sans dire... 😀
When I was at primary school, I was taught that comma is the decimal separator and ' is the thousands separator.
Windows insists using . as the thousands separator.
When you type a number in calc.exe using the numeric pad you can use . as a decimal separator, but it will display as ,
The same happens in Excel, but if you use the "other" dot in the keyboard (the one not in the numeric pad) what you enter is treated as a date, but the date separator in Italy is /
This whole thing is totally f***ed up.
-- Gianluca Sartori
January 19, 2015 at 11:42 am
Koen Verbeeck (1/19/2015)
GilaMonster (1/19/2015)
And I have 30 grads doing a homework exercise that requires they import data from flat file into SQL Server (import/export wizard is the way everyone who searches google will find)It's gonna be a looooog week.
Let them do it like everyone does:
import as text, convert in SQL Server.
Yup. Let's see how many figure that one out.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 19, 2015 at 11:48 am
GilaMonster (1/19/2015)
Koen Verbeeck (1/19/2015)
GilaMonster (1/19/2015)
And I have 30 grads doing a homework exercise that requires they import data from flat file into SQL Server (import/export wizard is the way everyone who searches google will find)It's gonna be a looooog week.
Let them do it like everyone does:
import as text, convert in SQL Server.
Yup. Let's see how many figure that one out.
It's no fun that way.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 19, 2015 at 11:58 am
SQLRNNR (1/19/2015)
GilaMonster (1/19/2015)
Koen Verbeeck (1/19/2015)
GilaMonster (1/19/2015)
And I have 30 grads doing a homework exercise that requires they import data from flat file into SQL Server (import/export wizard is the way everyone who searches google will find)It's gonna be a looooog week.
Let them do it like everyone does:
import as text, convert in SQL Server.
Yup. Let's see how many figure that one out.
It's no fun that way.
It's always fun that way. It might not be efficient, but it's fun.
January 19, 2015 at 12:06 pm
Jack Corbett (1/19/2015)
Jeff Moden (1/18/2015)
Grant Fritchey (1/18/2015)
WayneS (1/18/2015)
I'm curious...How many folks have a home lab set up with servers?
How many folks just use virtual machines on a computer (be it laptop, etc)?
Other?
If you feel like it, why did you choose that route?
I for one do everything with VMs on my laptop.
Everyone say it with me...
AAAAAZZZZZZUUUUUURRRE!!!
Maybe that's ok for some folks but that would constitute a huge NFW for me and the company I work for.
Jeff,
I think this question is about home labs versus doing things for work. Azure should be fine for a "home" lab setup.
Understood but, if I'm not using it at work and no one I work with nor any of my clients use it, why would I use it at home?
--Jeff Moden
January 19, 2015 at 1:31 pm
Jeff Moden (1/19/2015)
Jack Corbett (1/19/2015)
Jeff Moden (1/18/2015)
Grant Fritchey (1/18/2015)
WayneS (1/18/2015)
I'm curious...How many folks have a home lab set up with servers?
How many folks just use virtual machines on a computer (be it laptop, etc)?
Other?
If you feel like it, why did you choose that route?
I for one do everything with VMs on my laptop.
Everyone say it with me...
AAAAAZZZZZZUUUUUURRRE!!!
Maybe that's ok for some folks but that would constitute a huge NFW for me and the company I work for.
Jeff,
I think this question is about home labs versus doing things for work. Azure should be fine for a "home" lab setup.
Understood but, if I'm not using it at work and no one I work with nor any of my clients use it, why would I use it at home?
This is a good point but on the other side, would you feel comfortable advising your clients on it if you didn't have the experience?
😎
January 19, 2015 at 1:55 pm
Jeff Moden (1/19/2015)
Jack Corbett (1/19/2015)
Jeff Moden (1/18/2015)
Grant Fritchey (1/18/2015)
WayneS (1/18/2015)
I'm curious...How many folks have a home lab set up with servers?
How many folks just use virtual machines on a computer (be it laptop, etc)?
Other?
If you feel like it, why did you choose that route?
I for one do everything with VMs on my laptop.
Everyone say it with me...
AAAAAZZZZZZUUUUUURRRE!!!
Maybe that's ok for some folks but that would constitute a huge NFW for me and the company I work for.
Jeff,
I think this question is about home labs versus doing things for work. Azure should be fine for a "home" lab setup.
Understood but, if I'm not using it at work and no one I work with nor any of my clients use it, why would I use it at home?
I'm not taking about Windows Azure SQL Databases, but spinning up a VM in Azure to work with a new feature of Windows/SQL/whatever. Or spinning up a whole domain to play with AG's or clustering. You can just use the templates and have a SQL Server up and running in 10-15 minutes.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 19, 2015 at 5:22 pm
Eirikur Eiriksson (1/19/2015)
Jeff Moden (1/19/2015)
Jack Corbett (1/19/2015)
Jeff Moden (1/18/2015)
Grant Fritchey (1/18/2015)
WayneS (1/18/2015)
I'm curious...How many folks have a home lab set up with servers?
How many folks just use virtual machines on a computer (be it laptop, etc)?
Other?
If you feel like it, why did you choose that route?
I for one do everything with VMs on my laptop.
Everyone say it with me...
AAAAAZZZZZZUUUUUURRRE!!!
Maybe that's ok for some folks but that would constitute a huge NFW for me and the company I work for.
Jeff,
I think this question is about home labs versus doing things for work. Azure should be fine for a "home" lab setup.
Understood but, if I'm not using it at work and no one I work with nor any of my clients use it, why would I use it at home?
This is a good point but on the other side, would you feel comfortable advising your clients on it if you didn't have the experience?
😎
If I had clients on it, then yes, I'd fire that puppy up so that I could advise and demonstrate to my clients why I think they should not be on it. 😉 Sorry MS.
--Jeff Moden
January 19, 2015 at 5:25 pm
Jack Corbett (1/19/2015)
I'm not taking about Windows Azure SQL Databases, but spinning up a VM in Azure to work with a new feature of Windows/SQL/whatever. Or spinning up a whole domain to play with AG's or clustering. You can just use the templates and have a SQL Server up and running in 10-15 minutes.
Would such a VM still be in the cloud?
--Jeff Moden
January 20, 2015 at 5:46 am
WayneS (1/18/2015)
I'm curious...How many folks have a home lab set up with servers?
I used to. I need to set one up again.
How many folks just use virtual machines on a computer (be it laptop, etc)?
Other?
I need to learn how to set up VMs so I can get a new lab set up. I think someone (Gail, perhaps) mentioned VMWare on another thread. What is everyone using for VM software?
I'm concerned with how much hard drive space I'm going to need for the setup and whether or not a USB drive can be used to assist me with this or not.
January 20, 2015 at 5:50 am
GilaMonster (1/19/2015)
Well this is fun.Officially, according to the government, South Africa uses the , as the decimal point. In reality, everyone, including the government, uses the .
Windows 7, when used with English (South Africa) had the decimal separator for numbers as .
Windows 8, when used with English (South Africa) has the decimal separator for numbers as ,
SQL Server uses the regional settings of the machine it's installed on. Hence when running on a Windows 8 machine that is set to South African regional settings, SSIS refuses to accept that '34.22' is a valid number.
SQL Server doesn't care, SSIS throws a fit.
And I have 30 grads doing a homework exercise that requires they import data from flat file into SQL Server (import/export wizard is the way everyone who searches google will find)
It's gonna be a looooog week.
OUCH. That is going to be so much fun. Are they even going to think about using Derived column tasks?
And how would that work, I wonder. Oh, I feel like an experiment coming on as soon as I finish my website job status project.
January 20, 2015 at 6:41 am
GAH. Talk about a "drain bramage" kind of day. I knew the answer to this once, but my head just cannot seem to come up with the answer today. Can someone chime in and help me out?
January 20, 2015 at 9:31 am
We are finally starting to move our ERP to a new system (well new to us but still rather antiquated). In the process of looking at vendors our mainframe system doesn't really have the ability to handle international addresses. To get around these limitations our users are extremely creative in putting garbage into the system. During some analysis for data migration here is a gem that was uncovered.
State = HO
Zip = NDURA
Zip Ext = S
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
January 20, 2015 at 11:11 am
Sean Lange (1/20/2015)
We are finally starting to move our ERP to a new system (well new to us but still rather antiquated). In the process of looking at vendors our mainframe system doesn't really have the ability to handle international addresses. To get around these limitations our users are extremely creative in putting garbage into the system. During some analysis for data migration here is a gem that was uncovered.State = HO
Zip = NDURA
Zip Ext = S
Our users just put it in as the name.
Had a client send data with an address of NANANANANA.
January 20, 2015 at 11:19 am
Sean Lange (1/20/2015)
We are finally starting to move our ERP to a new system (well new to us but still rather antiquated). In the process of looking at vendors our mainframe system doesn't really have the ability to handle international addresses. To get around these limitations our users are extremely creative in putting garbage into the system. During some analysis for data migration here is a gem that was uncovered.State = HO
Zip = NDURA
Zip Ext = S
I'm curious. What mainframe system?
Viewing 15 posts - 46,996 through 47,010 (of 66,000 total)
You must be logged in to reply to this topic. Login to reply