Help for DBAs Who Support SSIS…
SSIS Catalog Compare helps DBAs work with their SSIS project configurations and catalogs, deploying changes from environment to environment.
2017-06-19
1,047 reads
SSIS Catalog Compare
SSIS Catalog Compare v2.0 Launch Event
Join the SSIS Catalog Compare v2.0 Launch Event on Tue, Mar 7 at 13:00 EST.
2017-03-07 (first published: 2017-03-03)
6,163 reads
Host/Session/User Names understanding required ??
I am currently testing these functions logon on a NT windows ID onto database Pubs.User_name function returns "dbo" ( same as Current_user function)System_User returns "ServerName\User"Session_user returns "dbo"Host_name returns "ServerName"Questions...I understand when the System_User changes when NT logon is different, I also undertand when server name changes, BUT when does User_Name change from dbo ( does […]
2005-01-31
2 reads
RE: Creating view thru stored proc ;-)
I have done it before. You have to write your entire statement to a variable and then use sp_executeSQL to process it.With that said IF I knew then what I know now I would not do it. I would instead have used Table UDFs that have parameters passed into them and avoid the whole dynamic […]
2004-12-23
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers