Reputation
440
Top tag
Next privilege 500 Rep.
Access review queues
Badges
5 18
Newest
 Tumbleweed
Impact
~32k people reached

  • 0 posts edited
  • 3 helpful flags
  • 28 votes cast
Apr
8
awarded  Tumbleweed
Apr
1
asked SSIS Export to flat file with fixed column widths - add record with a different format?
Mar
13
comment Security for SSIS packages in SQL Server - use a domain account?
Ideally, I am thinking a non-expiring service account on the domain would work. If I just have "Windows Authentication" selected on the connection managers in the package, when it runs in a job, it runs completely under the context of the SQL Server Agent account, not my account, right? If I create a service account that can access Server B, and then set up an SSIS proxy with a credential on Server A, would that keep everything running under the service account?
Mar
12
asked Security for SSIS packages in SQL Server - use a domain account?
Mar
12
awarded  Popular Question
Feb
24
awarded  Popular Question
Dec
31
awarded  Yearling
Dec
8
awarded  Notable Question
Nov
24
asked How to maintain database ownership restoring across domains?
Oct
12
awarded  Popular Question
Sep
24
awarded  Autobiographer
Jul
3
comment When should I NOT set the Maximum Server Memory option in SQL Server?
I have also seen Jonathan's recommendations, among others. The problem is that they account for only the SQL Server engine running on the server, and not SSIS, SSAS, etc.
Jul
3
asked When should I NOT set the Maximum Server Memory option in SQL Server?
Jul
2
awarded  Curious
Jun
25
awarded  Popular Question
Jun
17
comment TempDB data files don't shrink well on SQL 2008
I had a similar problem. TempDB wouldn't shrink no matter what until I ran a few steps as seen here: calyansql.blogspot.com/2012/04/…
May
22
comment Why is this query stuck if there are no waits?
@AaronBertrand There are actually many tables, most with constraints, so it's not as simple as a delete query unfortunately.
May
22
comment Why is this query stuck if there are no waits?
@AaronBertrand That does seem to defeat the point of batching, but the utility provides no options other than "GO".
May
21
asked Why is this query stuck if there are no waits?
May
14
accepted Changing the SQL Server service account - any additional considerations?