1,253 reputation
635
bio website
location
age
visits member for 1 year, 11 months
seen 1 hour ago
stats profile views 54

Oct
3
asked Is there some drawback to define SPARSE columns?
Sep
30
asked How to get table columns with datatypes (and lengths) using PowerShell?
Sep
20
comment Export data into word documents
@ShawnMelton, yes, you're right, but this question is not about making maintenance plans using SSIS or any other DBA related task.
Sep
20
awarded  Critic
Sep
20
comment Export data into word documents
@ShawnMelton: The name of this forum is Database Administrators. I think that a question is this forum should be something considering database administration. SSIS is pure developmet work.
Sep
19
comment Export data into word documents
I think that this question belongs to StackOverflow...
Sep
18
accepted Why is 'Allow Snapshot Isolation' set to TRUE on the master and msdb databases?
Sep
17
asked Why is 'Allow Snapshot Isolation' set to TRUE on the master and msdb databases?
Sep
14
accepted What's the difference between Linked Server solution and SSIS solution?
Sep
13
asked What's the difference between Linked Server solution and SSIS solution?
Sep
10
accepted Indexing of Data Warehouse tables?
Sep
9
asked Indexing of Data Warehouse tables?
Aug
25
accepted SQL Server: how to avoid sysadmin rights but give adequate rights
Aug
25
comment SQL Server: how to avoid sysadmin rights but give adequate rights
Thanks, it says in BOL: msdn.microsoft.com/en-us/library/ms188659.aspx?ppud=4 that securityadmin should be treated as sysadmin server role. Is there a way to narrow securityadmin rights to logins? Or will that "GRANT ALTER ANY LOGIN to AColleagu" do that?
Aug
25
asked SQL Server: how to avoid sysadmin rights but give adequate rights
Aug
24
accepted SQL Server: what is the reason to favor customized database roles over fixed ones?
Aug
23
asked SQL Server: what is the reason to favor customized database roles over fixed ones?
Aug
23
accepted SQL Server: does ddladmin rights contain datareader and datawriter rights to the database?
Aug
23
asked SQL Server: does ddladmin rights contain datareader and datawriter rights to the database?
Aug
22
accepted Is Oracle more demanding environment for a DBA than SQL Server?