I know I don't need to tell you, but this could turn in to a whole other thread. Of course, working for smaller companies, I've contributed to this by making...

Asking for and getting a consistent format for incoming data from multiple clients is often wishful thinking. Sure, if you've done previous conversions from a system(s) that is the source...

I have been working with SQL Server for 20 years.  I'm still amazed at how difficult it is to import CSV/Excel files into it.  The wizards are just too...

Like most of us, I've dealt with this junk and had to add conversion steps in an SSIS package, etc. It usually isn't that bad. As long as the format...

Any thoughts about using a separate server to host agent jobs and have that pole the AG to find out which is the primary and target that server? The majority...

Also, after looking at the code, it looks like I may have addressed the multiple simultaneous execution issue for the most part, but not completely. The BCP selet statement would...

• This reply was modified 5 years, 2 months ago by  jfogel.

Hopefully this gives you some direction, as mentioned in my prior post, I'm not using subscriptions. Instead, I'm using a home-brewed scheduling and delivery system. This is an example of...

I totally forgot about this. What I ended up doing was creating a stored procedure that generates a script that is called by the RS executable. I have another scheduled...

I was fortunate during DR testing due to how we planned the fail-over. As in most cases, you have the controlled method and then there is the be happy you...

I typically don't use a lot of the new features simply because I don't have a need. Everyone needs what is mentioned in this link:

https://sqlserverupdates.com/news/announcing-sql-server-2017-cu12-omg-they-finally-fixed-string-or-binary-data-would-be-truncated/

Thing is, then anyway, TOAD wasn't free, Oracle didn't have a good query/result interface as part of the package. I used to use a linked server to query Oracle and...

I agree about being able to assign type and size of variables based on the table.

I've installed and configured it, tested DB restoration and pointed a few apps at it with no issues. I agree that it will open new doors for those with Linux/UNIX...