Viewing 15 posts - 2,851 through 2,865 (of 6,041 total)
When young children are deep into some game or puzzle, they somehow make time slow down, stretching a single rainy afternoon into an eternity. As adults we somehow lose that...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 19, 2016 at 12:45 pm
Practically everyone who has been in the industry for more than a handful of years has found themselves in this position at some point. However, it's important not to get...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 19, 2016 at 7:19 am
Should Production Databases Be in a VCS?
Yes, database administrators should periodically script out the schema for each database and keep it versioned separately under VCS for point in time comparisons,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 18, 2016 at 10:48 am
Alan.B (2/17/2016)
Eric M Russell (2/17/2016)
Local user group meetings offer a similar experience. Also, you can find tons of recorded presentations on sites like YouTube and SQLBits.
+1
There's so much good...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 18, 2016 at 7:39 am
Gary Varga (2/18/2016)
Eric M Russell (2/17/2016)
Gary Varga (2/16/2016)
Eric M Russell (2/16/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 18, 2016 at 7:17 am
The DMV sys.dm_exec_query_stats returns returns an assortment of aggregated measurements for each cached execution plan. The column sql_handle is a unique hash key.
https://msdn.microsoft.com/en-us/library/ms189741(v=sql.110).aspx
It can be joined with sys.dm_exec_sql_text on sql_handle...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 17, 2016 at 3:39 pm
For those who are easily bored and need extra motivation to follow through, a sport like surfing or back country hiking is good exercise; because once you're in, you're deeply...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 17, 2016 at 2:43 pm
I'm not seeing the image.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 17, 2016 at 11:22 am
Yet Another DBA (2/17/2016)
Eric M Russell (2/16/2016)
Dave Convery (2/16/2016)
@Knut BoehnertTo be fair, if the Terminator is doing it's job, you won't know it's here...
It seems we mostly think of AI...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 17, 2016 at 10:38 am
Gary Varga (2/16/2016)
Eric M Russell (2/16/2016)
...attempting to use the developer's code repository as a basis for a schema comparison to production is logistically difficult, if not impossible...
It isn't. It has...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 17, 2016 at 10:29 am
Local user group meetings offer a similar experience. Also, you can find tons of recorded presentations on sites like YouTube and SQLBits.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 17, 2016 at 10:22 am
If I were to add a #12, it would be this:
It is entirely possible to optimize the top 10 worst performing queries and still not address the specific performance...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 17, 2016 at 7:16 am
Versioning database scripts is good. However, attempting to use the developer's code repository as a basis for a schema comparison to production is logistically difficult, if not impossible when each...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 16, 2016 at 12:12 pm
Dave Convery (2/16/2016)
@Knut BoehnertTo be fair, if the Terminator is doing it's job, you won't know it's here...
It seems we mostly think of AI in terms of duplicating or exceeding...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 16, 2016 at 10:17 am
Gary Varga (2/15/2016)
Eric M Russell (2/10/2016)
Matt Miller (#4) (2/9/2016)
Eric M Russell (2/9/2016)
...That's scary, though potentially not a problem. A number of states publish voter data as public records. A few...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 15, 2016 at 9:03 am
Viewing 15 posts - 2,851 through 2,865 (of 6,041 total)