Diana Moldovan

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.

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)

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

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)

More SQL Server Solutions

download

get free sql tips