Viewing 15 posts - 1,231 through 1,245 (of 7,164 total)
Xp_cmdshell does not maintain a users identity all the way through the stack, which impedes auditing and allows for obfuscation of the identity of the person running the command.
Once you...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 24, 2013 at 7:51 am
Impasse
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 23, 2013 at 6:52 pm
The point is, using xp_cmdshell limits your options. It paints you into a corner. PowerShell has 100% functionality coverage, and infinitely more, over CmdShell. And when run separate from SQL...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 23, 2013 at 6:42 pm
Jeff Moden (4/23/2013)
opc.three (4/23/2013)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 23, 2013 at 5:19 pm
I think if you install a copy of SQL Server Data Tools on top of either VS 2010 or VS 2012 you now get the SQLCLR project types for free...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 23, 2013 at 12:22 pm
SQL Show (4/23/2013)
along with AWE, you have to use PAE in boot.ini to reveal physical ram more than 16gb.
PAE is not a valid boot.ini configuration on 64-bit OSes.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 23, 2013 at 11:20 am
Should be. All the classes used in the code in the thread I linked to are in the .NET 2.0 Framework which is used by both the SQL 2005 and...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 23, 2013 at 10:16 am
I agree with SQLBob in that I would never want to work for that person. Maybe someone can get this thread under their nose...maybe they'll listen to a chorus.
If I...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 23, 2013 at 7:43 am
Technically you do not need a SQL instance at all to evaluate policies. I have my policies stored as XML files on disk and evaluate them against the instances in...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 23, 2013 at 7:35 am
Just in case, because the article is not very clear on this point, if you enable AWE in the SQL Server instance you should absolutely set max server memory using...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 23, 2013 at 7:32 am
My understanding on CONTEXT_INFO is that of a "session variable". If you set it somewhere then all other objects in that session can see the value. If a called object...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 23, 2013 at 7:07 am
A SQLCLR object might be a better option here: http://www.sqlservercentral.com/Forums/Topic1406771-386-1.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 23, 2013 at 7:02 am
sp_WhoIsActive is a great tool for seeing what is happening at a particular moment. You can also have it capture its results to a table and schedule it which is...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 23, 2013 at 6:59 am
If you ever find yourself needing to implement functionality that crosses the OS/SQL Server gap then PowerShell can fill that need quite nicely for you. PowerShell is also very good...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 23, 2013 at 6:55 am
prashanthreddymr (4/17/2013)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 23, 2013 at 6:50 am
Viewing 15 posts - 1,231 through 1,245 (of 7,164 total)