A review of Knight’s 24-Hour Trainer Microsoft SQL Server 2008 Integration Services
About three years ago my manager came up to me and said “We need someone to learn SSIS, you’re it.” ...
2012-11-07
1,175 reads
About three years ago my manager came up to me and said “We need someone to learn SSIS, you’re it.” ...
2012-11-07
1,175 reads
This is just a quickie post to answer a question on how to loop through multiple servers in SSIS. There...
2012-11-05 (first published: 2012-10-31)
4,997 reads
Many years ago when I was still working on SQL 2000 I occasionally needed to find all stored procedures and views...
2012-10-26
12,303 reads
Every now and again (today for example) I’ll get a call that one of our SQL Server instances is down. ...
2012-10-23
1,253 reads
2012-10-22
2,300 reads
I recently started using OBJECT_NAME, OBJECT_SCHEMA_NAME and OBJECT_ID functions; unfortunately I really could have used OBJECT_TYPE but it doesn’t exist...
2012-10-19
1,234 reads
I recently passed my MCTS 2008 Development (70-433). Yay me! That made my 3rd 2008 certification. This one was probably the...
2012-10-15
1,845 reads
Multiple CTEs
It’s somewhat obscure in BOL and I wasn’t able to find any examples but it turns out you can...
2012-10-11 (first published: 2012-10-09)
4,561 reads
I’ve been unable to connect to a server via one of its aliases for about a week. When I looked...
2012-10-05
1,953 reads
I work with a reasonably large team of DBAs. There are 9 of us and we support not only 70+...
2012-10-02
1,197 reads
I was sick of changing context in Azure Data Studio while cleaning up things...
By Zikato
The crime spree in Digitown is not ending. This time 20 cars have been...
By Steve Jones
One of our mission statements in the Book of Redgate says: attempt to do...
Comments posted to this topic are about the item Helpful Management Studio Settings and...
Comments posted to this topic are about the item The Minimal Linked Server
Comments posted to this topic are about the item The AI View From Above
What is the minimal number of parameters to add a linked server with sp_addlinkedserver?
See possible answers