Archive | July, 2009

SQLBits Goes West – Session Submissions

Just this Monday they have opened up the session submissions for the next installment of SQLBits. For those of you you don’t know, SQLBits is the largest SQL Server event that I know of in the UK for several year running now. I believe they are on number 5 with this one and it will […]

Read more

Using INFORMATION_SCHEMA to Get Column Information

A commonly asked question that I field is when working with CRM or another 3rd party database what is the most efficient way in order to find out column information on a specific table using only T-SQL. This practice is often important if you are writing your own stored procedures and functions to import data […]

Read more

SSIS: Reading and Writing to Variables in Script Task

A lot of people still consistently ask me about how to read and write to variables in the SSIS script task. In this post I will demonstrate for you the two ways in which you can go about this, one from native SSIS functionality and the other from code. In SQL Server 2008 both will […]

Read more

More SQL Injection Attacks

There is another wave of  SQL Injection attacks underway by an older botnet, Asprox. In the link below Trend Labs outlines the history of this piece of code http://blog.trendmicro.com/yamsia-yet-another-massive-sql-injection-attack/ Further, SSWUG.org is giving some tips on what to do in order to protect your pages against these types of attacks. Hopefully, your companies are doing […]

Read more

SQL Server 2008 Maintenance Plan Errors When Changing Server Name

  I recently ran into a bug issue here recently when I had to update a server name on a database box running SQL Server 2008. I updated the server name and then set SQL Server to run under the new name as well and restarted the system. The strange thing was that I went […]

Read more

Dynamics CRM 4.0: Email Router Timeout Errors when using Exchange 2007

During a recent Exchange server move I ran into some issues with the Microsoft Dynamics CRM Email Router throwing up errors #26090 – An error occurred while opening mailbox crmadminuser@mydomain.com. System.Net.WebException: The operation has timed out at System.Net.HttpWebRequest.GetRequestStream() at Microsoft.Crm.Tools.Email.Providers.HttpDavRequest.SubmitXmlCommand(HttpWebRequest httpWebRequest, String body) at Microsoft.Crm.Tools.Email.Providers.HttpDavRequest.RetrieveInboxUri() at Microsoft.Crm.Tools.Email.Providers.ExchangePollingMailboxProvider.OpenMailbox()at Microsoft.Crm.Tools.Email.Providers.CrmPollingMailboxProvider.Run()   The error is pretty annoying because […]

Read more

Error Message from CLR assembly on SQL Server 2005 Restored Database

Okay,  you may run into the situation where you restore a database from Server A onto Server B and the database contains CLR assemblies. When you try to execute a given CLR assembly it blows an error similar to the one below. Msg 10314, Level 16, State 11, Line 2 An error occurred in the […]

Read more

Restoring Databases for Database Mirroring

In a follow-up to my previous post about using the system tables to find out information about your backups we look at how to script out restores of a large number of databases for database mirroring on a SQL Server 2008 instance. Actually, this could be used in a lot of instances where you need […]

Read more

Getting Backup File Information on SQL Server 2005/SQL Server 2008

In a lot of instances, you may be doing something like database mirroring or a migration job that involves a lot of databases and possibly a lot of backup files, especially transaction log backups. It’s a real pain if you have to restore these files by hand. It would be much easier if you have […]

Read more

SQL Server 2008 Setting Up Database Mirroring with T-SQL

Database mirroring is normally one of those subjects that everyone thinks is a really cool idea but think that it is a complicated process to implement without the usage of SSMS wizards. Who can blame you, database mirroring is the low cost,readily available high availability solution. How can a killer high availability solution like this […]

Read more