Using Transfer SQL Server Objects Task and Execute SQL Tasks in SSIS
The Transfer SQL Server Objects Tasks is a very useful tool in SQL Server 2005 to move objects between SQL Server Instances.
2009-08-13
2,578 reads
Articles
BNF Basics
Learn about the basics of Backus–Naur Form. If you've never heard of this, Tom Fischer explores this way of structuring technical information.
2009-08-12
11,266 reads
Networking for Your Career
It's hard to actually put a specific value on networking, and I've been skeptical of it in the past. However...
2009-08-12
1,708 reads
Q&A: The skinny on Reporting Services 2008
Get the inside scoop on SSRS 2008 with Michael Lisin and Jim Joseph, co-authors of the new book, "Microsoft SQL Server 2008 Reporting Services Unleashed."
2009-08-12
4,114 reads
Slicing and Dicing
There can be a lot more value when pieces of data are put together than when they exist separately. Steve Jones comments on a few ways people are repackaging information in the modern world.
2009-08-12
80 reads
Slicing and Dicing
There can be a lot more value when pieces of data are put together than when they exist separately. Steve Jones comments on a few ways people are repackaging information in the modern world.
2009-08-12
70 reads
Slicing and Dicing
There can be a lot more value when pieces of data are put together than when they exist separately. Steve Jones comments on a few ways people are repackaging information in the modern world.
2009-08-12
65 reads
Where is my app.config for SSIS?
Sometimes when working with SSIS you need to add or change settings in the .NET application configuration file, which can be a bit confusing when you are building a SSIS package not an application. First of all lets review a couple of examples where you may need to do this.
2009-08-12
3,085 reads
Murach’s ADO.NET 3.5, LINQ, and the Entity Framework with C# 2008
Read a sample chapter from this new book about C# and LINQ from Murach.
2009-08-11
2,329 reads
Post Snapshot Script - SQL School Video
The post snapshot script in replication allows you to make changes to the subscriber after you complete a snapshot. Unaware of this feature? Watch this episode of SQL School.
2009-08-11
11,717 reads
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers