Viewing 15 posts - 1 through 15 (of 242 total)
What about something like posted here
April 30, 2015 at 11:29 am
Assuming you have sql server 2012, you could use sys.dm_server_registry
See how to use it here:
So something like (I have no alias's to test!, but you get the idea):
April 30, 2015 at 9:53 am
My only recommendation, assuming you are using SQL 2012, would be to use a CONCAT(@tableHTML1, @tableHTML2) instead of:
= @tableHTML1 + @tableHTML2;
Because if one of the tables is null,...
April 30, 2015 at 9:38 am
Using SQL Agent to do this would be better as it typically already has elevated permissions.
Let it do the restore, then have it just grant the needed permissions (read, write,...
April 30, 2015 at 9:22 am
what concerns me is how hospitals interpret HIPAA to slow access to patients medical records. we requested my wife's records well over a year ago and have not formally received...
February 11, 2013 at 7:34 am
I could not agree more.
However isn't this the same concept being used for "Big Data" .
Every presentation I see about big data (aside from hadoop), seems to look just like...
January 20, 2013 at 9:25 pm
I'd like to add one of my pet peeves.
I get lots of resumes, that have a skills section. In this section, the list all the languages they know and...
July 19, 2012 at 9:40 am
Are you using a different installer than the one used for the VS install? You may have to do a full uninstall of VS, then do a selective re-install.
September 7, 2011 at 1:34 pm
If you are restoring to a different server - remember logins are held in Master, so if your not restoring Master as well, those logins will not exist.
September 7, 2011 at 1:25 pm
We use informatica. Oracle really does not have a built in tool similiar to SSIS. Sure there is the SQL Loader - that only the script junkies use. Most Oracle...
September 7, 2011 at 1:14 pm
I've had ok luck with the OTN. I've posted a few things there, just don't mention that you prefer SQL Server and Oracle sucks - for some reason they don't...
September 7, 2011 at 1:10 pm
We run 128 GB on our big DW SQL server
March 11, 2011 at 7:54 am
I forgot to mention - data loss from contractors http://thehill.com/blogs/hillicon-valley/technology/97817-va-loses-another-laptop-with-veterans-personal-information
Some of our contractors use Macs for the sole purpose that we cannot lock down USB ports...
July 28, 2010 at 10:30 am
I work in Research at the Veterans Admin Hospital. It is very hard to convert research $$ to IT dollars - as they are congressionally split. So we end up...
July 28, 2010 at 9:52 am
let me make the example a little more descriptive. Here I will look for people with the same drug prescription on the same day. This is a frequent...
May 21, 2010 at 9:26 am