External News

Browse by Tags

• ACL
• Alerting
• Audit
• Auditing
• Beta
• Business up front
• ccr
• Cloud computing
• Command Shell
• configuration
• Debug
• Design
• Disaster Recovery
• error
• Exchange Server 2007
• Forest
• Ghetto scripting
• Hotfix
• Identity Lifecycle Manager
• Internet
• ITPro
• malware
• Management
• Metrics
• MOM
• Network
• Off-Topic
• Overview
• PBM
• performance
• permission
• Report
• routing
• scheduler
• SCOM
• scr
• Scripts
• Security
• SQL 2008
• SRRs
• standard
• STIG
• Storage
• token
• tool
• topologies
• tutorial
• UAC
• VBS
• Vista
• Vista and Lognhorn
• Webcasts
• Windows
• Windows 2008
• Windows 7
• Windows Intune
• Windows Server 2008
• XP

• Changing Domains on a SQL Server

  Someone recently asked me what issues might arise when changing a server's domain and the server is running SQL Server. Here are the possible issues I'm aware of as far as SQL Server is concerned: 1. SQL Server SysAdmin (SA) Access. The most important... Posted Apr 02 2011, 10:29 AM by TechNet Blogs Filed under: configuration, Admin, STIG

• Do You Need MSDTC?

  STIG requirement DG0016 specifies that you should not install any service you do not need, and if one is automatically installed and cannot be removed, it should be disabled. The Microsoft Distributed Transaction Coordinator (MSDTC) is a Windows service... Posted Mar 09 2011, 08:52 PM by TechNet Blogs Filed under: configuration, Admin, STIG

• The Easiest Way To Rebuild The master Database

  If your SQL Server master database becomes corrupt, such as from its disks losing power while SQL Server was running, the conventional advice is to rebuild the master database, start SQL Server, then restore the backup of the master database. That's... Posted Feb 01 2011, 06:45 AM by TechNet Blogs Filed under: error, Admin

• File-Sizing

  One of the primary areas of responsibility for DBA's is maintenance, and one of the primary maintenance tasks is file-size management. First I'll present a list of the file-sizing tasks with short explanations for each one, then some background... Posted Nov 06 2010, 04:52 PM by TechNet Blogs Filed under: configuration, performance, Admin, Scripts, Alerting, PBM

• Failover Cluster Concepts

  This post is primarily an online note for myself, which I'll make public in case someone else might find it helpful: Windows Failover Cluster Concepts Node: A server (physical or virtual) Cluster: A set of one or more nodes Group: a set of resources... Posted Oct 18 2010, 10:00 AM by TechNet Blogs Filed under: Off-Topic, Admin

• Windows Intune, tuning the IT

  Today I had a short training on the cloud solutions and the impact Microsoft will have in IT Organizations in the future. I was very impressed by BPOS (Business Productivity Online Suite), which I’ll be talking about later on, and Windows Intune. Intune... Posted Sep 15 2010, 10:18 AM by TechNet Blogs Filed under: Windows, malware, Beta, Admin, Overview, Cloud computing, tutorial, ITPro, Windows Intune

• Defragmenting Indexes

  Maintaining indexes is a primary duty of Database Administrators, because appropriate indexes are critical to maintaining high performance in any relational database, and proper maintenance is required to avoid excessive fragmentation. In case that's... Posted Aug 31 2010, 08:15 PM by TechNet Blogs Filed under: performance, Admin, Scripts

• USER Account Control… but I’m an ADMIN!

  User Account Control (UAC) has now been with us for almost 4 years, and still it is a mystery to a lot of people – what it does, why it does it and what value it adds… so I shall try to shed some light on this for those that want “complete control” of... Posted Aug 06 2010, 02:44 AM by TechNet Blogs Filed under: UAC, ACL, Admin, standard, permission, token

• Connection Error After Removing Public Permissions

  One of the requirements for STIGging an instance of SQL Server (or applying other enterprise security standards) is to remove all permissions from SQL Server's "public" role. Incidentally, SQL Server 2008 has far fewer permissions assigned... Posted Jul 06 2010, 12:18 PM by TechNet Blogs Filed under: configuration, Admin, STIG

• Agent Schedules

  The SQL Server Management Studio has a "Job Activity Monitor" which provides a lot of useful information about scheduled jobs. However, it does not show the schedule type or a schedule description, nor does it clearly distinguish between the... Posted Jun 28 2010, 09:25 AM by TechNet Blogs Filed under: Admin, Scripts

• Katalog služby Microsoft Update

  Katalog služby Microsoft Update poslouží, pokud hledáte aktualizace pro vybrané verze operačních systémů Windows nebo serverové produkty a nemůžete použít automatickou aktualizaci, protože cílový server není připojen k internetu a nepoužíváte ani... Posted May 21 2010, 04:18 AM by TechNet Blogs Filed under: Security, Hotfix, tool, Admin

• Flash Player - Global Privacy Settings Panel (opravdu chcete tyto dobroty?)

  Spousta webových stránek využívá Flash Player pro zobrazení aktivního, dynamického obsahu. Dva články na stránkách TechRepublic mne zaujaly a donutily mne zamyslet se nad konfigurací Flash Playeru v mém počítači. Budete se také možná divit, jaké stránky... Posted May 20 2010, 10:00 PM by TechNet Blogs Filed under: Security, Internet, Admin

