Learn how the DTExec and DTExecUI utilities give you the ability to assign values to arbitrary properties of components within a SQL Server Integration Services package, when invoking its execution.
2010-08-24
3,224 reads
A way to handle application releases involving multiple scripts and/or multiple databases.
2010-08-23
6,750 reads
Congratulations to Tracy Hamlin, voted to be the Exceptional DBA of 2010.
2010-08-23
1,541 reads
This is a challenge to identify the downtime of servers from the log data generated by a monitoring application.
2010-08-23
1,515 reads
For security reasons many sites disable the extended stored procedure xp_cmdshell, which is used to run DOS commands or executables. When you really have to run a DOS command or an executable from a stored procedure how can you get around this limitation without a breakdown in security.
2010-08-23
5,335 reads
One common problem in querying is to reference the previous row in a data set as part of a calculation. David McKinney brings us an interesting solution using SQL Server 2005.
2010-08-20 (first published: 2008-03-13)
55,360 reads
It's time to integrate social data, enterprise analytics and enterprise data for better social-media strategy.
2010-08-20
1,748 reads
Describes how to convert database mirroring to log shipping in SQL 2005/2008.
2010-08-19
6,076 reads
This tool is excellent when investigating what is going on in your StreamInsight Streams. I was looking through the menu items recently and went to Query => Event Fields I found that there were a couple of columns not added by default to the event viewer (Reminds me of the fact that the Variables viewer in SSIS hides columns also) Latency NewEndTime EnqueueTime Here they all are together. This gives us even more information about what is going on
2010-08-19
1,579 reads
Can you set a pagefile on a Windows machine to more than 4GB? Stanley Chan shows us how after an issue with a crashed Windows machine.
2010-08-18
8,616 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