Marcin Policht

Thursday Dec 19th 2002 by DatabaseJournal.com Staff
Share:

Marcin Policht's Articles




Being a long time reader, I'm proud to join the crowd of technology gurus gathered here. I have a fair share of Microsoft exams behind me, a couple of acronyms after my name - MCSE, MCSD, and MCT, decent familiarity with majority of MS BackOffice products (SMS, SQL, Exchange, IIS), programming and scripting languages (VB, C++, VBScript with wsh) and several years of practical experience with Windows environment administration and engineering. My focus these days is on SQL Server and Windows 2000, and I'll attempt to share the most interesting experiences with these products...


 
 
Current Articles
- Introduction to Azure SQL Data Sync
- Azure SQL Database - Dynamic Data Masking
- Backing Up SQL Server Databases Hosted on Azure VMs
- Integrating DACPAC deployments of Azure SQL Database with Visual Studio Team Services
- Managing Azure SQL Database Recovery
- Introduction to SAP HANA on Azure
- SQL Server in Azure Virtual Machines - Performance Optimizations
- Azure SQL Database - Authenticating Application Access by Using Azure AD Tokens
- Azure SQL Database - Implementing Azure AD Authentication
- Azure SQL Database - Azure AD Authentication
- Introduction to SQL Server Stretch Database
- Introduction to Azure SQL Database Temporal Tables
- Introduction to the Azure SQL Database Advisor
- Implementing Azure SQL Database Elastic Database Jobs
- Azure SQL Database Elastic Database Jobs
- Introduction to Protecting SQL Server with Azure Site Recovery
- Introduction to Azure SQL Database Elastic Database Pools
- Azure SQL Database Resiliency - Business Continuity
- Azure SQL Database Resiliency - Point-in-Time Restore
- Azure SQL Database - Transparent Data Encryption
- Azure SQL Database - Row-Level Security
- Automated Patching of SQL Server IaaS VMs
- Automated Backups of SQL Server Databases in Azure IaaS VMs
- Automating Image-Based Deployment of SQL Server on Azure IaaS VMs - Completing the Process
- Automating Image-Based Deployment of SQL Server on Azure IaaS VMs - Combining OS Installation and SQL Server Sysprep
- Automating Image-Based Deployment of SQL Server on Azure IaaS VMs - Preparing SQL Server
- Automating Image-Based Deployment of SQL Server on Azure IaaS VMs - Preparing OS Image
- Introduction to Automating Deployment of SQL Server in Azure IaaS Virtual Machines
- Managing Azure SQL Database Authorization
- Azure SQL Database Auditing
- Introduction to Azure SQL Database Scalability
- Monitoring Azure SQL Database
- Performing Azure SQL Database Management Tasks by Using PowerShell with REST API
- Management of Windows Azure SQL Databases via PowerShell with REST APIs
- Using PowerShell to Manage Windows Azure SQL Databases
- Introduction to SQL Server in Microsoft Azure
- Microsoft Azure SQL Database Security - Authentication, Authorization, and Encryption
- Microsoft Azure SQL Database Security - Firewall Configuration
- Windows Azure SQL Database - Uploading Data by Using the bcp Utility
- Windows Azure SQL Database - Uploading Data by using SQL Server Integration Services
- Migrating SQL Server Databases to Windows Azure by Leveraging BACPAC Files
- Migrating SQL Server Database to Windows Azure - Deploying SQL Database
- Migrating SQL Server Database to Windows Azure - Resolving Incompatibility Issues
- Identifying Incompatibility Issues When Migrating SQL Server Database to Windows Azure
- SSIS 2012 - Introduction to Windows Azure SQL Databases
- SSIS 2012 - Using PowerShell to Remotely Execute File System Packages in Multi-Server Scenarios
- SSIS 2012 - Using PowerShell to Remotely Execute File System Packages
- SQL Server 2012 Integration Services - Leveraging PowerShell in Package Deployment Model
- SQL Server 2012 Integration Services - Using PowerShell to Configure Project Environments
- SQL Server 2012 Integration Services - Using PowerShell to Configure Package Execution Parameters
- SQL Server 2012 Integration Services - PowerShell-Based Project Deployment
- SQL Server 2012 Integration Services - Introduction to PowerShell-based Management of SSIS
- SQL Server 2012 Integration Services - Introduction to Managing SQL Server with PowerShell
- Securing SQL Server 2012 Integration Services Packages using Digital Certificates
- SQL Server 2012 Integration Services - Implementing Package Security using Access Control
- SQL Server 2012 Integration Services - Unattended Execution of SSIS Packages
- SQL Server 2012 Integration Services - GUI-Friendly Ways of Managing Execution of SSIS Packages
- SQL Server 2012 Integration Services - Advanced Functionality of Dtexec.exe
- SQL Server 2012 Integration Services - Using dtexec.exe to Run File System-based Packages
- SQL Server 2012 Integration Services- Using Environments in Package Execution
- SQL Server 2012 Integration Services - Package Deployment
- SQL Server 2012 Integration Services - Package and Project Configurations
- SQL Server 2012 Integration Services - Project Deployment
- SQL Server 2012 Integration Services - Package and Project Parameters
- SQL Server 2012 Integration Services - Package Variables
- SQL Server 2012 Integration Services - Installation and Initial Configuration
- SQL Server 2012 Integration Services - Overview
- SQL Server 2008 and 2008 R2 Integration Services - Sort Transformation
- SQL Server 2008 and 2008 R2 Integration Services - Sampling Transformations
- SQL Server 2008 and 2008 R2 Integration Services - Dimension Processing Data Flow Destination
- SQL Server 2008 and 2008 R2 Integration Services - Partition Processing Data Flow Destination
- SQL Server 2008 and 2008 R2 Integration Services - Customizing Slowly Changing Dimension Transformation
- SQL Server 2008 and 2008 R2 Integration Services - Slowly Changing Dimension Transformation - Historical Attributes
- SQL Server 2008 and 2008 R2 Integration Services - Slowly Changing Dimension Transformation - Type 1 Changes
- Data Mining Model Training Destination in SQL Server Integration Services
- Data Mining Query Transformation in SQL Server Integration Services
- Data Mining Query Task in SQL Server Integration Services
- SQL Server 2008 and 2008 R2 Integration Services - Analysis Services Execute DDL Task
- SQL Server 2008 and 2008 R2 Integration Services - Analysis Services Processing Task
- SQL Server 2008 and 2008 R2 Integration Services - Using Script Task To Implement FTP Functionality
- SQL Server 2008 and 2008 R2 Integration Services - FTP Task
- SQL Server 2008 and 2008 R2 Integration Services - Consuming Web Services Using Script Task
- SQL Server 2008 and 2008 R2 Integration Services - Message Queuing Using Script Task
- SQL Server 2008 and 2008 R2 Integration Services - Managing Remote Processes Using Script Task
- SQL Server 2008 and 2008 R2 Integration Services - Managing Local Processes Using Script Task
- SQL Server 2008 and 2008 R2 Integration Services - Starting Local Processes
- SSIS Script Task and Microsoft Office Automation
- Accessing Excel Via ADO.NET Using SSIS Script Task
- Script Task and Event Logging in SSIS
- Interacting with File System Objects Using SSIS Script Task
- Script Task Exception Handling in SSIS
- Querying Active Directory using SSIS Script Task
- Introduction to SSIS Script Task
- Using SSIS Logging to Resolve Runtime Errors and Performance Issues
- SSIS Events and Handlers
- Protecting the Integrity of SSIS Packages Using Digital Signatures
- Securing the Content of SSIS Packages
- Executing SSIS Packages Using DTExec
- Implementing SSIS Package Configurations
- How to Implement Package Variables in SQL Server 2008

