Browse by Tags

All Tags » SQL Server 2005 (RSS)
03 December 2010 22:17

Restricting logons during certain hours for certain users

Following a an email in a DL I decided to look at implementing a logon restriction system to prevent users from logging on at certain ties of the day. The poster had a solution but wanted to add auditing. I immediately thought of the My post on logging...
Posted by simonsabin | 2 comment(s)
Filed under: , , , , ,
29 October 2010 10:22

Nullable parameters in SQL 2005 & SQL 2008 - Column, parameter, or variable #1: Cannot find data type Nullable`1

When writing CLR code for SQL you need to handle nulls. You can do this in two ways, either your data types are nullable or you configure your functions to always return null when a parameter is null. The last only works for some objects and so understanding...
Posted by simonsabin | 2 comment(s)
Filed under: , ,
21 October 2010 00:57

How to downgrade Integration Services 2008 packages to 2005

Courtesy of an unnamed source we have an app to downgrade a SSIS package from the 2008 version to 2005. Whilst it works with the common components any new components aren’t supported with the exception of the Lookup. 3rd party components are also not...
Posted by simonsabin | 2 comment(s)
Filed under: , , ,
19 May 2010 19:22

Scream if you want to go faster

My session for 24hrs of pass on High Performance functions will be starting at 11:00 GMT thats migdnight for folks in the UK. To attend follow this link https://www.livemeeting.com/cc/8000181573/join?id=N5Q8S7&role=attend&pw=d2%28_KmN3r The rest...
Posted by simonsabin | 1 comment(s)
Filed under: , , , , ,
26 March 2010 18:21

Enabling super single user mode with SQL Server

I recently got an email from a fellow MVP about single user mode. It made me think about some features I had just been looking at and so I started playing. The annoyance about single user mode for SQL Server is that its not really single user, but more...
Posted by simonsabin | 2 comment(s)
Filed under: , ,
11 March 2010 20:20

SSIS - XML Source Script

The XML Source in SSIS is great if you have a 1 to 1 mapping between entity and table. You can do more complex mapping but it becomes very messy and won't perform. What other options do you have? The challenge with XML processing is to not need a...
Posted by simonsabin | 2 comment(s)
Filed under: , , , , ,
20 January 2010 23:30

XML Validation in SQL Server Intergration Services

I've been workig with XML in SQL Server Integration services this week and to say the XML task in SQL Server Integration services sucks is an understatement. Its buggy, the documentation is woefully inadequate in some cases wrong. I believe this was...
Posted by simonsabin | 2 comment(s)
Filed under: , , , ,
14 January 2010 19:21

User defined function performance is awful, Micorosft please sort this out

User defined functions looked like something great when they were introduced in SQL 2005. They are a very logical step to make more code reuseable by wrapping common code in functions. It is an approach that is in development 101 and something everyone does and looks to doing.

So what is the problem with SQL Server.

Well the issue is that ......

...
Posted by simonsabin | 5 comment(s)
Filed under: , , , , , , , ,
18 August 2009 21:44

SQL Bits session subsmission

Don't forget to submit sessions for SQLBits V in November.

For anyone that hasn't spoken before, as a speaker you will get....

...
Posted by simonsabin | with no comments
Filed under: , , , , ,
10 March 2009 21:52

A significant part of sql server process memory has been paged out

Do you have the following occuring on your SQL Server system. If so it is likely you are running SQL Server 2005 or SQL Server 2008 Standard edition on x64 hardware. It will be causing you serious performance issues when it occurs, as all your database...
Posted by simonsabin | 1 comment(s)
Filed under: , , , ,
More Posts Next page »