Browse by Tags

Microsoft .NET Framework while trying to load assembly id 65536. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE.
21 September 09 08:20 PM | ssqa.net | with no comments

As it states on the subject line this is an error that would cause when the system is trying to load assembly due to the permissions, the second part of the subject also needs consideration that server may be running out of resources & security issue...

Filed under: sql server, permissions, security, trusted platform, error, achievement, access, external

SQL Server 2008 -Discover how to securely manage your data in a scalable and high performance environment!
31 August 09 04:16 PM | ssqa.net | 1 comment(s)

Do you have any data management strategies within your environment? Would like to be part of a conference that can help build upon the knowledge you already have, as well as demonstrating how to get the best from Microsoft SQL Server for data management...

Filed under: sql server, security, conference, mvp, data file, standard, business intelligence, strategy, data management

Free Microsoft Press eBook offer - Introducing SQL Server 2008
03 June 09 06:03 AM | ssqa.net | 1 comment(s)

Here is the interesting and fantastic news for the SQL Server users, Microsoft Press is offering eBook about "Introducing Microsoft SQL Server 2008" by Industry Experts & SQL Server MVPs - Greg Low, Peter DeBetta & Mark Whitehorn. *...

Filed under: sql server, performance, security, business continuity, ebook, BI, introduction

Address the compliance needs of your environment using SQL Server!
02 June 09 04:49 AM | ssqa.net | with no comments

Common Criteria (CC) Certification is required for any environment and SQL Server is no compromise or exception in this case. I would like to highlight a brief introduction to this requirement (as per my experience), in the recent times many changes to...

Filed under: sql server, security, profile, implementation, compliance, enterprise edition, best practice, solution accelerator, standard, assurance

Microsoft Security Bulletin Summary for July 2008, pay attention this is for SQL Server!
09 July 08 09:17 AM | ssqa.net | with no comments

I believe it has been a while that we have seen the security hotfix from Microsoft Security team on SQL Server (alone). The latest security bulletin has announced important security patches that are related to SQL Server in addition to Windows operating...

Filed under: sql server, security, best practices, service pack, hotfix, gdr, patch, qfe

How to configure SQL Server Reporting Services in a DMZ environment?
22 April 08 07:27 AM | ssqa.net | with no comments

Many questions will come out if you need set your Reporting Server on Internet within DMZ environment? The important aspects involves SQL Server database, Reports Services & Report Manager, for the sake of discussion say if Report Services and Report...

Filed under: sql server, report builder, reporting services, security, best practices, ssrs, tcp, report server, port, udp, 1433

Webcast 31st March 2008: 24 Hours of SQL Server 2008: Ensuring Your Data Is Secure with a Trusted Platform
30 March 08 11:41 AM | ssqa.net | with no comments

Another part of Technet webcast series on SQL Server 2008. In this part a focus on IT professionals and the SQL Server 2008 the Trusted Platform. In the first part of the series we spent time looking at how Contoso was using SQL Server 2008 as a productivity...

Filed under: sql server, 2008, security, technet, trusted platform, data loss, business continuity, high availability, data platform

Pivot table connectivity to SQL Server Analysis Services - security gotchas
14 March 08 06:10 AM | ssqa.net | with no comments

Security permissions in OLAP is similar to normal OLTP based environment. Say if you are using Pivot Table object in MS Office Excel to display the reports using OLAP objects like Cubes. To achieve this it should connect to an OLAP Server and database...

Filed under: sql server, permissions, security, analysis services, ssas, pivot, excel, office, olap

SQL Server 2005 Replication: What are the Schemas and how they are replicated?
15 February 08 09:28 AM | ssqa.net | with no comments

You may be aware SCHEMA carries 2 different meaning within SQL Server 2005 version that were introduced, first one is the definition of an object (object.schema) and next one is owner of an object (user.schema). In the first case replication copies the...

Filed under: sql server, server, users, permissions, replication, object, security, stored procedure, schema

SQL Server Lockdown - Step by Step procedure
13 February 08 11:06 AM | ssqa.net | with no comments

Cross posting from other blog - http://sqlserver-qa.net/blogs/perftune/archive/2008/02/13/3502.aspx fyi. Hope you don't want to do it!

Filed under: blog, sql server, ssqa, security, best practices, lock down, availability