Viewing 15 posts - 2,251 through 2,265 (of 6,041 total)
Luis Cazares (9/20/2016)
Eric M Russell (9/20/2016)
Luis Cazares (9/20/2016)
Here's an alternative that doesn't rely on undocumented procedures....
Yeah, but Microsoft doesn't officially support your method either. :satisfied:
Doesn't support or doesn't have...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 20, 2016 at 2:43 pm
Luis Cazares (9/20/2016)
Here's an alternative that doesn't rely on undocumented procedures....
Yeah, but Microsoft doesn't officially support your method either. :satisfied:
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 20, 2016 at 2:05 pm
Whenever a process (whether it be a bulk insert, select, create index, or whatever) occasionally requires significantly longer duration to complete, it's usually due to blocking. When CREATE INDEX is...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 20, 2016 at 1:04 pm
Provide examples of the most problematic values you're trying to convert.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 20, 2016 at 11:47 am
For this, you can leverage sp_MsForEachDB. It will execute the specified batch of T-SQL across all databases. For each iteration, the token ? will be dynamically substituted with the database...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 20, 2016 at 11:32 am
I know what you're talking about. If you have a stored procedure that accepts multiple parameters for performing searches (it seems every CRM type application has one), then dynamic SQL...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 20, 2016 at 10:43 am
Mike Scalise (9/20/2016)
I tried to search for this but I haven't seen the question asked explicitly--and that may be because it's kind of dumb, but I'm interested in knowing the...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 20, 2016 at 8:25 am
Hopefully a job offer looking for a 10x DBA won't land you sitting alone in a server room with 9 empty chairs. :ermm:
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 20, 2016 at 7:58 am
Hopefully none of is have printed reports in our desk drawers containing personal information about customers. :ermm:
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 20, 2016 at 7:48 am
Case in point:
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 20, 2016 at 7:21 am
Essentially, DBA stands for "database administrator". If the organization has solutions deployed on SSIS, SSAS, or SSRS, then at the very least you'll be expected to manage those products on...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 19, 2016 at 3:39 pm
Steve Jones - SSC Editor (9/19/2016)
Eric M Russell (9/19/2016)
At least based on news reports...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 19, 2016 at 10:33 am
If using MS Access as the database, then you can improve security by implementing something like a web services based data access layer. Specifically, the service account that the web...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 19, 2016 at 9:06 am
By default, only a member of SYSADMIN can execute xp_cmdshell when enabled. If your developers and application users are members of SYSADMIN, they can simply enable xp_cmdshell themselves... and then...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 19, 2016 at 8:38 am
Most RDMS are air-tight from external hacking attempts when the DBA properly implements authentication and authorization.
At least based on news reports (and subsequent technical analysis by the industry), I'm...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 19, 2016 at 8:32 am
Viewing 15 posts - 2,251 through 2,265 (of 6,041 total)