jinnantonnixx

For your parameter test, try: IF $%1 EQU $ goto noparam IF $%1 NEQ $ goto param goto :eof :noparam echo No parameter goto :eof :param echo The parameter is %1 goto :eof Batch is rubbish - it's a comedy scripting language. I always prefixed 'variables' with a character so I could later handle the absence of a character by comparing with the prefix. '$' is as good a prefix as any. If no parameter is supplied, line 1 will expand to IF $ EQU $ .... which is an equality, so we know there was no parameter.

Sometimes it's hard to think of the easy way....

One method would be to write the script to check if it was passed a particular parameter. If you configure the scheduled task to pass a parameter (e.g. 'scheduled') the script would know if it was called from the scheduler. In batch, you'd do something like this: if ("%1"=="scheduled") echo I am running from a scheduled task. Similar deal with VBS or Powershell.

More on the topic of parallelism. As it happens, I'm doing some work on this today. Recommendations and guidelines for the "max degree of parallelism" configuration option in SQL Server https://support.microsoft.com/en-us/kb/2806535 Good stuff here: https://www.brentozar.com/archive/2013/09/five-sql-server-settings-to-change/

If you like your retro computing, Kim Justice's Youtube channel is a real treat. https://www.youtube.com/user/elmyrdehory A sample Amiga programme.

As a food supplement, it isn't bad. However, you can make your own version easily with a Nutribullet or similar. Oats, pea protein (combine with rice protein for a better complementary protein combination), and some seed varieties. Huel has additional vitamins, but most people with good diets don't require vitamin supplements.

When your data is stored in a database called 'Northwinds' then it's time to leave.

You read about this sort of stuff on this site. The Daily WTF: Curious Perversions in Information Technology

Yes, I've seen this before, and yes, it is ridiculous. End of discussion.

That's showing you have a valid kbrtgt/ (ticket granting ticket) but you haven't got a valid HTTP/ service ticket yet. You should get this when the service makes a request for web services and is granted a service ticket by the kerberos controller.

Try this on the Linux machine. Use ktutil interactively. ktutil addent -password -p [email protected] -k 1 -e RC4-HMAC wkt youruser-kerberos.keytab q This will produce a keytab file - try the login again with this new keytab. - - - Updated - - - Also check that your /etc/krb5.conf file has correct realm/domain mapping information.

Have you tested the keytab with something like kinit [email protected] -k -t your_keytabfile If the keytab file is working, this should successfully init without needing to type a password.

Do you have duplicate SPNs? This has caught me out MANY times. On the (presumably) windows authenticaion box, run setspn -X This will show duplicate SPNs.

I hadn't considered that aspect before.

Currently watching Narcos on Netflix. Enjoying it, a very engaging drama based on the true life exploits of Pablo Escobar and the CIA agents on his trail.

Throwing extra hardware at the problem is a seductive concept, but you may not get the returns that you hoped for. You might find that adding processors without a MAXDOP limit could make your server slower. Before you add processors, you should first establish that you need extra processors. https://www.brentozar.com/archive/2013/12/q-can-high-maxdop-make-a-query-slower/ If you're seeing the (in)famous CXPACKET waits, your machine is spending time waiting for the parallel threads to be gathered together. It's worthwhile looking at the fundamentals first. Have you separated your OS, your database files, logs and temporary tables/files onto separate LUNs/disks? This can yield good results as zero cost apart from time spend re-organising. https://msdn.microsoft.com/en-us/library/bb402876.aspx Sometimes it's a good idea to step back and do some analysis before deciding what to do next. At the very worst, you'll have good grounds which justifies your hunch, and you'll learn more about your system. Brent Ozar is the guru's guru. His website is full of great stuff, and he publishes lots of scripts that can really get to the heart of the problem quickly. I've used them many times. Here's a good place to start. Be sure to explore the links from the 'Tools for baselines' section. These are solid gold. https://www.brentozar.com/archive/2015/02/slow-not-metric/

Two phone photos while out mountain biking the other week.

I hold a Converse opinion on that.

Have your people call my people.

Brief diversion - has anyone used one of these things? https://deals.slashdot.org/sales/lytro-illum-camera-2?&utm_source=slashdot.org&utm_medium=dealfeed-righthand&utm_campaign=lytro-illum-camera-2

Orange Creme is the finest confection. It's a fundamental axiom. The toffee ones, on the other hand, are chaff. Always the ones left in the tub.

I use Phatch for tasks like that. You can specify a max length and width and Phatch will resize to these restrictions. It can do a lot more besides. Getting Started - Phatch = PHoto & bATCH! To reclaim space, you can set the JPEG compression to about 70% which should be imperceptible for most non-critical work, but save a ton of space.

I listened to this podcast on my ride home tonight. It's really good stuff. You'll want to listen to this. 'Skinny fat', fasting for weight loss, feeling full by Dr Karl on triplej https://player.fm/series/dr-karl-on-triplej/skinny-fat-fasting-for-weight-loss-feeling-full

The usernames will be deleted as they belong in the database and will disappear with the database. However, the logins, which give you access to the server will not be deleted. As they're organised with the database prefix, they're easy to select and delete as a group.

The SIMS users and passwords are encrypted and stored within the SIMS database. From memory, the stored procedure that does this is called sims.db_p_transfer_logins, but I'll have to check when I'm back in work. DBAttach runs this procedure before it backs up the database so that the latest users and their passwords are stored. A simple way round your problem is to run the transfer logins routine on your main database, back it up, then restore and proceed as outlined in the previous posts.