The Weird and The Wonderful

2-Jul-18 10:30

A search for actionable information about the distinction between const and static const led me to c - Are const Local Variables Implicitly static? - CS50 Stack Exchange. Finding the answer wanting, I changed the function that prompted me to raise the question in the first place. Examining the disassembly reminded me of a discovery that I made so long ago that I had forgotten the details that led me to almost always pair static and const when I define arrays of constants, such as lookup tables and the like. Details are in the 3rd answer shown in the Stack Overflow topic.

David A. Gray
Delivering Solutions for the Ages, One Problem at a Time
Interpreting the Fundamental Principle of Tabular Reporting

Chris Maunder2-Jul-18 10:35

Chris Maunder

2-Jul-18 10:35

Nice one.

cheers
Chris Maunder

David A. Gray2-Jul-18 10:37

2-Jul-18 10:37

Thank you, Sir!

David A. Gray
Delivering Solutions for the Ages, One Problem at a Time
Interpreting the Fundamental Principle of Tabular Reporting

Peter_in_27802-Jul-18 17:41

Peter_in_2780

2-Jul-18 17:41

At first I thought this might be a compiler quirk, so I ran a couple of trivial examples through gcc -s. That does substantially the same, so I'm guessing it's a language feature. One for the standards committee "lawyers".

Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012

David A. Gray2-Jul-18 21:08

Good Regular Expression Fiddle

2-Jul-18 21:08

Thanks much for duplicating the observation with the other popular C compiler. As I said, I observed the same thing about a dozen years ago, but I had forgotten the details. Anyway, so far as I know, the same holds whether your code is straight ANSI C or ANSI C++. The test case that I cited in the Stack Overflow article is straight ANSI C.

David A. Gray
Delivering Solutions for the Ages, One Problem at a Time
Interpreting the Fundamental Principle of Tabular Reporting

David A. Gray27-Jun-18 8:20

27-Jun-18 8:20

I just found a very nice regular expression fiddle form at Online regex tester and debugger: PHP, PCRE, Python, Golang and JavaScript

David A. Gray
Delivering Solutions for the Ages, One Problem at a Time
Interpreting the Fundamental Principle of Tabular Reporting

Mike Hankey27-Jun-18 9:21

Mike Hankey

27-Jun-18 9:21

I have used Expresso[^] for a long time and really like it. Granted I don't use regex a lot, out of sheer terror but when I do I use Expresso. Smile | :)

Everyone has a photographic memory; some just don't have film. Steven Wright

David A. Gray27-Jun-18 9:52

27-Jun-18 9:52

Thank you for reminding me about Expresso. Though I've seen it before, I've never put forth the effort to install it.

A quick look at the screen shot on his home page tells me right away why you like it; it's a full-service regular expression editor that looks like it would meet most needs of anyone whose use of regular expressions is infrequent, and would be a nice productivity tool for experienced regular expression authors.

