Diana Moldovan
I'm currently working as a DBA and data centric applications developer for a small ISV company. My 6 years of experience covers SQL 2000, SQL 2005 and SQL 2008. Besides working with SQL Server, I also do .NET development. I'm constantly trying to improve my knowledge. Therefore I'm getting involved as much as I can in the activity of the local PASS chapter - http://sqlserver.ro.
2020 Awards
2020 Awards

Application Development
- .NET Bulk Insert into SQL Server (last update: 5/13/2011)
Dates
- Converting UTC to local time with SQL Server CLR (last update: 4/7/2011)
Extended Events
- Using Extended Events to troubleshoot SQL Server issues (last update: 5/2/2011)
Functions - User Defined UDF
- Introduction to SQL Server CLR table valued functions (last update: 1/16/2012)
- Remove HTML tags from strings using the SQL Server CLR (last update: 6/23/2011)
Import and Export
- Import Excel Data into SQL Server with PowerShell (last update: 12/11/2020)
Integration Services Development
- Using a Script Task in SQL Server Integration Services SSIS to Connect to a Web Service (last update: 5/5/2016)
Microsoft Excel Integration
- Import Selective Data from Excel File into SQL Server with PowerShell (last update: 11/9/2020)
- Read Excel File in SQL Server with OPENROWSET or OPENDATASOURCE (last update: 10/10/2019)
PowerShell
- Error handling with try-catch-finally in PowerShell for SQL Server (last update: 2/16/2015)
- Improve PowerShell SMO Performance for SQL Server (last update: 6/26/2015)
- Introducing PowerShell V2 Remoting for SQL Server (last update: 9/6/2011)
- Introduction into handling errors in PowerShell for SQL Server tasks (last update: 6/25/2012)
- Iterating through SQL Servers and database objects with PowerShell (last update: 4/5/2012)
- Removing HTML tags from text data using PowerShell (last update: 8/24/2011)
- Scheduling a SQL Server PowerShell script using the Task Scheduler (last update: 1/28/2011)
- SQL Server Agent Error Logging for Powershell Job Steps (last update: 2/29/2016)
Security
- Options for cross database access within SQL Server (last update: 11/30/2011)
Service Broker
- SQL Server Service Broker Error Receiving Data - 10054 (An existing connection was forcibly closed by the remote host.) (last update: 7/10/2018)
- Steps to Restore Service Broker Enabled Database on New SQL Server Instance (last update: 2/27/2018)
- Synchronizing data between SQL Server instances with Service Broker (last update: 1/24/2018)
- Understanding SQL Server Service Broker Communication Flow Between Databases (last update: 5/7/2018)
SQL Server Configurations
- Script and Alter SQL Server Database Objects with PowerShell to Correct Collation Issues (last update: 4/14/2015)
SQL Server Management Studio
- Using the SSMS Query Editor in SQLCMD Mode (last update: 2/24/2011)
T-SQL
- SQL Server sp_ prefix when and when not to use it (last update: 10/13/2011)
Table Valued Parameters
- Streaming rows of SQL Server data to a table valued parameter using a SQLDataReader (last update: 3/30/2011)