Browse Site by Tags

All Tags » Access » SQL Server » performance (RSS)

Showing related tags and posts across the entire site.

.NET
Access
Active Directory
Administration
Advisories
Advisories / Bulletins
Alerts
ANNOUNCEMENTS
Architecture
ASP.NET
Best Practices
Books
C#
Community
ConfigMgr 2007
Cool reading
CSharp
Desarrollo de Software
Development
Digital Media
Downloads
Events
Exchange
Exchange Server 2007
Flight Simulator
FSX
General
General Security
General Security News
Hardware
Humor
hyper-v
Informations
Internet Explorer
Internet Explorer 7
javascript
kba
LINQ
Malware Removal Guide
Me
Media Center
Microsoft
Miscellaneous
mms
MOSS2007
MSDN
MVP
myITforum.com
News
Office
OpsMgr 2007
performance
Personal
PowerShell
PowerShell and WMI
PowerShell V2
Products
Rants
Sécurité
safety and privacy on the Internet
SBS
sbs 2008
SBS Blog
Security
Security, safety and privacy on the Internet
Server
Sharepoint
Silverlight
Small Business Server
Software
SPPS03_Tips
SQL Server
System Center
SystemCenter
TechNet
Technical Tips
Technology
Tips
Tools
Trivia
Updates
VB
virtualization
viruses and exploits
Vista
Visual Studio
VSTS
Vulnerabilities
Vulnerabilities, viruses and exploits
WCF
windows
Windows 7
Windows 8
Windows Mobile
Windows OS
Windows Server
Windows Server 2008
Windows Vista
WPF
XP

TSQL to generate GRANT statements from a database

select p . state_desc + ' ' + p . permission_name + ' OBJECT::' + s . name collate Latin1_general_CI_AS + o . name collate Latin1_general_CI_AS + ' TO ' + u . name collate Latin1_general_CI_AS + 'GO' , p .* from sys.database_permissions p inner join sys.objects o on p...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on Fri, Aug 17 2007
Filed under: sql server, performance, access, permission, system, tsql, grant
An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes ....)

Error: An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes Provider,error:40-Could not open connection to SQL Server...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on Thu, Jul 26 2007
Filed under: sql server, performance, management, security, ssms, error, access, sql express, tcp, named pipes, remote
Restrict Access to SQL Server using "Certificates"

Within SQL Server 2005 you could take help of certificates to restrict the access from a particular client's machine. Few times (even me) confused with or get an impression that SSL encryption is same, for more information on SSL( Secure Sockets Layer) refer to KBA316898 in this case. There is much...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on Mon, Jul 2 2007
Filed under: sql server, performance, databases, security, access, encryption, certificate
How SQL Server 2008 can help to build fast track data warehouse?

Beginning of this year I have posted here about Build your BI skills in fast track data warehouse and based on that I have had few questions and feedback on how best we can take help of SQL Server 2008 features to build the fast track data warehouse. Based on the material and resources available on Microsoft...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on Fri, Oct 9 2009
Filed under: sql server, performance, memory, attributes, access, disk, cpu, data warehouse, fast track
SQL Server SSIS package performance series - resolve the low-memory conditions

SSIS Packages are integral part of database management activities, that all ETL based activities can be managed efficiently. The primary usage for these packages is to manage the movement of data from one place to another. To do that, the package needs to know where it is moving data from and where it...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on Wed, Apr 21 2010
Filed under: sql server, package, perfmon, performance, ssis, ssas, access, best practices, benchmarking, low memory

Page 1 of 1 (5 items)

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.

Browse Site by Tags

TSQL to generate GRANT statements from a database

An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes ....)

Restrict Access to SQL Server using "Certificates"

How SQL Server 2008 can help to build fast track data warehouse?

SQL Server SSIS package performance series - resolve the low-memory conditions