Yet another way to include portability on DTS packages
An proposal about using simple server name resolution and INI files to make a DTS package portable.
2008-04-10
4,222 reads
Articles
Historical Dollars
Tracking your salary over time might be a fun, or not so fun, endeavor for a DBA. However should anyone else know what your trend is? Steve Jones asks the question this week.
2008-04-10
44 reads
Historical Dollars
Tracking your salary over time might be a fun, or not so fun, endeavor for a DBA. However should anyone else know what your trend is? Steve Jones asks the question this week.
2008-04-10
38 reads
Historical Dollars
Tracking your salary over time might be a fun, or not so fun, endeavor for a DBA. However should anyone else know what your trend is? Steve Jones asks the question this week.
2008-04-10
36 reads
Issues with running backup log with no_log or truncate_only
On my database server I have my databases set to the full recovery model, but the transaction logs get quite big, so I am issuing a BACKUP LOG with NO_LOG. I am not exactly sure if this causes any issues, but I know that I am able to free up space in my transaction log and shrink the file. Is this the correct way to handle this situation?
2008-04-10
4,312 reads
Joining to the Next Sequential Row
One of the more obscure requirements that a developer may find themselves facing is the need to compare a row with its immediate sibling. One such case is when a list of values needs to be processed to produce a moving average or to smooth a sequence of statistical numbers where their order is important. For example, values lying along a time line. The solution is actually quite simple, but not immediately obvious.
2008-04-10
4,439 reads
Quality Control with SQL Server
What's going on with SQL Server? Quite a few problems with patches reported lately. Steve Jones comments on what he sees happening.
2008-04-09 (first published: 2007-04-06)
4,373 reads
XML Workshop XVIII - Generating an RSS 2.0 Feed with TSQL
Continuing on with part 18 of his series, MVP Jacob Sebastian examines building an RSS feed in T-SQL.
2008-04-09
6,509 reads
SQL Server Tracing: An Automated and Centralized Solution
When you are trying to pin down the cause of a problem with a SQL Server, there is probably going to come a time when you need to get 'trace' information. If you've ever done that, you'll know how easy it is to get overwhelmed by the detail. Here, Shawn McGehee shows how to get round the problem by capturing trace information on a schedule, filtering the captured information, and monitoring it from a central location.
2008-04-09
2,451 reads
The Social Mesh
Steve Jones talks about some research from Dr. Cross, a professor from his alma mater, into social networks and how work gets done in a company.
2008-04-09
41 reads
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers