Search results for 'app:weblogs' matching tags 'SQL Server' and 'security'

Master SQL Chef series: Designing automated administration #sql #sql2k8r2cookbook

Anonymous — Wed, 04 Jan 2012 06:00:00 GMT

The administrative tasks such as managing backups, jobs, alerts and database maintenance activites are essential for every DBA. The tasks will be more complex and larger when the data platform is spread across the Enterprise, key task is to be able to automate the routine tasks and develop proactive maintenance to ensure that data availability and integrity is maintained without any interruption. The management of automated processes is a different topic and in order to accomplish part of the task...(read more)

SQL Server Performance series: Trace Flag 845 and Lock Pages in Memory

Anonymous — Fri, 25 Nov 2011 06:00:00 GMT

A discussion about trace flags 845 lead to explain the information about the requirement and necessity in case of 32 bit and 64 bit environments. The Lock Pages in Memory has gained importance since version 2005 due to the fact that 32-bit and 64-bit environments are managed. As you may be aware it was only available in Enterprise and Developer editions, since CU4 for SQL Server 2005 SP3 and CU2 for SQL Server 2008 SP1 it is enabled as a trace flag 845 for Standard Edition environment too. Lock Pages...(read more)

SSIS restart issues, message: application-specific permission settings do not grant Local Launch permission for the COM Server application with CLSID

Anonymous — Tue, 11 Oct 2011 05:00:00 GMT

SQL Server Integration Services (SSIS) is an important service that is required to continue the ETL (extract transform load) tasks on your data platform. You may notice that since SQL Server 2005 version onwards the database maintenance plans will always use SSIS packages to perform the key maintenance activities. Though SSIS service is not imporant here but it is ideal to continue the key ETL activities using SSIS packages than TSQL methods. Just going back to basics running SSIS provides many capabilities...(read more)

Cumulative Update Package1 for SQL Server 2008 R2 Service Pack 1 envrionmet

Anonymous — Wed, 17 Aug 2011 05:00:00 GMT

If you have applied the SQL Server 2008 R2 Service Pack1 then here is the news to test and apply Cumulative Update package 1 information. As per the KBA 2567714 : A supported cumulative update package is now available from Microsoft. However, it is intended to correct only the problems that are described in this article. Apply it only to systems that are experiencing these specific problems. This cumulative update package may receive additional testing. Therefore, if you are not severely affected...(read more)

SQL Server BI: secure the Analysis Services instance and few best practice gotchas #sql #sqlBI

Anonymous — Wed, 20 Jul 2011 05:00:00 GMT

When it comes to security the Business Intelligence systems are also key parts of your data platform. In terms of securing SQL Server Analysis Services instance means there are certain Analysis Services configuration properties that you can set using the Management Studio. Similar to the core relational engine SQL Server 2008 Analysis Services also provide the deployment and configuration options that can be tailored based on each application security requirements. When it comes to Security the Policy-based...(read more)

SQL Server service account permissions and gotchas #sql #bpa #sqlservice

Anonymous — Fri, 13 May 2011 05:00:00 GMT

The number of services related to SQL Server has been doubled since SQL Server 2005 is released and 2008 R2 version has got few more to watch. The various services that are required/related to SQL Server are as follow and each of them will run as a seperate service that require relevant permissions to manage authentication of SQL Server operations with Windows operating system. The services and components will vary if you decide to install selective services, SQL Server seteup will allow the following...(read more)

SQL Server DBA Manageability practices: Central Management Servers - how best you want to utilize them?

Anonymous — Wed, 04 May 2011 05:00:00 GMT

SQL Server 2008 version added a new face within SQL Server Management Studio that can help users to administer/manage/execute queries against multiple servers by designating Central Management Servers (CMS) and creating server groups. This means as an user you need not to enter login/password details whenever connecting to a server instance that is registered under CMS, as it maintains the server groups which maintain such connection information for registered servers. Not just executing multiple...(read more)

SQL Server agent: Property pagersendsubjectonly is not available for alert system this property may not exist for this object or may not be retrievable due to insufficient access rights.

Anonymous — Wed, 05 Jan 2011 06:00:00 GMT

Do you see this error in your environment? Is it a frequently occuring issue? In the recent time in a 64 bit environment we started to get this alert generated and DBAs complaining sometimes are unable to view the SQLAgent jobs on that remote server. If we observe the error text it clearly states " ....this property may not exist for this object or may not be retrievable due to insufficient access rights ". The first part is property may not exist for this object which means a tools problem and to...(read more)

SQL Server discovery: How to find edition of SQL Server without connecting to that instance?

Anonymous — Wed, 29 Dec 2010 06:00:00 GMT

This is an interesting question in the recent times that I have seen in the forums, that how to find such information even without connecting to that SQL instance. There are plenty of ways to get information about SQL instance name using OSQL -L or find about odbc32.dll to get list of SQL names if they are registered. Also the local instance is resolved by registry entry and remote instances are resolved by UDP broadcast (port 1434), using sqlbrowser -c can help some extent to obtain the information....(read more)

SQL Server 2008 R2 installation and move system databases vows - error 5120, 17204, 5015 and 945

Anonymous — Thu, 23 Dec 2010 06:00:00 GMT

SQL Server 2008 onwards the setup process has been so easy and straight-forward to follow, the installation part was easy and I hit the road-block when the system database were moved from the original location. The installtion will go thru the steps such as: review installation requirements, system configuration checks, and security considerations for a SQL Server installation. By using the SQL Server installation center we can proceed to run SQL Server Setup to install or upgrade to a later version....(read more)