Viewing 15 posts - 3,226 through 3,240 (of 6,035 total)
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...
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”)
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,...
October 26, 2015 at 2:14 pm
Eric M Russell (10/26/2015)
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...
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...
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,...
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...
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...
October 26, 2015 at 7:37 am
..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, and, of course, Data...
October 26, 2015 at 7:20 am
Wayne West (10/23/2015)
October 23, 2015 at 2:18 pm
My database server has the new omnistate Solipsistic CPU which insures all bits assume the ideal value desired by each observer at all times.
October 23, 2015 at 1:47 pm
below86 (10/23/2015)
It's probably just me but the...
October 23, 2015 at 1:08 pm
I prefer to use [IsntInactive] where a code of 100 - 255 indicates various reasons for it's non inactivity, codes <= 99 indicate inactivity, and 0 means not specified.
😉
October 23, 2015 at 11:49 am
Rod at work (10/23/2015)
October 23, 2015 at 9:47 am
Viewing 15 posts - 3,226 through 3,240 (of 6,035 total)