Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Blogs, SQL Server 2005 Rss

   Items 1 to 10 of 10   
 

Vote for Me for a PASS SQLRally Precon on SQL Server Security

Unless James Bond is in the picture, security is usually not a sexy topic. However, we all lament the lack...  Read more...
By 2010/10/28 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,760 reads

For SQL Server 2005/2008, Consider SecurityAdmin = SysAdmin

In a recent thread here on SQL Server Central, it was pointed out that a member of the securityadmin fixed...  Read more...
By Brian Kelley 2010/07/23 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 3,889 reads

A little restriction that prevent changing tables in SQL Server 2008

In SQL Server 2008, by default, the option to prevent tables changes is "on". We can have some issues and...  Read more...
By Dukagjin Maloku 2010/03/24 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 3,202 reads

Why We Recommend Against xp_cmdshell

Every so often I see a post in a forum or on Twitter about the use of xp_cmdshell. Usually it is someone looking for...  Read more...
By 2009/11/19 | Source: SQLServerCentral.com | Category: blogs
Rating:  Rate this |   Briefcase | 6,792 reads

SQL University: Multiple Paths and Ownership Chaining

Welcome back to our last class this term on security in SQL Server here at SQL University. According to the syllabus,...  Read more...
By 2009/11/03 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,601 reads

SQL Server Legend – Data Files and Threads

Someone was asking about using multiple data files recently to try and increase performance. I had answered that unless you...  Read more...
By Steve Jones 2009/10/20 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,940 reads

Issue with SQL Server 2K5 SP3 CU5

In case you are considering to apply SQL Server SP3 CU5 (http://support.microsoft.com/kb/972511) to your system, I'd like to point out one issue / bug we found with CU5.  Read more...
By Jeffrey Yao 2009/09/15 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,465 reads

Scripting in SSIS

Tim Mitchell presented at SQLSaturday #17 on Scripting in SSIS. I thought it was a really interesting presentation, and I’m...  Read more...
By Steve Jones 2009/08/07 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,939 reads

Found a Bug in SQL Server 2005

It doesn’t happen often but every once in a while you may be the lucky person to find a previously unknown bug in SQL Server.  Read more...
By Wesley Brown 2009/06/05 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 3,511 reads

What mechanism allows SQL Server 2008 to commit transactions on the mirror faster than SQL Server 2005?

Question: What mechanism allows SQL Server 2008 to commit transactions on the mirror faster than SQL Server 2005? This question was asked on a technical discussion group. My reply follows.  Read more...
By Robert Davis 2009/05/19 | Source: SQLServerCentral.com | Category: blogs
Rating:  Rate this |   Briefcase | 2,520 reads
   Items 1 to 10 of 10   
 
Tags
sql server 2008 (7)    
sql server (5)    
security (4)    
database security (3)    
sql server 2000 (3)    
sql server 2008 r2 (2)    
sql server architecture (2)    
conferences/user groups (1)    
database mirroring (1)    
integration services (ssis) (1)    
performance tuning (1)    
presenting (1)    
professional development (1)    
professional organization for sql server (1)    
query performance (1)    
replication (1)    
sql university (1)    
sqlsaturday (1)    
tools (1)    
training (1)    
windows security (1)