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

Content with tags SQL Server 2008, Blogs Rss

   Items 1 to 12 of 12   
 

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,836 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,967 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,246 reads

Scripting database objects in SQL Server 2008

In this article, we would go through the steps to script the objects in a database using SQL Server 2008....  Read more...
By Bru Medishetty 2010/03/18 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,155 reads

IntelliSense Slow to Refresh

IntelliSense in SQL Server 2008 can sometimes not be very intelligent.  It’s there to help you can sometimes cause more...  Read more...
By Devin Knight 2010/03/01 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 3,096 reads

Little info about Resouce DB (SQL Server 2008-2005)

Little info about System Resource Database in (SQL Server 2008/2005) The fifth system database in both versions (SQL Server 2008 - 2005)...  Read more...
By Dukagjin Maloku 2009/12/29 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,665 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,846 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,636 reads

Decompressing on Compression in SQL Server 2008....

Compression is one of the major features introduced in SQL Server 2008, and one that can significantly reduce disk storage. ...  Read more...
By Robert Pearl 2009/09/02 | Source: SQLServerCentral.com | Category: blogs
Rating:  Rate this |   Briefcase | 2,084 reads

Analysis Services Memory Limits

I attended a presentation recently from Steven Wright of SQL Sentry on Analysis Services (SSAS) memory management and it was...  Read more...
By Steve Jones 2009/09/01 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,818 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,975 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,547 reads
   Items 1 to 12 of 12   
 
Tags
sql server 2005 (7)    
security (4)    
sql server (4)    
database security (3)    
sql server 2000 (3)    
sql server 2008 r2 (2)    
sql server architecture (2)    
analysis services (ssas) (1)    
backup / restore (1)    
compression (1)    
conferences/user groups (1)    
data (1)    
database mirroring (1)    
integration services (ssis) (1)    
presenting (1)    
professional development (1)    
professional organization for sql server (1)    
sql university (1)    
sqlsaturday (1)    
tips (1)    
tools (1)    
training (1)    
windows security (1)