Other SQL Server Blogs around the Web

Browse by Tags

• 2005
• account
• agent
• alter authorisation
• audit
• best practices
• bol
• data sources
• dba
• dmv
• error
• etl
• grant
• import
• integration services
• kba
• log file
• management
• metadata
• migration assistant
• named pipes
• newbie
• object
• operation system
• oracle
• performance
• permission
• principal
• privileges
• proxy
• read
• remote
• resolution
• sa
• schemas
• security
• sql express
• sql server
• ssis
• ssms
• sys.dm
• sysbase
• system
• system administrator
• tcp
• third party
• tools
• transaction log
• tsql
• tutorial
• users
• version
• view
• violation

• SQL Server Migration Assistant tools from other data sources - 2005 & 2008 versions

  From the blog of Technical Rollup mail that we receive from Microsoft here is the list of SQL Server Migration Assistant tools available from Microsoft to migrate/upgrade data from other data sources such as Access, Sybase & Oracle. _________________________________________________________________________________________________________________________... Posted Aug 04 2008, 07:58 AM by SSQA.net Filed under: sql server, access, version, oracle, data sources, migration assistant, sysbase

• SQL Server 2005 unable to drop schema error: Cannot drop schema <> because it is being referenced by object

  Recently I have received an email about unable to drop schemas that are adopted in the database design within an environment, here it goes. I'm setting up an automatic build process that also includes building one or more databases. Initially it was... Posted Apr 22 2008, 03:01 AM by SSQA.net Filed under: sql server, tsql, access, 2005, best practices, object, schemas, alter authorisation

• SQL Server 2005 ETL process - made simple and easy to learn with SSIS tutorials

  Still most of the users in SQL Server 2005 are afraid of using SSIS - SQL Server Integration Services for their ETL process and procedures. I would say the newbie users are in luck to obtain help easily on the web by referring to the blogs and forums... Posted Nov 05 2007, 09:47 AM by SSQA.net Filed under: sql server, ssis, bol, users, access, 2005, tutorial, import, integration services, newbie, etl

• How to make unwanted access to SQL Server 2005 by an operating system administrator more difficult

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications... Posted Oct 12 2007, 05:55 AM by SSQA.net Filed under: sql server, security, access, kba, sa, operation system, system administrator

• How to read Database transaction log in SQL Server?

  Another frequently asked questions in the forums and newsgroups, I have seen similar ones recently. I believe most of the newbie users ask this question and even more as interview based questions. So here is the catch in order to accomplish the task,... Posted Sep 27 2007, 07:13 PM by SSQA.net Filed under: sql server, ssms, dba, log file, access, audit, transaction log, third party, tools, resolution, read

• FIX: A SQL Server Agent job fails when you run the SQL Server Agent job in the context of a proxy account in SQL Server 2005

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX: A SQL Server Agent job fails when you... Posted Aug 22 2007, 02:04 PM by SSQA.net Filed under: sql server, access, kba, agent, proxy, account

• 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... Posted Aug 17 2007, 05:45 AM by SSQA.net Filed under: sql server, performance, tsql, access, system, permission, grant

• FIX: An access violation may occur, and you may receive an error message, when you query the sys.dm_exe_sessions dynamic management view in SQL Server 2005

  Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX: An access violation may occur, and you may receive an error message, when you query... Posted Aug 14 2007, 11:53 AM by SSQA.net Filed under: dmv, sql server, access, kba, sys.dm, violation

• Control metada visibility using few 'simple' statements

  You may be aware that a user in a SQL Server 2005 database can only see metadata that the user either owns or on which the user has been granted some permission. A default policy enhanced as compared to how a DBA can control the security access to the... Posted Aug 09 2007, 05:03 AM by SSQA.net Filed under: security, tsql, view, principal, metadata, privileges, access

• 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... Posted Jul 26 2007, 07:49 AM by SSQA.net Filed under: sql server, performance, ssms, security, management, error, access, tcp, sql express, named pipes, remote