SQL Server 2008 and 2008 R2 Integration Services


SQL Server 2005 Express Edition
- Full Text Index Queries using CONTAINS and CONTAINSTABLE
- Data searches that leverage existing indexes
- Full Text Index Management in SQL Server 2005 Express Edition
- Full Text Index Implementation in SQL Server 2005 Express Edition
- Full Text Catalog Configuration in SQL Server 2005 Express Edition
- Troubleshooting Reporting Services Performance Issues
- Troubleshooting Reporting Services
- Securing Reporting Services
- Securing Reporting Services Data Sources
- Securing Data using Linked and Parameterized Reports
- Reporting Services System and Item Security
- Reporting Services Content Management
- Introduction to SQL Server 2005 Express Edition Reporting Services Content Management
- Taking Advantage of Sample Reporting Services Reports
- The Basic Functionality of Report Designer
- Basic Server Reporting Functionality in SQL Server 2005 Express Edition
- Initial Configuration of Reporting Services on SQL Server 2005 Express Edition
- Service Broker Poison Message Handling
- Handling Service Broker Errors
- Service Broker Transactional Support in SQL Server 2005 Express Edition
- Security Context of Service Broker Internal Activation
- Service Broker Activation in SQL Server 2005 Express Edition
- Configuring Anonymous Dialog Security in SQL Server 2005 Express Service Broker Conversation
- Conducting Service Broker Conversation Using Full Dialog Security in SQL Server 2005 Express Service
- Configuring Full Dialog Security in SQL Server 2005 Express Service Broker Conversation
- Configuring Transport Encryption in SQL Server 2005 Express Service Broker Conversation
- Establishing Distributed SQL Server Express' Service Broker Conversations Using Certificate-based Authentication
- Configuring Certificate-based Authentication in SQL Server Express' Distributed Service Broker Environment
- SQL Server 2005 Express Edition - Part 32 - Distributed Service Broker Environment - Conducting Dialogs
- SQL Server 2005 Express Edition - Part 31 - Distributed Service Broker Environment - Routing
- SQL Server 2005 Express Edition - Part 30 - Distributed Service Broker Environment - Endpoints
- SQL Server 2005 Express Edition - Part 29 - Implementing Service Broker Conversation
- SQL Server 2005 Express Edition - Part 28 - Implementing Service Broker Conversation
- SQL Server 2005 Express Edition - Part 27 - Implementing Basic Service Broker Objects
- SQL Server 2005 Express Edition - Part 26 - Introduction to Service Broker
- Implementing Upgrade of SQL Server 2005 Express Edition
- SQL Server 2005 Express Edition - Part 24 - Planning Upgrade of SQL Server 2005 Express Edition
- SQL Server 2005 Express Edition - Part 23 - Manual Upgrade from Microsoft SQL Server Desktop Engine (MSDE)
- SQL Server 2005 Express Edition - Part 22 - Upgrading from Microsoft SQL Server Desktop Engine (MSDE)
- SQL Server 2005 Express Edition - Part 21 - Using Replication Management Objects
- SQL Server 2005 Express Edition - Part 20 - Authenticating Merge Web Synchronization
- SQL Server 2005 Express Edition - Part 19 - Authenticating Merge Web Synchronization
- SQL Server 2005 Express Edition - Part 18 - Merge Web Synchronization Setup
- SQL Server 2005 Express Edition - Part 17 - Merge Web Synchronization
- SQL Server 2005 Express Edition - Part 16 - Transactional and Merge Replication
- SQL Server 2005 Express Edition - Part 15 - Snapshot Replication
- SQL Server 2005 Express Edition - Part 14 - Replication Support
- SQL Server 2005 Express Edition - Part 13 - ClickOnce Deployment and Security
- SQL Server 2005 Express Edition - Part 12 - ClickOnce Deployment and Updates
- SQL Server 2005 Express Edition - Part 11 - ClickOnce Deployment and Maintenance Options
- SQL Server 2005 Express Edition - Part 10
- SQL Server 2005 Express Edition - Part 9 - Managing User Instances
- SQL Server 2005 Express Edition - Part 8 - XCopy Deployment
- SQL Server 2005 Express Edition - Part 7 - Post Installation Configuration Tasks (Management)
- SQL Server 2005 Express Edition - Part 6 - Post Installation Configuration Tasks (Encryption)
- SQL Server 2005 Express Edition - Part 5 - Post-Installation Network Configuration Tasks
- SQL Server 2005 Express Edition - Part 4 - Surface Area Configration
- SQL Server 2005 Express Edition - Part 3 - Installation
- SQL Server 2005 Express Edition - Part 2
- SQL Server 2005 Express Edition - Part 1

