Viewing 15 posts - 3,121 through 3,135 (of 6,041 total)
A quick Google search for (+"SQL SERVER" +SSDT +PowerShell + Automation) did not turn up anything useful except for answered inquiries in Microsoft forums stating that it's not supported at...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 18, 2015 at 6:53 am
The data comparison feature you're using in Visual Studio; is that the same thing as the SQL Server Data Tools plugin? I've found an MSDN article which seems to suggest...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 17, 2015 at 10:45 am
ZZartin (12/17/2015)
Eric M Russell (12/17/2015)
Sean Redmond (12/17/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 17, 2015 at 7:55 am
Back in the late 1980's, I worked for a retailer that would require the customer to show their drivers license whenever they presented a credit card or check. If the...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 17, 2015 at 7:30 am
Sean Redmond (12/17/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 17, 2015 at 7:11 am
Using a technique similar to what I've done below, you can exit the main procedure should the elapsed runtime of a sub-procedure call exceed a specific duration. You'll want the...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 17, 2015 at 7:01 am
You can check the application's .config file, but to know for sure what database servers are accessed by the application, you can query the Default Trace on each instance, filtering...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 16, 2015 at 1:35 pm
Also, confirm if SSIS / SSRS / SSAS or something like an AntiVirus service may be running on the box alongside SQL Server. Except for a high volume OLTP database,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 16, 2015 at 11:58 am
Beatrix Kiddo (12/16/2015)
Yet Another DBA (12/15/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 16, 2015 at 11:05 am
What you're currently doing uses a fixed set of comparison values with dynamic SQL. But what you really need is a fixed SQL statement supporting a dynamic set of values....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 16, 2015 at 8:47 am
Don't stop/restart the SQL Server service or you will lose cached diagnostic metrics which is essential for diagnosing this type of issue using DMV queries.
This step is optional, but if...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 16, 2015 at 6:57 am
Jeff Moden (12/15/2015)
larskandersen (12/15/2015)
This pattern can be replaced with a single “Upsert” on the source and destination table. I find...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 15, 2015 at 3:09 pm
jeffrey yao (12/15/2015)
Steve Jones - SSC Editor (12/15/2015)
Yet Another DBA (12/15/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 15, 2015 at 2:54 pm
Kimball recommends that facts of different grain, like event level facts rolled up to month level, should be contained in a separate fact table. But it seems this month rollup...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 15, 2015 at 9:13 am
The best tool for identifying and protecting PHI is a comprehensive and accurate Data Dictionary. For example, both an automated tool and a developer can easily overlook the fact that...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 15, 2015 at 8:48 am
Viewing 15 posts - 3,121 through 3,135 (of 6,041 total)