Tag Archives: microsoft sql server
-
A review of Knight’s 24-Hour Trainer Microsoft SQL Server 2008 Integration Services
1November 7, 2012 by Kenneth Fisher
About three years ago my manager came up to me and said “We need someone to learn SSIS, you’re it.” …
Continue reading -
Looping through multiple servers in SSIS
16October 31, 2012 by Kenneth Fisher
This is just a quickie post to answer a question on how to loop through multiple servers in SSIS. There …
Continue reading -
How do I find all stored procedures or views that use a specific table?
3October 26, 2012 by Kenneth Fisher
Many years ago when I was still working on SQL 2000 I occasionally needed to find all stored procedures and views …
Continue reading -
I can connect to my instance locally but not remotely
4October 23, 2012 by Kenneth Fisher
Every now and again (today for example) I’ll get a call that one of our SQL Server instances is down. …
Continue reading -
fn_OBJECT_TYPE
4October 19, 2012 by Kenneth Fisher
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 …
Continue reading -
A review of SQL Interoperability / Joes 2 Pros Volume 5 by Rick A Morelan
1October 15, 2012 by Kenneth Fisher
I recently passed my MCTS 2008 Development (70-433). Yay me! That made my 3rd 2008 certification. This one was probably the …
Continue reading -
Active flag on the TCP/IP Properties page of SQL Server Configuration Manager
1October 5, 2012 by Kenneth Fisher
I’ve been unable to connect to a server via one of its aliases for about a week. When I looked …
Continue reading -
Funny results from OPTIMIZE FOR AD HOC WORKLOADS
2September 18, 2012 by Kenneth Fisher
I recently turned on OPTIMIZE FOR AD HOC WORKLOADS for the first time on one of my servers. When I …
Continue reading -
EXECUTE AS USER = ‘Somebody else’
2September 9, 2012 by Kenneth Fisher
As a database administrator I get lots of security requests. “Please grant me read authority on this table, write on that table, …
Continue reading -
sp_helptext
6September 2, 2012 by Kenneth Fisher
My manager has been quietly laughing under his breath at me for years. Usually because I much prefer queries and …
Continue reading
SQL Studies 