Working with Perl for the last 20 years has required becoming fairly comfortable reading and writing regular expressions. Although I write less Perl today than I did fifteen years ago, my general purpose text editor, UltraEdit, has supported Perl/AWK style usage of regular expressions in its find and replace dialog boxes for at least the last nine years, and I use them regularly. Hence, between the two, I can usually cobble together a usable expression pretty quickly. I found this online fiddle form when I went in search of a regular expression idiom that I have almost never used, the "not followed by" idiom. Incidentally, I needed it in a regular expression to search for a particular type of syntax error in a manually edited Visual C++ project configuration file. (I know, I have no business editing those .vcxproj files by hand, but I've become somewhat obsessed lately with fully parameterizing my build configurations, which can be done much more quickly by editing the configuration directly than by clicking around in the Visual Studio property page editor.

While I will probably download Expresso for use in my home office, there remains, nevertheless, a place for online fiddle forms when I must use a computer that doesn't belong to me, meaning that I must get permission to install tools of my choosing on it. That goes double when I need to borrow a clients's computer for only a few minutes to help them solve a problem.

David A. Gray
Delivering Solutions for the Ages, One Problem at a Time
Interpreting the Fundamental Principle of Tabular Reporting

David A. Gray27-Jun-18 10:01

27-Jun-18 10:01

Mike Hankey wrote:
Everyone has a photographic memory; some just don't have film.

I just noticed the quote in your sig, and told my wife. She howled. Big Grin | :-D

David A. Gray
Delivering Solutions for the Ages, One Problem at a Time
Interpreting the Fundamental Principle of Tabular Reporting

Mike Hankey27-Jun-18 10:19

Mike Hankey

27-Jun-18 10:19

Glad she liked it.

I understand about the regex online thing, just didn't know if you knew about Expresso.

Everyone has a photographic memory; some just don't have film. Steven Wright

David A. Gray27-Jun-18 10:22

27-Jun-18 10:22

I vaguely recall reading about Expresso several years ago, when I was working on one of those computers onto which I was forbidden to install most tools, even of the FOSS variety.

David A. Gray
Delivering Solutions for the Ages, One Problem at a Time
Interpreting the Fundamental Principle of Tabular Reporting

inch29-Jun-18 1:22

inch

29-Jun-18 1:22

Not seen that before. My fave is RegExr: Learn, Build, & Test RegEx[^]

David A. Gray29-Jun-18 7:56

Prepping for SQL Server Update

29-Jun-18 7:56

There are probably more RegExp fiddle forms than there are JSFiddle, JSONFiddle, and all the rest combined. What appealed to me about this one was the clear feedback about text entered into the test text box.

David A. Gray
Delivering Solutions for the Ages, One Problem at a Time
Interpreting the Fundamental Principle of Tabular Reporting

#realJSOP21-Jun-18 5:13

21-Jun-18 5:13

I came up with this sql to discover jobs and steps in those jobs that use a SSIS package (because our DBA "isn't a programmer")...

SQL

DECLARE @serverPath = 'MyServerPath'
;WITH cte AS
(
    SELECT	b.job_id AS JobID,
            b.name AS JobName,
            b.[enabled] AS JobEnabled,
            a.step_id AS StepNumber,
            CASE WHEN RTRIM(LEFT(UPPER(a.command),5)) LIKE '/FILE' THEN 'File System' ELSE 'Package Store' END AS Location,
            REPLACE(
                REPLACE(
                    REPLACE(
                        REPLACE(	
                            REPLACE(
                                REPLACE(
                                    REPLACE(
                                        REPLACE(UPPER(a.command), '/DTS ','')
                                        ,'/FILE ','')
                                    ,'/SQL ','')
                                , ' /CHECKPOINTING OFF', '')
                            ,' /REPORTING E', '')
                        ,' /X86', '')
                    , ' /SERVER '+@serverPath, '') 
                , '"', '') AS PackagePath
    FROM msdb.dbo.sysjobsteps as a
    INNER JOIN msdb.dbo.sysjobs as b on b.job_id = a.job_id
    WHERE a.subsystem = 'SSIS' AND a.command NOT LIKE '/serv%'
)
SELECT * FROM cte
ORDER BY JobEnabled DESC, Location, JobName, StepNumber

".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

modified 21-Jun-18 12:35pm.

S Douglas21-Jun-18 5:29

S Douglas

21-Jun-18 5:29

Odd, as long as there are some standards setup and working.

Just use Copy-DbaAgentJob – dbatools

Common sense is admitting there is cause and effect and that you can exert some control over what you understand.

#realJSOP21-Jun-18 6:33

21-Jun-18 6:33

Nothing is ever "easy" on a DoD installation...

For instance, I have a MCSA for SQL Server (2012), but I'm not allowed to be a DBA on our department database server.

My Active Directory account can't be used to run a job - the DBA has to change ownership to a service account, and if I need to modify the job, he has to toggle ownership back to me, and which I'm done, I have to request that he toggle it back to the service account.

Initially, I could create stored procs, but didn't have permission to execute them (that took a week to iron out).

Other chaos has ensued.

S Douglas21-Jun-18 10:13

S Douglas

21-Jun-18 10:13

I will say this, someone in MS needs to be kicked for the way the Agent permissions work. Its a mess, I loathe the way they are structured. I am to to the point where I've started telling management we need need a better way to have jobs run.

As far as running a stored procedure, umm thats easy.
GRANT EXECUTE ON Schema::dbo TO [user or group];
GRANT VIEW DEFINITION TO [user or group];

Common sense is admitting there is cause and effect and that you can exert some control over what you understand.

#realJSOP21-Jun-18 10:27

21-Jun-18 10:27

Take a look at this article series. I wrote an agent utility for SQL express, but it's entirely usable for SQL Server enterprise.

SQLXAgent - Jobs for SQL Express - Part 1 of 6[^]

Because it's written for SQL Express, there are some things that aren't supported, but it's fairly full featured.

Dave Kreskowiak21-Jun-18 7:45

21-Jun-18 7:45

Apparently your "non-programmer" DBA can't write queries either.

What does he do? Create empty databases, and swap ownership and permissions on objects?

Asking questions is a skill
CodeProject Forum Guidelines
Google: C# How to debug code
Seriously, go read these articles.

Dave Kreskowiak

#realJSOP21-Jun-18 8:33

21-Jun-18 8:33

Dave Kreskowiak wrote:
What does he do? Create empty databases, and swap ownership and permissions on objects?

I've never seen him create a database. All he does that I can verify is that he tells me when I can't do something.

The latest dust-up involves installing WinSCP on my local box so I can test data retrieval via FTP. It can only be installed on a server, evidently, so I I'm flying blind when I create a new job that performs a FTP transfer...

Dave Kreskowiak21-Jun-18 10:28

21-Jun-18 10:28

I feel your pain.

When I was at CBP, we were all told "Work smarter, not harder" and in the very next breath, "You cannot write code for or script anything".

A massive contradiction in a single paragraph. WTF | :WTF:

Asking questions is a skill
CodeProject Forum Guidelines
Google: C# How to debug code
Seriously, go read these articles.

Dave Kreskowiak

#realJSOP26-Jun-18 5:56

26-Jun-18 5:56

I talked to him today and he said I was hammering him on the ownership toggle and he's gonna try to get me SA permissions - I guess I wore him down. Smile | :)

Dave Kreskowiak26-Jun-18 6:19

26-Jun-18 6:19

It's amazing. "I'm sick of you making me do work so I'll just give you the permissions to do it yourself."

Why didn't he just save himself the pain and do that in the first place?

SMH, some people... Smile | :)

Asking questions is a skill
CodeProject Forum Guidelines
Google: C# How to debug code
Seriously, go read these articles.

Dave Kreskowiak

#realJSOP26-Jun-18 7:04

26-Jun-18 7:04

I suggested it to him four years ago. After getting mad about it when he argued with me, I figured I'd just follow his rules. When my boss complained, I told her, "That's the way they wanna play it, so I'll be happy to oblige".

He still has to ask IA (the pointless security agenda Nazis) if it's okay.

What's really weird is that they hired a sql developer, and even without ANY certifications, she immediately had SA permissions, but me - with the *required MCSA certification* - couldn't get the same permissions.

F*ckin lunacy...

Dave Kreskowiak26-Jun-18 7:33