Browse by Tags

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