SQL CLR Table-Valued Functions can stream data back, but there aren't many examples of the quick and easy method. Solomon Rutzky brings us an article that givse you an example you can extend to your environment.
2009-12-23
13,448 reads
New author Nigel Maneffa brings us a look at SQL Server 2008 and its new features, trying to decide if it's worth the upgrade.
2009-12-23 (first published: 2008-10-21)
30,992 reads
The Script Task and Script component are often used by people developing SSIS packages because they are easy to use and now because SSIS could be perceived to be more developer friendly they are very powerful. That being said we should no be using them everywhere.
2009-12-23
3,228 reads
Companies have to make choices about what to spend money on, often not using the same priorities as those in IT might choose. Steve Jones talks about some of choices they make and why their decisions might make some sense.
2009-12-23
1,522 reads
Companies have to make choices about what to spend money on, often not using the same priorities as those in IT might choose. Steve Jones talks about some of choices they make and why their decisions might make some sense.
2009-12-23
1,747 reads
Learn the basics of Event Notifications from MVP Jonathan Kehayia. This article will show you how to create customized responses to events in SQL Server 2005/2008.
2009-12-22
24,805 reads
Can we trust users to make good decisions about what to install on their devices? Steve Jones says that the Apple iPhone model has some good advantages and it might work well for SQL Server as well.
2009-12-22
3,470 reads
Can we trust users to make good decisions about what to install on their devices? Steve Jones says that the Apple iPhone model has some good advantages and it might work well for SQL Server as well.
2009-12-22
1,570 reads
Can we trust users to make good decisions about what to install on their devices? Steve Jones says that the Apple iPhone model has some good advantages and it might work well for SQL Server as well.
2009-12-22
1,528 reads
My company is heavily dependant on SQL Server transactional replication and once in awhile the default alerts are not sufficient and sometimes we want to be able to disable alerts when we perform maintenance. In this tip I will show you a few scripts I have implemented to allow me to better manage our transactional replication.
2009-12-22
3,036 reads
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
The state-of-the-art FARE Labs Environmental Testing Laboratory provides a broad range of testing services...
Comments posted to this topic are about the item Database security permissions save script
I have a SQL Agent job for backing up a set of Analysis Services...
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers