Viewing 15 posts - 1,231 through 1,245 (of 7,168 total)
Personally I would not choose it for new development because I think PowerShell is a better choice, but I don't have a problem with VBS and currently support some of...
April 24, 2013 at 7:55 am
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...
April 24, 2013 at 7:51 am
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...
April 23, 2013 at 6:42 pm
Jeff Moden (4/23/2013)
opc.three (4/23/2013)
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...
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.
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...
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...
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...
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...
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...
April 23, 2013 at 7:07 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...
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...
April 23, 2013 at 6:55 am
Viewing 15 posts - 1,231 through 1,245 (of 7,168 total)