SQL Server 2005 Integration Services
- SQL Server 2005 Integration Services - Templates, Data Sources, and Data Source Views - Part 50
- SQL Server 2005 Integration Services - Part 49 - Maintenance Plan Tasks
- SQL Server 2005 Integration Services - Part 48
- SQL Server 2005 Integration Services - Maintenance Plan Tasks - Part 47
- SQL Server 2005 Integration Services - Maintenance Plan Tasks - Part 46
- SQL Server 2005 Integration Services - Part 45 - Bulk Insert Task and Format Files
- SQL Server 2005 Integration Services - Part 44 - Bulk Insert Task
- SQL Server 2005 Integration Services - Part 43 - XML Task continued
- SQL Server 2005 Integration Services - Part 42 - XML Task continued
- SQL Server 2005 Integration Services - Part 41 - XML Task
- SQL Server 2005 Integration Services - Part 40 - Web Service Task
- SQL Server 2005 Integration Services - Part 39 - Send Mail Task
- SQL Server 2005 Integration Services - Part 38 - Pivot Transformation
- SQL Server 2005 Integration Services - Part 37 - Derived Column Transformation
- SQL Server 2005 Integration Services - Part 36 - Term Extraction and Term Lookup
- SQL Server 2005 Integration Services - Fuzzy Grouping - Part 35
- SQL Server 2005 Integration Services - Fuzzy Lookup - Part 34
- SQL Server 2005 Integration Services - Lookup Transformation - Part 33
- SQL Server 2005 Integration Services - Message Queue Task - Part 32
- SQL Server 2005 Integration Services - Performance - Part 31
- SQL Server 2005 Integration Services - Performance - Part 30
- SQL Server 2005 Integration Services - Digital Signing of Packages - Part 29
- SQL Server 2005 Integration Services - Security - Part 28
- SQL Server 2005 Integration Services - Working with SQL Server 2000 DTS Packages - Part 27
- SQL Server 2005 Integration Services - Checkpoints - Part 26
- SQL Server 2005 Integration Services - Transaction Support - Part 25
- SQL Server 2005 Integration Services - Package Execution - Part 24
- SQL Server 2005 Integration Services - Packages Deployment - Part 23
- SQL Server 2005 - SQL Server Integration Services - Package Management - Part 22
- SQL Server 2005 Integration Services - Import and Export Wizard
- SQL Server 2005 Integration Services - Migration Tasks
- SQL Server 2005 Integration Services - Part 19
- SQL Server 2005 Integration Services - Part 18
- SQL Server 2005 Integration Services - Part 17
- SQL Server 2005 Integration Services - Part 16
- SQL Server 2005 - SQL Server Integration Services - Debugging Script Component - Part 15
- SQL Server 2005 - SQL Server Integration Services - Part 14 - Debugging Data Flow
- SQL Server 2005 - SQL Server Integration Services - Part 13
- SQL Server 2005 - SQL Server Integration Services - Part 12 - Logging
- SQL Server 2005 - SQL Server Integration Services - Part 11 - SSIS Events and Event Handlers
- SQL Server 2005 - SQL Server Integration Services - Part 10
- SQL Server 2005 - SQL Server Integration Services - Part 9
- SQL Server 2005 - SQL Server Integration Services - Part 8
- SQL Server 2005 - SQL Server Integration Services - Part 7
- SQL Server 2005 - SQL Server Integration Services - Part 6
- SQL Server 2005 - SQL Server Integration Services - Part 5
- SQL Server 2005 - SQL Server Integration Services - Loop Containers
- SQL Server 2005 - SQL Server Integration Services - Part 4
- SQL Server 2005 - SQL Server Integration Services - Part 3
- SQL Server 2005 - SQL Server Integration Services - Part 2
- SQL Server 2005 - SQL Server Integration Services - Part 1

SQL Server 2005

SQL Server 2005 Security

SQL Server 2005 High Availability and Scalability Enhancements

SQL Server 2000 Security

SQL Server 2000 DTS

XML and SQL 2000

Scalability and high availability of Microsoft SQL Server 2000

Automating SQL Server Management with WMI

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved