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
  

• .NET Bulk Insert into SQL Server (last update: 5/13/2011)
  

• Converting UTC to local time with SQL Server CLR (last update: 4/7/2011)
  

• Using Extended Events to troubleshoot SQL Server issues (last update: 5/2/2011)
  

• 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 Excel Data into SQL Server with PowerShell (last update: 12/11/2020)
  

• Using a Script Task in SQL Server Integration Services SSIS to Connect to a Web Service (last update: 5/5/2016)
  

• 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)
  

• 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)
  

• Options for cross database access within SQL Server (last update: 11/30/2011)
  

• 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)
  

• Script and Alter SQL Server Database Objects with PowerShell to Correct Collation Issues (last update: 4/14/2015)
  

• Using the SSMS Query Editor in SQLCMD Mode (last update: 2/24/2011)
  

• Streaming rows of SQL Server data to a table valued parameter using a SQLDataReader (last update: 3/30/2011)
  

• SQL Server sp_ prefix when and when not to use it (last update: 10/13/2011)