Browse by Tags

All Tags » SQL Server » SQL Server - general   (RSS)
Finding information about which account xp_cmdshell is running as
If you ever needed to debug a permission related issue when using xp_cmdshell, you have probably realized that a crucial piece of information is about what particular account xp_cmdshell is executing under. If you are the administrator of the database, Read More...
Posted 27 October 09 02:24 by lcris | 0 Comments   
Filed under , ,
Some insight information into how SQL Server documentation is prepared
Buck Woody just wrote an interesting post about the process of writing documentation for SQL Server. After reading this, you should have no excuse for not providing feedback on Books Online articles that you feel are incomplete or have inaccurate information Read More...
Posted 14 February 07 02:20 by lcris | 0 Comments   
Filed under ,
Raul starts his blog...
Some of you may already know Raul from the SQL Server Security forums. Raul has just started his blog at http://blogs.msdn.com/raulga/ . His first post provides a detailed discussion of indexing encrypted data: http://blogs.msdn.com/raulga/archive/2006/03/11/549754.aspx Read More...
Posted 13 March 06 02:22 by lcris | 0 Comments   
Filed under , , ,
A couple of links for submitting feedback on Microsoft products
I want to advertise a couple of sites that can be used for submitting feedback and suggestions, or for filing bug reports for Microsoft products. These are: The Microsoft Technical Forums at: http://forums.microsoft.com/MSDN/ . The SQL Server Forums are Read More...
Posted 01 December 05 02:32 by lcris | 2 Comments   
Filed under ,
A new blog link
Here's a link to a new blog that a colleague has started: http://blogs.msdn.com/yukondoit/ . The first entry is about the various levels of data protection in SQL Server 2005 and you can access it at: http://blogs.msdn.com/yukondoit/articles/480854.aspx Read More...
Posted 13 October 05 05:15 by lcris | 0 Comments   
Filed under , ,
SQL Server 2005: How to fix outdated names of Windows logins
The SQL Server login catalogs store the names of Windows principals as well as their SIDs. Because the names are stored, changes that affect a name can lead to a state where a catalog entry is out of sync with the current login name. For example, in the Read More...
Posted 27 September 05 10:34 by lcris | 0 Comments   
Filed under ,
SQL Server 2005: An example of writing a CLR function that wraps the LookupAccountSid WinAPI call
I was looking recently into writing a wrapper for the LookupAccountSid WinAPI function, so that I could use this functionality in T-SQL. I decided to write a CLR function and document the steps here: 1. First, we need to write the code into a file - I Read More...
Posted 26 September 05 03:51 by lcris | 1 Comments   
Filed under ,
An example for setting database mirroring in SQL Server 2005
I am not a database mirroring expert, but a while ago I have set up database mirroring between two of my machines. I collected the steps that I followed in the following script: -- This script illustrates how to setup database mirroring between two machines. Read More...
Posted 14 September 05 10:45 by lcris | 2 Comments   
Filed under ,

Search

This Blog

These posts are provided "AS IS" with no warranties, and confer no rights.

Syndication

Page view tracker