Articles

It is recommended that you remove all special characters and HTML formatting. This task can be handled in TSQL code, however in this case I have the opportunity to use .NET and the power of the regular expressions to manage the string. In this tip, I'll build a CLR function which cleans up a string of HTML tags and special characters. I'll use Visual Studio 2010 with C# as the programming language. Check out this tip for my solution.

2011-07-04

3,902 reads

SQL Server Service Broker Security

by Additional Articles

Database Journal

Security

Arshad Ali examines the different types and different layers of security that SQL Server Service Broker provides during communication and while accessing Service Broker objects.

2011-07-04

1,810 reads

SQL Overview Part 1

by David Bird

SQLServerCentral.com

Integration Services (SSIS)

Monitoring your SQL Server instances and figuring out what's going on is important to keep an eye on your environment. David Bird brings us a new series that looks at how you might start setting this up with Integration Services.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(29)

You rated this post out of 5. Change rating

2011-07-01 (first published: 2008-01-07)

27,825 reads

Discuss

SQL Server 2008 and 2008 R2 Integration Services - FTP Task

by Additional Articles

Database Journal

Integration Services (SSIS)

FTP Task lets you copy files across distributed, frequently incompatible systems.

2011-07-01

3,288 reads

First Normal Form

by Tom Thomson

SQLServerCentral.com

Normalization

Learn the basics of first normal form and what that means to a database designer from Tom Thomson.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(60)

You rated this post out of 5. Change rating

2011-06-30

10,898 reads

Discuss

Raw Materials - Harmonious Connections

by Larry Gonick

SQLServerCentral.com

Raw Materials

In which Arthur makes some changes for the sake of another

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(7)

You rated this post out of 5. Change rating

2011-06-30 (first published: 2009-05-13)

7,312 reads

Discuss

SQL Server Central Management Server Security

by Additional Articles

MSSQLTips.com

Central Management Server (CMS)

I have seen several tips on SQL Server Central Management Server and I want to implement the technology for my team. The only thing holding me back is security. Can you explain how security works with Central Management Server? What security access is needed to manage CMS? How about connecting to CMS? How about running a query using CMS? Check out this tip to answer these questions.

2011-06-30

2,912 reads

Identify Local Administrators on a SQL Server box using PowerShell

by Additional Articles

MSSQLTips.com

PowerShell

I want to determine who the local administrators are on each of my SQL Servers. Basically, I'd like a nightly job to run against each of my SQL Servers and produce a list of admins for each server for my review. How can I do this?

2011-06-29

2,595 reads