• Kde je uložena konfigurace Subscriber (SCOM 2007)

  Stál jsem před úkolem, jak získat informace o definicích uživatelů notifikačních kanálů z databáze OperationsManager . Tedy Subscriber či Recipient . Informace jsou zde ve formě definice XML v MP: Microsoft.SystemCenter.Notifications.Internal Z databáze... Posted May 20 2010, 06:58 AM by TechNet Blogs Filed under: SCOM, Command Shell, Admin

• SCOM 2007 R2 Cumulative Update 2

  Kumulativní aktualizace je od 30.4.2010 na světě. Zahrnuje také předchozí aktualizace, obsažené v  CU 1. Pokud jste tedy CU 1 dosud neaplikovali, neváhejte, CU2 je tu pro Vás! System Center Operations Manager 2007 R2 Cumulative Update 2 Release Notes... Posted May 11 2010, 01:43 AM by TechNet Blogs Filed under: Hotfix, SCOM, Admin

• Doporučení pro velikosti databází pro SCOM 2007

  Výpočet – lépe řečeno odhad velikosti jednotlivých databází závisí na počtu sledovaných serverů, skladbě pravidel a monitorů a nastavení auditní politiky. Dobré a bezpečné výsledky dává Operations Manager 2007 R2 - Sizing Helper , který vypracovala produkční... Posted Apr 22 2010, 02:15 PM by TechNet Blogs Filed under: Design, SCOM, Admin, Audit

• Security Compliance Manager—Now Available for Download!

  Aktualizovaná verze je dostupná na stránkách Technet Microsoftu . Zahrnuje tedy pochopitelně Windows 7 a Server 2008. Key Features & Benefits Centralized Management and Baseline Portfolio: The centralized management console of the Microsoft Security... Posted Apr 08 2010, 06:18 AM by TechNet Blogs Filed under: Security, Windows 2008, tool, Admin, Windows 7

• Časté dotazy zájemců o System Center Operations Manager

  Aktuální verze je nyní SCOM 2007 R2, aktualizace Cumulative Update 1 (popisuje Pavel Řepa zde ). Občas musím vysvětlovat některé dotazy, které vás mohou také napadnout, pokud ještě nepracujete se systémem SCOM. Pro zjednodušení zde většinu těchto otázek... Posted Mar 29 2010, 03:42 PM by TechNet Blogs Filed under: Design, SCOM, Admin, Audit

• Public Not Granted Server Permissions

  The pre-defined policies that come with SQL Server 2008 include one called "Public Not Granted Server Permissions". Running this policy in evaluation mode on a default installation will show a non-compliance failure due to 5 server-level permissions... Posted Mar 19 2010, 04:02 PM by TechNet Blogs Filed under: Admin, Scripts, Auditing, STIG, PBM

• DG0116 and DG0121: DBA Privileges Via Roles

  The generic DoD database STIG requirement DG0116 states that the Information Assurance Officer (IAO) will ensure database privileged role assignments are restricted to IAO-authorized accounts, and DG0121 states that the DBA will ensure database privileges... Posted Feb 16 2010, 06:12 PM by TechNet Blogs Filed under: configuration, error, Admin, STIG

• Remove Public and Guest Permissions

  You can't get rid of the "public" role and by default in SQL Server 2005 and 2008 most objects have permissions granted to public. For those reasons, you might expect that those permissions are required for SQL Server to function correctly... Posted Feb 04 2010, 02:59 PM by TechNet Blogs Filed under: configuration, Admin, Scripts, SRRs, STIG

• Installing Reporting Services 2008

  If you need to install SQL Server Reporting Services 2008 in a domain where some of the adminsitrative privileges of the local administrator account have been removed, you may want to check 3 particular permissions, listed just below. If you've already... Posted Dec 17 2009, 03:44 PM by TechNet Blogs Filed under: Debug, Admin

• Paměťové limity ve Windows

  Užitečný přehled pro různé verze a vydání Windows od Windows 2000 po Windows 7 / 2008 R2 je na stránkách MSDN : Memory Limits for Windows Releases: http://msdn.microsoft.com/en-us/library/aa366778(VS.85).aspx Značky Technorati: Windows Memory Limits.... Posted Dec 11 2009, 02:50 AM by TechNet Blogs Filed under: Design, Admin

• Whoami ?

  Nezapomínejme na jednoduché nástroje příkazové řádky! Kdysi velmi primitivní příkaz WHOAMI se ve Windows 7 vypracoval na užitečného pomocníka. Oceňuji parametry /PRIV a /GROUPS. Vše zahrnující /ALL také není k zahození.   Nástroj WhoAmI lze používat... Posted Dec 10 2009, 02:00 AM by TechNet Blogs Filed under: tool, Admin, Windows 7

• SQL Server vs. Oracle Security Vulnerabilities

  Think Oracle's "Unbreakable" advertising implies it has the fewest vulnerabilties? Think again. This graphic is an excerpt from "OracleEdisonResponse.docx". You can download the full document here: http://download.microsoft.com... Posted Nov 18 2009, 02:14 PM by TechNet Blogs Filed under: configuration, Admin

• Making STIG Compliance Much Easier, Part II

  Securing a system requires efforts that can be dropped into 3 buckets: Configuration, Alerting, and Auditing. (Am I missing any? Post a comment if you think of any others...) Securing a system's configuration means its run-time configuration. Design... Posted Oct 26 2009, 01:23 PM by TechNet Blogs Filed under: configuration, Admin, Auditing, STIG, Alerting, PBM