Viewing 15 posts - 3,226 through 3,240 (of 6,041 total)
Whether an IT department is Great or Lousy; it's determined by the aggregation of those of us in the department.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 27, 2015 at 10:29 am
One great quote in there is "velocity is more important than perfection", which is a tenet that I have found to be very true over the years. It's not...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 27, 2015 at 9:14 am
My (admittedly un-scientific) belief is that only a small percentage of organizations in private (or public) sector engage in what could be genuinely called "data science". Whatever predictive modeling they...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 27, 2015 at 8:42 am
below86 (10/27/2015)
Eric M Russell (10/27/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 27, 2015 at 8:26 am
I generally look to see what the most common condition is. That condition gets the zero value. The abnormal condition gets the 1 value. Then I just name the column...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 27, 2015 at 8:02 am
I mentioned earlier that I prefer using two date columns to indicate active status like so:
ActiveDate date not null default (getdate()),
InactiveDate date not null default ('9999-12-31'),
check (InactiveDate >= ActiveDate),
However,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 27, 2015 at 7:55 am
Gary Varga (10/27/2015)
I pay little attention to these lists as they often highlight niche skills that are becoming more commonplace or being rolled into other roles over time.
When an industry...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 27, 2015 at 7:43 am
Niko Neugebauer has written a great series of blog posts about Clustered ColumnStore internals.
Clustered Columnstore Indexes – part 36 (“Maintenance Solutions for Columnstore”)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 27, 2015 at 7:33 am
xsevensinzx (10/26/2015)
Eric M Russell (10/26/2015)
..If you look through the jobs, many are development positions, but there are some good data ones. Data modeler, BI Analyst, Data Architect, Big Data Engineer,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 26, 2015 at 2:14 pm
Eric M Russell (10/26/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 26, 2015 at 11:03 am
Besides searching across text of all database objects, another approach is to search the text of cached query plans. This will narrow the search to only those objects and statements...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 26, 2015 at 10:30 am
below86 (10/26/2015)
GeorgeCopeland (10/26/2015)
Programmers who ignore their DBA consultants are idiots.I ignore my DBA every day, oh wait, we don't have a DBA. 🙂
Many organizations, even if they have good...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 26, 2015 at 9:29 am
GeorgeCopeland (10/26/2015)
0 = True is not just dumb, it is malicious. I want programmers like this far from my team.
Dumb (or just inexperienced) programmers are hired to initially develop databases,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 26, 2015 at 8:56 am
The following operation will set database to RESTRICTED_USER mode, meaning that only SYSADMIN accounts can login. It also does a rollback and disconnect on any existing connections.
alter database <db_name> set...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 26, 2015 at 7:45 am
I'd keep staging in a separate database, because that gives you the flexibility to set whatever recovery model, backup schedule, log truncation, and other database options are optimal for staging...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 26, 2015 at 7:37 am
Viewing 15 posts - 3,226 through 3,240 (of 6,041 total)