Viewing 15 posts - 2,131 through 2,145 (of 6,041 total)
Kazmerelda (10/25/2016)
Eric, I think you could be right here I am a belt and braces person and I don't overspec...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 25, 2016 at 8:33 am
Jeff Moden (10/23/2016)
The difference between Zombies and Clowns is simple. Zombies are external sources. Clowns are internal. 😉
A disgruntled DBA is the equivalent of a zombie clown with...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 25, 2016 at 8:09 am
Gary Varga (10/25/2016)
Geoff.Sturdy (10/25/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 25, 2016 at 8:06 am
Super_Grover (10/23/2016)
I must transfer a big table (231k rows not that big, but 735GB big because of blob) to another location by INSERT INTO SELECT FROM...
It appears that first...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 25, 2016 at 8:00 am
This is why corporations hire their own staff lawyers and scientists; they don't want to know how best to do things; they just want to know how close to the...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 25, 2016 at 7:49 am
When we speak of no-schema databases and analytical tools, I assume we're referring to a data store essentially intended for staging and exploration. It truly is a bucket of 1s...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 25, 2016 at 7:38 am
I'm not too concerned about how masking or hashing of demographic data in development skews data statistics and performance testing. When coding SQL or designing indexes, it's best not to...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 24, 2016 at 12:58 pm
In addition to using a version control system like Git or TFS, where a copy of working code is committed both locally and on the server, it also helps if...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 24, 2016 at 10:00 am
scarr030 (10/21/2016)
I actually just got promoted to our DBA position, which has been vacant for quite a while. There is very little documentation on our set up and what...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 21, 2016 at 3:11 pm
Ed Wagner (10/21/2016)
Phil Parkin (10/21/2016)
chocthree (10/21/2016)
Ok, here is the deal. I'm a little long in the tooth and have done...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 21, 2016 at 1:20 pm
Yes, checklists are essential for database administrators, and even experienced DBAs are not in the habit.
However, it's not exactly a ground breaking idea.
Brad’s Sure DBA Checklist
https://www.simple-talk.com/sql/database-administration/brads-sure-dba-checklist/
Brent Ozar's SQL Server...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 21, 2016 at 12:39 pm
The next phone I get, I'm just going to snatch one out of the recycle bin at the grocery store. Considering the way so many folks upgrade every time a...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 21, 2016 at 9:12 am
Arriving home around 6pm, after cooking and eating dinner, helping kids with homework, having some one-on-one time with the wife, and then an hour of exercise or household chores, there...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 21, 2016 at 7:45 am
So, you're saying that the users are entering values that are considered invalid due to their excessive length? You can avoid this by implementing check constraints on each of these...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 20, 2016 at 2:53 pm
ZZartin (10/20/2016)
Eric M Russell (10/18/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 20, 2016 at 1:02 pm
Viewing 15 posts - 2,131 through 2,145 (of 6,041 total)