On a QA server I need to give access to specific login  from  just one IP to log to this server.    I wrote This login  trigger    Create   TRIGGER tr_CheckIP ON ALL SERVER FOR LOGON AS BEGIN     DECLARE @IPAddress NVARCHAR(50) ;     If ORIGINAL_LOGIN()='test'       --print ORIGINAL_LOGIN()      begin       SET @IPAddress = convert(NVARCHAR(50),ConnectionProperty('client_net_address'))     --print @IPAddress     IF NOT EXISTS ( SELECT  IP                     FROM    master..IPAddress                     WHERE   IP = @IPAddress )         BEGIN               ROLLBACK          END     End END   However the trigger is preventing  the user from log although the IP exists in the IPAddress table.  Any idea where in the problem in the trigger
I have an app to deploy in production that uses 'honor system' security. That is, all users connect to the DB using a SQL user/passwd credential and the app manages permissions itself. The latter part doesn't bother me as much as the fact that the connection object contains embedded credentials and can be copied around freely. I'm try to find some way to limit connections to a more limited set of clients. I can create firewall rules to limit by IP, of course. Is there any way to 'prequalify' SQL logins either by Machine account or domain membership?
I ride regularly in the city with my a few valuables with me. My purse, phone, keys, company ID card etc. I hate having a bag on me while ride so I am looking for a solution to have these few items in a bike bag, but also have them safe if I stop somewhere to run into  a shop or a cafe for 15 minutes.   My original idea was to look for a small saddle or top tube bag that is lockable and also safely locked to the frame, and I can simply leave it there. As it turns out there is no such thing! Or I just did not find it?  My second idea was to search for a similar bag, but which is easily detachable and I can take it with myself as a waist bag for example. Same story, I couldn't find anything like this on the market.  Do you know any bag that could work for me? Or do you have an alternate suggestion for my conundrum?   Thank you very much if you take the time to answer! Ride safe! János Switch off Windows Update for a particular program or feature I'm getting really tired of unchecking the same Windows Update candidates so save hundreds of MB's of dowbloads, especially for programs I never use, that are in fact not even installed, and those I don't wish to update.  Is there any way to permanently, or until another explicit change, to turn off certain updates?  There is an option called 'Hide update', but that unsettles me a bit. How to generate a 2D array data structure in tikz? I need to illustrate a 2D array data structure in my document. This is a picture I found on the internet. I want something similar.    I also want to show the memory layout in the illustration. Something like this:   Can someone help me with drawing them in Tikz? Thanks in advance.  MWE  \documentclass{article} \usepackage[utf8]{inputenc} \usepackage{tikz} \usetikzlibrary{matrix,backgrounds}  \begin{document} \begin{tikzpicture}[font=\ttfamily, array/.style={matrix of nodes,nodes={draw, minimum size=7mm, fill=green!30},column sep=-\pgflinewidth, row sep=0.5mm, nodes in empty cells, row 1/.style={nodes={draw=none, fill=none, minimum size=5mm}}, row 1 column 1/.style={nodes={draw}}}]  \matrix[array] (array) { 0 &amp; 1 &amp; 2 &amp; 3 &amp; 4 &amp; 5 &amp; 6 &amp; 7 &amp; 8 &amp; 9\\   &amp;   &amp;   &amp;   &amp;   &amp;   &amp;   &amp;   &amp;   &amp;  \\}; \node[draw, fill=gray, minimum size=4mm] at (array-2-9) (box) {};  \begin{scope}[on background layer] \fill[green!10] (array-1-1.north west) rectangle (array-1-10.south east); \end{scope}  \draw (array-1-1.north)--++(90:3mm) node [above] (first) {First index}; \draw (array-1-10.east)--++(0:3mm) node [right]{Indices}; \node [align=center, anchor=south] at (array-2-9.north west|-first.south) (8) {Element\\ (at index 8)}; \draw (8)--(box); % \end{tikzpicture} \\ \begin{tikzpicture}[font=\ttfamily, array/.style={matrix of nodes,nodes={draw, minimum size=7mm, fill=red!30},column sep=-\pgflinewidth, row sep=0.5mm, nodes in empty cells, row 1/.style={nodes={draw=none, fill=none, minimum size=5mm}}, row 1 column 1/.style={nodes={draw}}}]  \matrix[array] (array) {  &amp;  &amp;  &amp;  &amp;  &amp;  &amp;  &amp;  &amp;  &amp; \\  &amp;   &amp;   &amp;   &amp;   &amp;   &amp;   &amp;   &amp;   &amp;  \\}; % \end{tikzpicture} \\ \begin{tikzpicture}[font=\ttfamily, array/.style={matrix of nodes,nodes={draw, minimum size=7mm, fill=blue!30},column sep=-\pgflinewidth, row sep=0.5mm, nodes in empty cells, row 1/.style={nodes={draw=none, fill=none, minimum size=5mm}}, row 1 column 1/.style={nodes={draw}}}]  \matrix[array] (array) {  &amp;  &amp;  &amp;  &amp;  &amp;  &amp;  &amp;  &amp;  &amp; \\  &amp;   &amp;   &amp;   &amp;   &amp;   &amp;   &amp;   &amp;   &amp;  \\}; % \end{tikzpicture} \end{document} Prove that, $\frac{a}{b}+\frac{b}{c}+\frac{c}{d}+\frac{d}{a}\ge 4$ where we do not use AM-GM inequality on the given statement to prove it. Space Expansion vs. Relative Motion Given 2 objects moving at some velocity $v$ relative to one another, is it possible to determine whether they are moving or whether the space between them is expanding? Installing an addon There is this addon that was built called Window Generator 2. It can be . However, when I go to the download link it shows up in a new tab as a bunch of code.  How can I download and use this addon in Blender? Recently, I have noticed that on most applications I have on Ubuntu 16.04, when I load the application, the window is displayed with a strange multi-coloured border (see the images below). If I maximise the window though, the border disappears and the window is displayed as expected.  This started happening for no apparent reason. If I reboot my machine, things return to normal at first, but after a while the problem comes back.  The issue occurs on most applications, including Nautilus, Software Centre, Terminal, System Settings, etc... I also get the same border appearing when I right click on the desktop, with the border surrounding the pop-up menu.  However, I have noticed that it does not happen on Chrome, but it does happen on other applications which did not come with Ubuntu by default.  Any ideas on what is causing the problem? Thanks! Removing minimize/maximize buttons in Tkinter What is the difference between the three sentences below?   I have been married with her for three years. I was married with her for three years. I married her for three years. In Captain America: Civil War, T'Challa takes the mantle of the Black Panther after his father is killed. As the Black Panther, he appears to have enhanced abilities.  In , the Russos talk about T'Challa having superpowers and being enhanced during Civil War     JOE: It can absorb the energy, so it’s much harder to damage him as a character, and you can see that in the movie he can take a lot of punishment including bullets to the face. He is very well trained. He’s from one of the wealthiest countries on the planet, so there’s great infrastructure there; very technologically advanced country. So he’s been trained at the highest levels to fight, but he also has his own superpowers, which derive from the mythology of his nation. Those will be explored more in Black Panther, it’s clearly evident when he’s able to fight the Winter Soldier out of costume, and go toe-to-toe with him, that he is an enhanced individual.    In Black Panther, we see that in order to become the Black Panther,       one must imbibe juice from the heart-shaped flower and visit the spirit plane after being buried.   But before this,       T'Challa must have his Black Panther powers removed prior to the ritual combat challenge, which he does twice in the film.   This raises the question of how T'Challa could have possibly become the Black Panther abroad - or if he even really had.  How did Black Panther have his powers during Civil War? What is the difference between therapy and treatment? A get() like method for checking for Python attributes The most efficient method to obtain the total entries into a mysql table Where are the Unity desktop wallpapers located? Please see the picture below. Where are the Unity desktop wallpapers located? Looking for a trilogy published around the early 80s.  Insect-like aliens are invading earth.  Humans' brains are placed in robotic bodies.  The protagonist is a child in one of these bodies.  He has to learn how to control the robot &amp; conserve his battery power.  Once train, he can fight back against the aliens using heat-guns + physical attacks.    The aliens are landing/spawning on sites all over the globe.  Part of the plot is discovering a method to disrupt their staging points.  It was probably young-adult oriented.  If anyone remembers this, thank you. dpkg exit with error parsing file `/var/lib/dpkg/status`, what to do? When I try to install any software, I encounter this error, and therefore I cannot update.  Preconfiguring packages ... dpkg: error: parsing file '/var/lib/dpkg/status' near line 51245 package 'oracle-xe':  mixed non-coinstallable and coinstallable package instances present N: Ignoring file 'gcl' in directory '/etc/apt/sources.list.d/' as it has no filename extension N: Ignoring file 'gcl' in directory '/etc/apt/sources.list.d/' as it has no filename extension E: Sub-process /usr/bin/dpkg returned an error code (2) Is there a way to see who voted on your posts? Alphabetically display the items in itemize Need Help Fixing Grub after Installing Ubuntu 13.04 x64 Alongside Windows 8 on a Lenovo IdeaPad Y400 with UEFI I have a Lenovo IdeaPad Y400 that came pre-installed with Windows 8. I would like to run Ubuntu alongside it in a dual-boot configuration. I've spent the past week fiddling around, re-installing both Windows and Linux in various configurations, and I've come awfully close to success, but seem to have hit a snag with Grub.  For my most recent attempt, I took the following steps:   Disabled Secure Boot Re-imaged Windows 8 from a hidden recovery partition, effectively restoring the machine to factory state Activated an option called Legacy Support in the BIOS (or is it UEFI now?) Booted Ubuntu 13.04 x64 from a USB stick, chose "install alongside Windows" and accepted all default options After a restart, found that I could boot Ubuntu, but could not boot Windows Once into Ubuntu, I ran Boot Repair with recommended settings and accepted all defaults. When Boot Repair finished, I was presented with the following message:      The boot files of [The OS now in use - Ubuntu 13.04] are far from the   start of the disk. Your BIOS may not detect them. You may want to   retry after creating a /boot partition (EXT4, >200MB, start of the   disk). This can be performed via tools such as gParted. Then select   this partition via the [Separate /boot partition:] option of [Boot   Repair]. ()    I followed the instructions at the url in the message, creating a 1GB EXT 4 partition near the start of the drive  when I tried to run Boot Repair again, the "Separate /boot partition" option on the "Grub Location" tab was disabled.  The new partition is /dev/sda11 and has the label GRUB. On restart, I get the following error message:      error: file '/boot/grub/i386-pc/normal.mod' not found.    grub rescue>    However, if I manually choose the boot partition by hitting F12, I can boot into Windows no problems. Selecting Ubuntu from the boot device menu gives me a Grub menu with the following options:      Ubuntu      Advanced options for Ubuntu       Windows UEFI recovery bootmgfw.efi      Windows Boot UEFI recovery       Windows UEFI recovery LrsBootmgr.efi      Windows Boot UEFI recovery bkpbootx64.efi       Windows Recovery Environment (loader) (on /dev/sda3)       Windows 8 (loader) (on /dev/sda5) System setup    Selecting Ubuntu from this menu allows me to get to my Ubuntu desktop. I haven't tried the other options yet for fear of losing the progress that I've made.   So it looks like I have successfully dual-booted the machine, but that Grub is broken for some reason or another.   My current partition scheme can be seen at:   Thanks in advance - Jonathan Duty Free in the USA. Why do I have to be given my purchase as I board the plane? I am not one for buying things in airports but recently my wife asked me to get her an alcoholic beverage while flying from the USA to Ireland (JFK-DUB). I made the purchase in JFK and was surprised to be told I had to collect it when departing for my flight as I board the plane. The sales assistant's English wasn't their best so I may have misheard and my Yorkshire twang may have thrown her, but I was somewhat surprised as to why I couldn't carry the bag myself to the plane.  Is there a law that prevents me from carrying my purchase to the plane or is this an added service I was charged, which I was duped into paying?  When boarding the plane there were several others who had to pick up their sealed duty free bags (why sealed?) so it wasn't just me. No explanation was given.