In many cases the job itself doesn't really get eliminated, it's just that the requirements of the role get redefined. Sales associates become call center representatives, commercial architects become eCommerce...

Happy New Years too! 🙂

Excel is a terrible format for automated data exchange. Aside from all technical issues involved in installing and configuring and Excel driver there is the following:

When the user hides rows...

chrisn-585491 (12/29/2016)

---

On the flip side there's even more great open data sets to build analysis skills on. Everything from census to the stars, if you want some real data to...

2016 contained many epic watershed moments illustrating how the holy trinity of Social Media, Big Data, and Internet Enabled Consumer Devices are vulnerable to abuse. Overall, it was a very...

If the baseline for comparison is throwing one's laptop across the room in a fit of rage, then your solution is probably more like 10x faster. It would also be...

I've never heard it or asked it during an actual interview. Someone else on the team had suggested using it once for...

The following is an example of Lowell's suggestion about implementing a computed column (ie: NonSignedProductCode). You can then create an index on that column and use it for searching.

Whether...

The LEN() function returns the number of printable characters. It excludes trailing spaces, and for numeric and date columns it will count the number of characters in the default string...

David.Poole (12/27/2016)

---

The BBC used to reuse tapes because the media used to cost a fortune. Every now and again someone finds a copy of an ancient TV program hidden...

If you want to insure that your family photos are passed down forever to your grand children, then consider DNA digital data storage. It's a special gift that will always...

mcfarlandparkway (12/27/2016)

---

Hello,

how to write a query - to exclude the field that starts with ING

select * form table where...

Doctor Who 2 (12/27/2016)

---

Eric M Russell (12/27/2016)

---

Did you download it from a MSDN subscription or from Visual Studio Dev Essentials members?

I think there is a feature in the SQL Server...

Outside of an ETL staging environment, the routine usage of RegEx expressions would indicate something is amiss in the data model design or data quality.

I would import the records from the .csv file into a user table (not a temp table), and then create a primary key on DriverMD5 column. The other table, the...