Data Scientist versus Data Engineer #datascience #bigdata #analytics
One of the main differences between a data scientist and a data engineer has to do with ETL versus DAD:
ETL...
2014-02-18
1,173 reads
SSPI Handshake Failed
A fellow community member sent me an email saying he was having trouble authenticating with Kerberos. Here is the error...
2014-02-26 (first published: 2014-02-18)
4,176 reads
Walmart Store Openings through Power Map
A couple weeks back, I was taking a look at a map that had been put together on Flowing Data...
2014-02-21 (first published: 2014-02-18)
2,396 reads
PolyBase explained
PolyBase is a new technology that integrates Microsoft’s MPP product, SQL Server Parallel Data Warehouse (PDW), with Hadoop. It is designed to...
2014-02-25 (first published: 2014-02-18)
18,213 reads
Hilux – @BBC #TopGear
May drives a modified Hilux to the rim of that unspellable Icelandic volcano that subsequently shut down Europe’s airspace
via Search...
2014-02-18
357 reads
The CASE Statement and Performance
In case you don’t know, this query:
UPDATE dbo.Test1
SET C2 = 2
WHERE C1 LIKE '%33%';Will run quite a bit slower than this...
2014-02-25 (first published: 2014-02-18)
6,557 reads
Dealing with the mysterious “True” column in BIML
Recently I ran into the following error when compiling BIML into SSIS packages:
The message itself is not very revealing:
The data...
2014-02-18
1,028 reads
Virtual Teams: 3 Ways to Improve Efficiency and Performance #virtual #teams
How to enhance the performance of virtual teams
Virtual teams have some advantages, from allowing the best talent recruitment regardless of...
2014-02-18
480 reads
Create Database Error "operating system error 112(There is not enough space on the disk.)"
I try to create database by generating script of another database, which was a huge Database. When I run the script below
USE [master]
GO
CREATE DATABASE [YourDB] ON PRIMARY
( NAME...
2014-02-18
95 reads
Improving SQL Server Performance by using Instant File Initialization
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...
2014-02-21 (first published: 2014-02-18)
3,655 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Helping an English Student with R
Comments posted to this topic are about the item Helping an English Student with...
Adding Bits I
Comments posted to this topic are about the item Adding Bits I
Question of the Day
Adding Bits I
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers